Check if Service Application is Running in SharePoint using PowerShell

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

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

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

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

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?

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

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

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

Requirement: Set Default value for Hyperlink or Picture Column in SharePoint List 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 n…

Remove Hyperlink from Lookup Columns in SharePoint

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?

Requirement: Delete a SharePoint Site. How to delete site collection in SharePoint? When you delete a site collection in SharePoint, all sites including the the top-level site and subsite underneath, and all data present in the site collection, all user information in the site collection ge…

Exclude SharePoint Site or List from Search Results

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?

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

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…