Friday, March 23, 2018

How to Filter a SharePoint Date Column by Range

In a SharePoint view you can add a filter on any date column (Created and Modified Date).
The format is MM/DD/YYYY

Example :

For open ended date range:

If you enter an invalid date, you get an error message:

You can also use a relative filter as well. An example of this would be to filter on content over the past week; you’d enter a value like this below.

Wednesday, February 7, 2018

Configure a document library to require check-in/check-out

Only people who have Full Control or Design permissions can set up libraries to require check-in/check-out of files.

To require check-in/check-out of files
11. Navigate to the library you plan to work in. If the library name does not appear in the Quick Launch pane, click All Site Content, and then select the name of your library.

22. On the ribbon, in the Library Tools group, click the Library tab.Click Library Settings.

43. On the Library Settings page, under General Settings, click Versioning settings.

54. In the Require Check Out section, under the Require documents to be checked out before they can be edited? Question, select Yes.

55. Click OK to close the dialog box and return to the Library Settings page.

Monday, November 6, 2017

“Alert me” option missing in SharePoint

Issue Description

Recently in our SharePoint 2013 farm, I had noticed that the "Alert Me" button was missing from library tab in 
SharePoint Ribbon.


1. Please try this article first -  “Alert me” option missing in SharePoint

2. If this solution dint help, try using the below STSADM or PowerShell command to enable the alerts:

stsadm -o setproperty -pn alerts-enabled -pv true -url http://webappURL
$webapp=Get-SPWebApplication "http://webappURL"
$webapp.AlertsEnabled = $true


Tuesday, October 31, 2017

How to check for proxy settings in a server

1. Windows Server 2003 and before:

Open a Command Prompt window and type :

2. After Windows Server 2003:

Open a Command Prompt window and type :
netsh winhttp show proxy

Monday, October 23, 2017

SharePoint 2013 People Picker error: “Sorry, we’re having trouble reaching the server"

Issue Description

I was working on a SharePoint 2013 site and trying to add some users and got the below error

I tried adding the same user on other site collections but same error.
Also checked the Event Logs but couldn’t find anything useful


I did an IISRESET and this fixed the issue

Thursday, October 5, 2017

Difference between Service Packs , Cumulative updates, Public Updates and Security Updates

Service Pack
A tested, cumulative set of all hotfixes, security updates, critical updates, and updates. Additionally, service packs may contain additional fixes for problems that are found internally since the release of the product. Service packs my also contain a limited number of customer-requested design changes or features.

What is included: new fixes, new functionality, all previously released fixes (older Service Packs, CUs, PUs)

Cumulative Update (CU)
A Cumulative Update includes fixes for problems with our product that have been reported by customer in context of support cases.

What is included: new and all previously released fixes (CUs and PUs) since the oldest supported service pack (within the first 12 month after a Service Pack has been released the CU includes also fixes released after the previous service pack)

Public Update (PU)
A Public Update usually includes security fixes for the product or fixes for problems which affect a broad number of customers.

What is included: Review the KB article for each public update in detail to see which fixes are included.

Security Update
A widely released fix for a product-specific, security-related vulnerability. Security vulnerabilities are rated by their severity. The severity rating is indicated in the Microsoft security bulletin as critical, important, moderate, or low.

References : 1, 2

Tuesday, February 14, 2017

Create State service application.

A state service application is the container for state service databases.

Using Windows PowerShell

1. Click SharePoint 2013 Management Shell.
2. From the Windows PowerShell command prompt (that is, PS C:\>), type the following command :

New-SPStateServiceDatabase -Name "State Service Database" | New-SPStateServiceApplication -Name "StateServiceApp1" | New-SPStateServiceApplicationProxy -DefaultProxyGroup

Create a Visio Graphics Service service application

Using Central Administration

To create a service application, you must be a member of the farm administrators group.

1. Browse SharePoint 2013 Central Administration.
2. On the SharePoint Central Administration website Home page, in the Application Management section, click Manage service applications.
3. On the ribbon, click New, and then click Visio Graphics Service. Type a name for the new service application.
4. Choose an existing application pool or create a new one.
5. Choose whether to create a Visio Graphics Service Application Proxy (recommended).Click OK.

Using Windows PowerShell

1. Click SharePoint 2013 Management Shell.
2. From the Windows PowerShell command prompt (that is, PS C:\>), type the following command :

New-SPVisioServiceApplication -Name <ServiceAppName> -ApplicationPool <AppPoolName> -AddToDefaultGroup

New-SPVisioServiceApplication -Name "Visio Graphics Service Application" -ApplicationPool "SharePoint Hosted Services" -AddToDefaultGroup

SharePoint: Missing “Manage services on server” in Central Administration

I was browsing to Central Administration site and on SharePoint 2013 but the “Manage services on server” menu option was completely missing even though I’m a Farm Administrator.

This menu option will only show up if IE is running in Administrator mode.   Right click on the IE icon  and choose “Run as Administrator”.

Tuesday, December 13, 2016

How to Start and Stop the Distributed Cache service

To start and stop the Distributed Cache service by using Central Administration

1. In Central Administration, click Application Management.
2. In Service Applications, click Manage Services on Server.
3. On the Services on Server page, locate the Distributed Cache service.
4. If the Distributed Cache service is started and you want to stop the service, under Action, click Stop. If the Distributed Cache service is stopped and you want to start the service, under Action, click Start.

To start the Distributed Cache service by using SharePoint 2013 Management Shell

At the SharePoint Management Shell command prompt, run the following command:

1. $instanceName ="SPDistributedCacheService Name=AppFabricCachingService"
2. $serviceInstance = Get-SPServiceInstance | ? {($_.service.tostring()) -eq $instanceName -and ($ -eq $env:computername}
3. $serviceInstance.Provision()