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 Administra…

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 usin…

How to Add your SharePoint Library to "Favorites" in Windows?

Here is a nifty trick to add your SharePoint library under "Favorites" section. Open your SharePoint library in Explorer view Right click on "Favorites" and choose "Add current location to favorites" Alternatively, you can just drag and drop the folder icon from …

How to Upload a List Template in SharePoint 2013 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 SharePo…

Copy SharePoint List Column Values from One to Another using PowerShell

Requirement: Copy Column Values from One to Another 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 in Multiple Lines of Text field. As user alr…

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: Add-PSSnapin Microsoft.SharePoint.PowerShel…

SharePoint Rich Text Editor Toolbar Missing - Solution

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 bi…

SharePoint 2013 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…

Find Top 10 Site Collections based on its Usage during Last Month

PowerShell Script to find top 10 SharePoint 2007 site collections based on its usage hits: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") #Functions to Imitate SharePoint 2010 Cmdlets in MOSS 2007 function global:Get-SPWebApplication($WebAppURL) { …

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 in the farm, without waiting for them to run automatically. Well, as discussed in my another article, Run SharePoint 2010 Timer Jobs On-Demand with PowerShell , we can force run SharePoint Health Analyzer …

How to Disable "I Like It" "Tags & Notes" in SharePoint 2010?

'I Like it' and 'Tags and Notes' features are introduced in SharePoint 2010 to improve user collaboration, social communication capabilities and to enable users to provide their feedback on items, pages, etc. However, not all SharePoint environments requires this feature, so here …

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. …

Fix "Sorry, this site hasn't been shared with you." Error in SharePoint 2013

Typically, if you don't have access to a SharePoint 2013 site and access requests are not enabled, You get : "Sorry, this site hasn't been shared with you" message when you try to access any SharePoint 2013 sites. Its a common issue and simply means that you have not been grante…

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: Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction Silent…

SharePoint 2013 Import Spreadsheet Errors and Solutions

Error: The list cannot be imported because a Microsoft SharePoint foundation-compatible spreadsheet application is not not installed or is not compatible with your browser. Solution: Use Internet Explorer 32 bit version! How to Open Internet Explorer 32 bit version? Go to start >>…

"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 c…

How to Get Managed Account Password in SharePoint?

SharePoint Managed accounts feature was introduced in its 2010 version, and of course its a wonderful feature to manage service accounts (I remember those old days.. We used to create a batch file to update password for each and everything in SharePoint 2007!). So, We utilized managed account…