SharePoint Diary

"Metadata Navigation Settings" Link Missing in SharePoint 2013 Document Library?

February 28, 2014 Document Library, Known Issues, Navigation, SharePoint 2013, SharePoint 2016

Problem: Metadata navigation settings in SharePoint document library is missing! Metadata navigation makes it easier to find and dynamically filter content in large lists and libraries. Once enabled, it uses a navigation tree in the quick launch. Solution: You must activate "Metad…

Add Custom Scope to SharePoint Search Dropdown using PowerShell

February 25, 2014 PowerShell, Search, SharePoint, SharePoint 2010

Requirement: We've created a custom search scope "Search All Documents" in SharePoint Central Admin and would like to include it in search scope drop downs of few site collections. SharePoint 2010 add search scope to drop down: Well, its a few-clicks job to include custom search…

Find All Inactive Features in SharePoint with PowerShell

February 24, 2014 Admin Reports, Features, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is inactive Feature in SharePoint? Well, Features which are installed but not activated anywhere! Here is the PowerShell script to find inactive features for SharePoint: Add-PSSnapin "Microsoft.SharePoint.Powershell" -ErrorAction SilentlyContinue $InactiveFeatures = @() #Get A…

SharePoint Features Usage Report using PowerShell

February 24, 2014 Admin Reports, CSV, Features, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

Task: Generate a report for All Installed/Activated Features for the entire SharePoint Environment. Here are some nifty PowerShell scripts to find features installed on the farm as well as specific features activated on a particular scope. Get-SPFeature cmdlet: Get-SPFeature cmdlet retrieves …

Import XML File Data into SharePoint List using PowerShell

February 23, 2014 List, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, XML

Requirement: PowerShell to Import XML to SharePoint List We've an utility from third-party system that generates project data in XML format. We had to import those data to a list in the PMO site. In other words: We've to import from XML file to SharePoint list. Here is a sample XML f…

How to Add New List Item in SharePoint using PowerShell?

February 22, 2014 SharePoint, SharePoint 2010, SharePoint 2013

My PowerShell scripts to add list item in SharePoint: Add SharePoint list items using PowerShell The syntax to add new list item in SharePoint using PowerShell, goes like this #Get Web and List Objects $Web = Get-SPWeb "http://sharepointsite.com" $List = $Web.Lists["ListName&qu…

Exclude a Column from SharePoint Search Crawl

February 20, 2014 PowerShell, Search, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Columns

Requirement: By default, SharePoint search engine craws and indexes all documents and its associated metadata properties from lists and libraries. In our case, We keep few fields for configuration in a custom SharePoint application and don't want those fields to appear in SharePoint Search …

Copy Files to SharePoint Servers Remotely using PowerShell

February 20, 2014 PowerShell, SharePoint

Requirement: During a branding project, We had to deploy a logo file every time to all SharePoint servers by individually logging in to them and copy pasting given file to all SharePoint 2013 server's 15 hive. Wanted to do a bit automation with PowerShell here. Let the PowerShell do Copy-Pas…

Find Who has Created / Modified a SharePoint View

February 20, 2014 List View, PowerShell, SharePoint

Ever wondered how to find the user who has created or modified a particular SharePoint view? and when it was created/modified? Well, There is no SharePoint UI to get these information! But using SharePoint object model, we can retrieve these data programmatically from SPFile object's propert…

Get All SharePoint Site Collection Owners (Primary/Secondary Site Collection Administrators)

February 18, 2014 Admin Reports, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, Site Collection Administrator

Requirement is to find out owners of each SharePoint site collection in the environment.We needed this data to get approvals on critical changes and to inform site owners prior to maintenance windows. Simple! Use STSADM command: On SharePoint 2007 and above, STSADM command can be used to get p…

SharePoint Number Column without Commas

February 17, 2014 Calculated Column, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, Tips and Tricks

Problem: SharePoint Number columns shows , (comma) in View/Display Forms. There are specific numeric columns, User wanted to display without commas. There is no direct way to remove comma/avoid thousand separator in SharePoint Number fields, But the below tricks help to get SharePoint 2007/201…

Add-Remove-Get Event Receivers in SharePoint with PowerShell

