Usage and Health Data Collection Proxy Stopped in SharePoint 2013

Problem: Usage and Health Data Collection Service Application collects Data for Health Monitoring and usage Analytics Service. We found the Usage and Health Data Collection Proxy status in “Stopped” state, after deploying SharePoint 2013 to a new environment, from: Central Administration >> Application Management  Manage Service Applications Page Solution: If you see…

Read more

Find SharePoint Site Column Usage – Report

When trying to delete a SharePoint site column, it gave me an alert saying “Site columns which are included in content types cannot be deleted. Remove all references to this site column prior to deleting it.”  Alright, Lets use PowerShell to find what lists or content types are using a particular site…

Read more

How to Add your SharePoint Library to “Favorites” in Windows?

Here is a nifty trick to add your SharePoint library under “Favorites” section. If needed, you can rename it even. Once added, this location can be used from Open/Save dialog boxes!

Read more

How to upload a List Template in SharePoint using PowerShell?

Requirement: Upload a custom list template to specific site collections in a web application. While upload a list template using from SharePoint web interface is simple, wanted to automate this process as its repeating for multiple site collections. PowerShell to upload list template in SharePoint: Here is the PowerShell script to upload…

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. While the Data Sheet view is one solution, Its not available for…

Read more

How to Use RunWithElevatedPrivileges in PowerShell Scripts for SharePoint?

We use RunWithElevatedPrivileges method to impersonate System Account (Application pool identity), which is granted with FULL control access rights via web application user policy. Here is an example of using RunwithElevatedPrivileges with PowerShell: This PowerShell example uses run with elevated privileges in SharePoint to add new site collection administrator.

Read more

SharePoint Rich Text Editor Toolbar Missing – Solution

A user reported an issue: SharePoint rich text editor toolbar is missing on list columns! I verified that the SharePoint list columns are enabled with “Rich Text” capabilities, but still, rich text editor toolbars are missing! Solution: Open SharePoint site in Internet Explorer 32 bit mode! Here is how: Type “Internet Explorer”…

Read more

SharePoint Search Query Suggestions

Search suggestions is one of the great new feature introduced in SharePoint 2010, enhanced in SharePoint 2013. Search query suggestions are words that appear under the search box as users type a search query. (also known as Pre-query suggestions). SharePoint Search suggestions are automatically generated: When users have clicked any of the…

Read more

Force Run SharePoint Health Analyzer Jobs on Demand using PowerShell

We may want to run SharePoint health analyzer on-demand to check if everything is alright on the farm, without waiting for them to run automatically. Well, as discussed in another article, Run SharePoint 2010 Timer Jobs On-Demand with PowerShell, we can force run SharePoint Health Analyzer timer Jobs on Demand with PowerShell!…

Read more