SharePoint Diary

Check if Service Application is Running in SharePoint using PowerShell

June 27, 2015 Monitoring, PowerShell, Service Application, SharePoint

Couple of times, I had to get the service application's status prior performing activities such as: Stop and Start the service, Monitoring service application's availability, etc. Here is how we can check if the service application is running / created using PowerShell. PowerShell scrip…

Create a Task in SharePoint Task List using Powershell

June 18, 2015 PowerShell, SharePoint

PowerShell Script to Create a New Task in SharePoint Task List: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Parameters $WebURL="http://intranet.crescent.com" $TaskListName="Tasks" #Get web and List objects $Web = Get-SPWeb $WebU…

Configuring Audit Logs Feature in SharePoint 2013

June 15, 2015 Audit, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Audit log reports in SharePoint used to track how your SharePoint site contents are being used or to meet any legal compliance requirements. Let's see how to enable auditing feature in SharePoint 2013. Enable Audit Log Feature in Central Administration: SharePoint 2013 audit settings needs…

Move SharePoint Web Application's IIS Physical Path to a New Location

June 15, 2015 IIS, SharePoint

Requirement: Move SharePoint web application's IIS physical location from system drive (c:\) to application drive (d:\) due to new server support policies! Solution: SharePoint web applications, by default placed under: "C:\inetpub\wwwroot\wss\VirtualDirectories" when we create t…

Content Approval: Approve All List Items in Bulk using PowerShell

June 13, 2015 SharePoint

When content approval is turned-ON, approving items one by one could be hectic. To bulk approve items, We can utilize PowerShell. Here is my PowerShell script to bulk approve items pending for content approval. This was a huge time savor for me during a migration project. PowerShell script to…

How to Add Date Time Field to SharePoint List using PowerShell?

June 10, 2015 Column, List, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: Add Date and Time Column to SharePoint list using PowerShell. PowerShell Script to add Date time Column to SharePoint list: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Processing Variables $WebURL="http://portal.crescent.com/sites/Sales"…

Send HTML Format E-Mails with Send-MailMessage in PowerShell

June 10, 2015 Attachment, PowerShell, SharePoint

Requirement: Send E-mail from PowerShell script with HTML formatted body. Solution: Here is an example for sending E-mail as HTML from PowerShell script with Send-MailMessge cmdlet: #Get Date $ReportDate = Get-Date -format "MM-dd-yyyy" #Configuration Variables for E-mail $SmtpServ…

Fix "The form cannot be rendered. This may be due to a Misconfiguration of the Microsoft SharePoint Server state service" Error in SharePoint 2013

June 08, 2015 InfoPath, Known Issues, SharePoint, SharePoint 2013, SharePoint 2016

Problem: InfoPath form based list form in a migrated SharePoint 2013 environment from SharePoint 2010 gave this error message: "The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server state service" Solution: Create a State Service Appl…

Set Default Value for Hyperlink or Picture Column in SharePoint

June 07, 2015 PowerShell, SharePoint, Tips and Tricks

Problem: There is no provision for specifying default value in Hyperlink or Picture type columns in SharePoint! In some scenarios, we may want to specify SharePoint 2010/2013 hyperlink column default value. But there is no option in SharePoint web UI to enter hyperlink field default value! …

Remove Hyperlink from Lookup Columns in SharePoint

June 06, 2015 jQuery, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Problem: When we add lookup column to any SharePoint list, it appears with the link to parent item in SharePoint list views. Quite often, end-user clicks on the lookup link and edits parent lookup item by mistake - People get confused which link to click. So we wanted to remove hyperlink from l…

How to Delete Site Collection using PowerShell in SharePoint?

June 05, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Site Collection

When you delete a site collection in SharePoint, all sites including the top-level site and subsite underneath, and all data present in the site collection, all user information in the site collection gets deleted. To delete any SharePoint site collection, You can use either SharePoint Central Ad…

Exclude SharePoint Site or List from Search Results

June 02, 2015 Search, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

SharePoint search results are already security trimmed. Meaning, If a user doesn't has access to a SharePoint site, He/She doesn't see any search results from the particular site collection. Same applies to SharePoint lists even. But in some cases, you may want to prevent certain artifact…

"Connect to Outlook" in SharePoint 2013 Greyed out?

June 01, 2015 Known Issues, SharePoint, SharePoint 2013, SharePoint 2016

Problem: SharePoint users unable to connect to any SharePoint 2013 list or calendar to Outlook 2013. The "Connect to Outlook" Ribbon button is always greyed out! Troubleshooting Checklist: Connect to outlook feature is available only to these type of lists: Calendar, Tasks, Pro…

Restrict Office Web Apps Edit License within a AD Group

June 01, 2015 Active Directory, Office Web Apps, SharePoint

Requirement: SharePoint 2013 Office Web Apps "Edit in Browser" feature needs to be limited to users who has Microsoft Office Volume license. Solution: License Enforcement in Office Web Apps 2013 The overall idea for the solution is: Create a new security group in AD, Add users to i…

Disclaimer