SharePoint 2007 with large MSSBatchHistory table – SP3 Upgrade

While the end date for MOSS 2007 SP2 support is coming closer, most of the them are planning to upgrade to SP3 no sooner than later. It is  extremely important to plan carefully to avoid any problem during the patching process in a large environment. One of the important update that came in April 2011…


Manage Web Part Permissions using PowerShell

  PowerShell script to manage permissions of web parts in Web Part gallery. # Get Web Object $web = Get-SPWeb "Web URL" # Get Web Part Gallery list # SPListTemplateType.WebPartCatalog Enum value 113 $list = $web.GetCatalog(113) $listItemCollections = $list.GetItems() $listItemCollections | ForEach-Object { $item = $listItemCollections | Where-Object {$_.Name -match "ContentQuery.webpart"} } $item.BreakRoleInheritance($true) # Remove…


List of securable objects (sites and lists) that have unique permission

In SharePoint, a securable object is a site, list, library, folder, document, or item for which permissions levels can be assigned to users or groups.  By default, all lists and libraries within a site inherit permissions from the site. You can use list-level, folder-level, and item-level permissions to further control which users can view or…


Analyze Test-SPContentDatabase Output

Windows PowerShell Test-SPContentDatabase cmdlet is used to test a content database against a Web application to verify all customizations referenced within the content database are also installed in the web application.  There are number of articles that talk about using this cmdlet for SharePoint 2010 upgrade, so let us not get deep into that. The…


Managing User Profile Service Application permissions using PowerShell

  When User Profile Service application is configured in SP 2010, by default NT Authority\Authenticated Users and all authenticated users are granted permissions to create My Sites and use other features (personal and social) provided by user profile service.  To disable users to create mysite and use other features, use Revoke-SPObjectSecurity and Set-SPProfileServiceApplicationSecurity powershell cmdlets….


Setting Managed Metadata Service Connection Properties using PowerShell

  In SharePoint 2010 service applications, the managed metadata service connection properties can be set using the cmdlet Get-SPMetadataServiceApplicationProxy # Get Metadata service application proxy $metadataserviceapplicationname = "Managed Metadata Service" $metadataserviceapplicationproxy = get-spmetadataserviceapplicationproxy $metadataserviceapplicationname # This service application is the default storage location for Keywords. $metadataserviceapplicationproxy.Properties["IsDefaultKeywordTaxonomy"] = $true # This service application is the default…