Restart SharePoint Timer Service Remotely using PowerShell

SharePoint Timer service must be restarted for certain configuration changes in SharePoint administration activities. To restart timer service in SharePoint, follow these steps: Login to your SharePoint Web Front End Server(s) Open Services console ( Start >> Run >> Services.msc) …

Get SharePoint Site Collection, Web, List Objects from GUID

Requirement: On Nintex workflow databases, Ran a query to fetch workflow usage statistics, and the query gave GUIDs of SPSite, SPWeb and SPList objects! SELECT TOP 100 I.WorkflowName, I.WorkflowInstanceID, I.SiteID, I.WebID, I.ListID, I.ItemID, I.WorkflowInitiator, I.WorkflowID, I.Stat…

Open PDF Documents in New Window in SharePoint

By default, PDF documents are opened in the same browser window in SharePoint. Here is the trick to open PDF files in new window: Option 1: Open PDF in new window with jQuery Use this jQuery to script to open SharePoint 2010 PDF documents in a new window: <script src="https://code.jqu…

Download Attachments from SharePoint List Programmatically

This code is a C# version of my earlier post: Download All Attachments from SharePoint List Items using PowerShell Download attachments from SharePoint list using C# Object model: //Variables String SiteURL; String ListName; String downloadLoc…

SharePoint 2010 Search Scope Drop Down Missing?

SharePoint 2010 search drop downs such as "All Sites", "People" missing in site collections? Shows only "Search This site..." in search box? Well, That's the default setup in SharePoint 2010. Enable SharePoint 2010 add search scope drop down : How to enable se…

Export SharePoint List Items to XML using PowerShell

Sometime back, I wrote a PowerShell script to import from a XML file to SharePoint list, Import XML File Data into SharePoint List using PowerShell . Now the requirement is in reverse: Export SharePoint List data to XML file! PowerShell script to Export SharePoint List Items to XML: How to exp…

Change Master Page in SharePoint using PowerShell

Requirement: Change Master page for SharePoint Site collections. After a branding redesign project, Got a requirement to change master pages on existing sites. branding on new sites going to be created. But for existing sites, We got to change master pages manually. SharePoint 2013 set mas…

Activate-Deactivate Feature on All Sites, Site Collections in SharePoint using PowerShell

We use " Enable-SPFeature " and " Disable-SPFeature " PowerShell cmdlets in SharePoint 2013 / SharePoint 2016 sites to activate or deactivate features as in my another article: How to Activate-Deactivate Features in SharePoint . At times, we may have to activate feature for al…

Add-Remove Content Types to SharePoint List or Library using PowerShell

SharePoint content types enables user to organize related data together. Everything is built around the content types in SharePoint to provide consistency and re-usability. Say for instance, All list templates such as Announcements, Tasks are built with content types "Announcement" and …

SharePoint Web Part Usage Report - Find All Locations where a Particular web part is being Used

During Migration, I had to get the URLs where a particular web part is being used. So, Used this PowerShell script to generate the SharePoint web part usage report. This script made compatible with SharePoint 2007, So it can be used in SharePoint 2010 and in SharePoint 2013 as well. Don't f…

Create a SharePoint Subsite from Custom Site Template using PowerShell

Requirement: We've a PMO site template created for managing projects in SharePoint. Had a new requirement to create some 20+ new PMO subsites based on the custom site template. To create a site based on site template, you can pick the custom tab and then select appropriate site template fro…

Download All Attachments from SharePoint List Items using PowerShell

Requirement: Download all attachments from a SharePoint list to local folder. Lets use PowerShell to download attachments from all SharePoint list items. PowerShell to Download Attachments from SharePoint List: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoin…

Find All Users Who Accessed SharePoint Sites in the Past One Year

Requirement: Get the E-mail ids of all users who accessed SharePoint sites during the past one year! Solution: Lets use Log Parser and PowerShell to fulfill this requirement. Here is how: Locate your SharePoint web application's log folders from all web front servers (usually: C:\WINDOWS…

SharePoint 2013 deployment - Project Plan Template with Milestones

Assuming Hardware, Public IP, SSL Certificates, Domain Names are ready - Here is my SharePoint 2013 deployment project plan template with milestones outlined: Deployment Tasks 0. Project Kick-off, Team-setup, Identifying key stake-holders and Responsibilities 1.Pre-De…

SharePoint Products Configuration Wizard Failed to Connect to the Database Server.

Problem: SharePoint sites crashed suddenly! Found event id 5586 "The target principal name is incorrect. Cannot generate SSPI context." logged in SharePoint servers. Tried running SharePoint 2013 Products configuration wizard. Received error message: "Failed to connect to the d…

Enable Item-Level Permissions on Document Library in SharePoint using PowerShell

SharePoint Lists provide item level security options such as "Read items that were created by the user" or "Create items and edit items that were created by the user" under "Advanced Settings" page in SharePoint list settings. But you don't get these options to…

Fix for Powershell Script cannot be loaded because running scripts is disabled on this system error

Problem: On trying to run a PowerShell script from PowerShell console, received this error message: "File C:\temp\GenerateRpt.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at http://go.microsoft.com/fwlink/?LinkI…

Update "Created By", "Last Modified" Metadata Fields of a List Item using PowerShell

Ever wanted to update SharePoint list or library item's metadata fields such as: "Created By" "Modified By" "Created" "Last Modified"? These column values must be updated while copying items from one list to another, programmatically. Today, Had an an…

Add New Field to Customized List Forms in SharePoint 2013

Requirement: You have customized a SharePoint list form heavily. Now you got a new requirement to add a new field to the List, of course on List form as well. Unfortunately, when you add a new column to SharePoint list, custom forms have no effect - meaning new column will not appear on custom f…