SharePoint Diary

Restart SharePoint Timer Service Remotely using PowerShell

March 31, 2014 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

March 30, 2014 List, PowerShell, SharePoint, SharePoint 2007

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

March 28, 2014 PDF, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013

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

March 27, 2014 Attachment, C#, Object Model, SharePoint

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?

March 25, 2014 Search, SharePoint, SharePoint 2010

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

March 23, 2014 List, PowerShell, SharePoint, XML

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

March 23, 2014 Branding, Master Page, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

March 23, 2014 Features, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

March 21, 2014 Content Type, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

March 12, 2014 Admin Reports, CSV, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, Web Parts

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

March 11, 2014 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Template, Subsite

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

March 07, 2014 Attachment, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

March 05, 2014 Admin Reports, CSV, SharePoint, SharePoint 2007, SharePoint 2013, SharePoint 2016

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

March 04, 2014 Deployment Guides, Migration/Upgrade, SharePoint 2013

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.

March 03, 2014 SharePoint, SharePoint 2013, SharePoint Products Configuration Wizard, SQL Server, Troubleshooting

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

March 02, 2014 List Settings, Permission, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

March 02, 2014 PowerShell, Windows Server

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

March 02, 2014 PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Tips and Tricks

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

March 01, 2014 List Forms, SharePoint, SharePoint Designer 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…

Disclaimer