Create Host Name Site Collection Using Powershell Script

[string] $ContentDB =  $(Read-Host -prompt "Content Database Name")
[string] $DatabaseServer =  $(Read-Host -prompt "Database Server Name")
[string] $WebApplication =  $(Read-Host -prompt "Web Application Name")
[string] $siteUrl = $(Read-Host -prompt "Site Url")
[string] $SiteName = $(Read-Host -prompt "Site Name")
[string] $SiteOwnerID = $(Read-Host -prompt "Site Owner ID")


New-SPContentDatabase $ContentDB -DatabaseServer $DatabaseServer -WebApplication $WebApplication
New-SPSite $siteUrl -HostHeaderWebApplication $WebApplication -Name $SiteName -OwnerAlias $SiteOwnerID -language 1033 -Template 'STS#0' -ContentDatabase $ContentDB

Deploy wsp 2010

//To Get Backup of wsp
$file - $farm.Solutions.Item("filename.wsp").SolutionFile
$file.SaveAs("D:\filename.wsp")



//To Add wsp sol on farm
Add-SPSolution -LiteralPath "D:\filename.wsp"


//to install wsp
Install-SPSolution -Identity filename.wsp -WebApplication "http://site:port/"

Time Conversion from UTC to IST

Put:

private static TimeZoneInfo INDIAN_ZONE = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");

as a field.

Then, use:

DateTime indianTime =  TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);

to get the time as needed.

public DataTable ChangeCreatedTime(ClientContext context, DataTable dt)
        {
            try
            {
                foreach (DataRow dr in dt.Rows)
                {
                    DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(Convert.ToDateTime(dr["Created"].ToString()), INDIAN_ZONE);
                    dr["Created"] = indianTime.ToString();
                }
                dt.AcceptChanges();
            }
            catch (Exception ex)
            {
                WriteException(context, string.Empty, "Class File", "ChangeCreatedTime(ClientContext context, DataTable dt)", ex.Message);
            }
            return dt;
        }

Backup, Restore and Enable Dev Site Feature of Site Collection Using Powershell Script

Backup SIteCollection
 Backup-SPSite http://sitename.com/ -Path D:\backupfilename.bak –UseSqlSnapshot

Create New SiteCollection
Get-SPWebTemplate
$template = Get-SPWebTemplate "DEV#0"
New-SPSite -Url "http://domain:port/sites/sitename" -OwnerAlias "domain\username" -Template

Restore SiteCollection Backup
Restore-SPSite -Identity http://domain:port/sites/sitename  -Path "D:\backupfilename.bak" -Verbose -


Enable Developer Site Feature
Enable-SPFeature e374875e-06b6-11e0-b0fa-57f5dfd72085 -url http://domain:port/sites/sitename

Search & Restore Recycle Bin Item using Powershell

Step1. Run the below script to find out about the file in site collection recycle bin.

(Get-SPSite "http://SERVERNAME:PORT/").RecycleBin | ?{$_.Title -match "DeletedFile"}

If a matching file is found, Powershell will display information about the file. You will also be able to find who deleted it.


Step 2. Now take the ID of the item and restore back to the original location.

(Get-SPSite "http://SERVERNAME:PORT").RecycleBin.Restore("e7652991-b3b7-4df2-a3c8-39b76a8e98d3")

Dont forget to run PowerShell as administrator.