Saturday, August 24, 2013

Power Shell script to delete SharePoint Property bag Values.

# Add Powershell Snapin

Add-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue

# Set the variable to removed from property bag

$RemovePropertyBag = "DBConString"

# Get the central admin URL to delete the Property bag value at farm level

$SiteUrl = Get-SPWebApplication -includecentraladministration | where { $_.DisplayName -eq "Sharepoint Central Administration v4" }

# Load Required Assemblies

[System.Reflection.Assembly]::Load("Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")

[System.Reflection.Assembly]::Load("Microsoft.Practices.ServiceLocation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35")


[System.Reflection.Assembly]::Load("Microsoft.Practices.SharePoint.Common, Version=2.0.0.0, Culture=neutral, PublicKeyToken=ef4330804b3c4129")


 $site = New-Object Microsoft.SharePoint.SPSite($SiteUrl.URL)

# Get Service locator context and config Manager to set the site context

$serviceLocator = [Microsoft.Practices.SharePoint.Common.ServiceLocation.SharePointServiceLocator]::GetCurrent()

$configManager = $serviceLocator.GetInstance([Microsoft.Practices.SharePoint.Common.Configuration.IConfigManager])


$configManager.SetWeb($site.RootWeb);


 # Get Property Bag

$farmBag = $configManager.GetPropertyBag([Microsoft.Practices.SharePoint.Common.Configuration.ConfigLevel]::CurrentSPFarm)

# set the Value

$configManager.SetInPropertyBag($RemovePropertyBag, "", $farmBag)

write-host "Removing PropertyBag Values $RemovePropertyBag successful"

PowerShell Script to backup WSP from Central Admin's solution gallery


For a specific solution backup

$solution = Get-SPSolution $packageName -ErrorAction SilentlyContinue
# Get the File name from Solution file.
$filename = $solution.SolutionFile.Name

# script to get the location where the script is running -- folder location.
$BaseFolder = (Get-Location -PSProvider FileSystem).ProviderPath

# Save the file to Disk
$solution.SolutionFile.SaveAs("$BackupFolder\$filename")


To backup all the solutions from central admin' solution gallery

$BaseFolder = (Get-Location -PSProvider FileSystem).ProviderPath
$SPSolutions = get-spsolution
foreach($solution in $spsolutions)
{
$filename = $solution.SolutionFile.Name
$solution.SolutionFile.SaveAs("$BackupFolder\$filename")
}

Tuesday, August 13, 2013

Power Shell Script to Hide NewsFeed, Sites, Sky Drive top menu bar in SharePoint 2013

In order to hide the menu bar , We have to make below node text to empty by using PowerShell

i,e. Div tag shoud look like
TODO:
$WebApp =  get-spwebapplication("Any Specific WebApp URL")
$WebApp.SuiteBarBrandingElementHtml = ""
$WebApp.Update()

This can be achieved using Java Script on Master Page or by editing the same in SharePoint designer.