Get All SharePoint Site Collection Owners (Primary/Secondary Site Collection Administrators)

Requirement is to find out owners of each SharePoint site collection in the environment.We needed this data to get approvals on critical changes and to inform site owners prior to maintenance windows. Simple! Use STSADM command: On SharePoint 2007 and above, STSADM command can be used to get primary owner details of…

Read more

Format SharePoint Number Column without Commas

Problem: SharePoint Number columns shows, (comma) in View/Display Forms. There are specific numeric columns, User wanted to display without commas. There is no direct way to remove comma/avoid thousand separators in SharePoint Number fields, But the below tricks help to get SharePoint 2007/2010/2013 number column values without commas. Solutions: Here are some…

Read more

Create SharePoint Alert for a Group

SharePoint doesn’t provide a direct way to create alerts for groups. Alerts are always targeted to individual user accounts in SharePoint. If you have a requirement to create alerts for a group of people, create an E-mail enabled AD security group and add an alert to it from SharePoint. Set alert to…

Read more

Increase Maximum Size of Site Template, List Templates in SharePoint

In SharePoint 2007, You can’t save a list or site template (.stp ) file which is bigger than 10MB. MOSS 2007 gives an error message: “The list is too large to save as a template. The size of a template cannot exceed 10485760 bytes.” When you try to save a list or…

Read more

Copy SharePoint List Column Values from One to Another using PowerShell

Requirement: Copy Column Values from One to Another in SharePoint How to copy column value to another column in SharePoint? In some situations, we may have to copy SharePoint list column values from one column to another. Say, for E.g. OOTB column doesn’t provide a way to enter more than 255 characters…

Read more

Document Expiration Monitor – Automation with PowerShell Script

Requirement: There are bunch of document libraries with several documents loaded on various site collections. We’ve to monitor their expiry date based on a column and send e-mail notification to all members of  a  SharePoint Group. Also all E-mails sent should be logged in a tracking list. Solution: Lets write a PowerShell…

Read more

Start SharePoint Search Crawl using PowerShell

For some reasons, SharePoint search crawl scheduled didn’t trigger. So I used this PowerShell script and Windows Task scheduler to trigger Incremental crawls. Start SharePoint Search Full/Incremental Crawl using PowerShell: We can also start / stop Search crawls in SharePoint 2013 or in SharePoint 2010 using this single line of PowerShell script:…

Read more

“This field can have no more than 255 characters.” Error in Multiline Text Columns

Getting  “This field can have no more than 255 characters.” error on SharePoint Multiple lines of text  columns? Well, the fix is simple, we’ve the property  “Allow Unlimited length in document libraries” on Multiple lines of text fields. Once enabled, technically it can hold content up to 2 GB. We can also…

Read more

Enable/Disable Custom Error by editing Web.Config using PowerShell

To reveal actual errors in SharePoint, we used to turn off custom error page by editing web.config file, located in the root of SharePoint virtual directory. Open the web.config in Notepad Search for “CallStack”, Change it from “false” to “true” Search for “CustomErrors mode”, Change its value from “On” to “Off” Save…

Read more