February 12, 2014 Event Receivers, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

We usually use C# console application or feature activation code to register event receivers with the target list or library in SharePoint. At times, we may have to handle event receiver associations explicitly. Of course, there are some great tools in codeplex (E.g. http://speventreceiverman.cod…

Enable NetBIOS Name for User Profile Service Application in SharePoint

February 07, 2014 Service Application, SharePoint

We must enable NetBIOS for User Profile Service Application in SharePoint when Fully Qualified Domain Name is different than NetBIOS name. Ok. How to find NetBIOS name of your domain? Login to your Domain controller >> Open : Active Directory Users and Computers" (Shortcut: dsa.msc)…

SharePoint 2013 "Get Started with your site" Web Part - FAQs

February 03, 2014 SharePoint, SharePoint 2013

"Getting Started" tiles are new addition to SharePoint 2013 team sites. These tiles intend to provide shortcuts to common actions, such as sharing your site, applying a theme. In SharePoint 2013, They replaces the “Getting Started” links from its previous version: SharePoint 2010. Di…

Upload File to SharePoint using Web Services and PowerShell

February 03, 2014 PowerShell, SharePoint, Web Services

Requirement: For a file upload issue troubleshooting, had to call SharePoint web services to Upload a file into SharePoint document library. Upload File to SharePoint Library using Web Services - PowerShell Here is my PowerShell script to upload file to SharePoint document library using web …

Upload Files to SharePoint Remotely using Web Client and PowerShell

February 03, 2014 PowerShell, SharePoint

If you want to upload file to SharePoint document library from client side (or remotely), Here is the nifty PowerShell code snippet. Upload File to SharePoint using Web Client PowerShell: #Variable for Source folder in Local machine & Destination in SharePoint $Source ="c:\temp\file.p…

Create Sharepoint Alert for a Group

February 03, 2014 Alerts, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, Users and Groups

SharePoint doesn't provide a direct way to create alerts for groups. Alerts are always targeted to individual user accounts in SharePoint. If you have a requirement to create alerts for a group of people, create a E-mail enabled AD security group and add alert to it from SharePoint. Set a…

Increase Maximum Size of Site Template, List Templates in SharePoint

February 02, 2014 Best Practices, Configuration, List Template, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Template

In SharePoint 2007, You can't save a list or site template (.stp ) file which is bigger than 10MB. MOSS 2007 gives an error message: " The list is too large to save as a template. The size of a template cannot exceed 10485760 bytes. " When you try to save a list or site which by inc…

Delete List Template in SharePoint using PowerShell

February 02, 2014 List Template, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Delete a list template in SharePoint How to delete a list template SharePoint? To remove list template in SharePoint, Login to your SharePoint site collection (List templates are scoped at site collection level) >> Click on Settings >> Site Settings On Site Setting…

Copy Attachment from SharePoint List to Document Library using SharePoint Designer - PowerShell

February 01, 2014 Attachment, Document Library, List, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Copy Attachments from SharePoint List to Document Library Solution: SharePoint keeps attachments under "List >> Attachments >> 'List Item ID'" folder path. So, if you want to copy attachment from list to document library, follow these steps: Open you…

Server Status Remains "Upgrade Available" Even After Installing Latest Patches

February 01, 2014 Migration/Upgrade, Patching, SharePoint, SharePoint 2013

Recently, We patched one of our SharePoint 2013 environment and ran SharePoint products configuration wizard without any issues. However, we noticed that the server status is still in "Upgrade Available" for SharePoint application & Web front end server from Central Administration &…

Create Service Application Proxy Group in SharePoint 2013 using PowerShell

February 01, 2014 Central Administration, PowerShell, Service Application, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

What is Proxy Group in SharePoint? SharePoint 2016 groups service applications together for consumption of the web application through proxy groups. These are simply groupings of service applications that you can deploy to different web applications. In other words, A proxy group is a link betwe…

How to Delete a SharePoint List using PowerShell?

February 01, 2014 List, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Problem: A faulty solution installed on the SharePoint farm created duplicate lists in all sites in a large site collection with 100+ sites in it. We had to remove them all! To delete a list from SharePoint, from the browser, we can go to: View All Site Content >> Click on "Remove&q…