Building Branding Solution with Feature Stapler for SharePoint 2007

Feature Staplers are the best way to build branding solutions in SharePoint. Once deployed branding will be automatically applied based on Site definition. Overall Steps: Create a WSP Project and add 2 features in it. One for actual Branding with Feature handler code – Applies Branding on activated and another one for…

Read more

Workflows Inventory Report for SharePoint

Requirement: Get me a SharePoint Workflows Report with the Total No. of workflows wherever it’s running, for our intranet SharePoint site with Site Name, List Name, Workflow Name, and No. of Instances, etc. Solution: As usual, dive into the object model code (This can be achieved with PowerShell as well). Here it…

Read more

What is my SQL Server Version, Service Pack, Edition

Requirement: Wanted to check the installed SQL Server version service pack level. SELECT @@version ? It didn’t give me the Service pack information. Query to Check SQL Server version, Service pack and Edition: KB Article: https://support.microsoft.com/kb/321185

Read more

How to Install PowerShell in Windows Server 2003?

Need PowerShell in Windows 2003?  Install “Windows Management Framework core” which includes Windows PowerShell 2.0. You need to have SP2 or later in Windows 2003. Go the KB: https://docs.microsoft.com/en-us/powershell/scripting/windows-powershell/install/installing-the-windows-powershell-2.0-engine?view=powershell-7.1, download and install the appropriate KB for your environment (such as x64, x86) Once installed, you can access PowerShell  from Start > All…

Read more

Version History Size Report for Entire SharePoint Web Application

Ever wanted to get a report on versioning sizes on SharePoint? Unlimited No. of versions enabled in various document library across web application. As part of regular auditing, wanted to generate report for the entire web application ,with Number of versions, Amount of storage consumed by versions. Of course there are some…

Read more

Using owssvr.dll to retrieve List data in XML format

Owssvr.dll is a traditional Remote Procedure Call method to remotely invoke functions in SharePoint. It can be used to retrieve data from SharePoint list as well. syntax: https://sharepoint.com/_vti_bin/owssvr.dll?Cmd=Display&List=<<LIST-GUID>>&XMLDATA=TRUE E.g. https://intranet.sharepoint.com/_vti_bin/owssvr.dll?Cmd=Display&List={6685db48-013f-4934-8147-b7a6014eccc9}&XMLDATA=TRUE Other options: Filter &  View Append –  FilterField1=<<Field-Internal-Name>>&FilterValue1=<<Value-of-the-field>> e.g: FilterField1=Domain&FilterValue1=Sales View={ViewGuid} How to get the List GUID? Go to List settings >>…

Read more

How to Deploy and Activate Sandboxed Solutions in SharePoint?

Sandboxed solutions bring the benefit of deploying solutions to the SharePoint Server without affecting any other process outside the sandbox. SharePoint 2010 Sandboxed solution can be deployed by Site collection administrators. Here is the guide on How to Deploy and activate sandboxed solution in SharePoint 2010. Go to Site Actions >> Site…

Read more

Fix “The site collection containing this sandboxed solution has exceeded its daily resource usage quota.”

When trying to activate a sandboxed solution, Got below error message: “The site collection containing this sandboxed solution has exceeded its daily resource usage quota.” Solution: This is because of the Sandbox solution resource limit. To fix this issue, just increase the site collection Sandbox solution resource quota in site collection quotas…

Read more

Create List Instance Feature for SharePoint 2010 in Visual Studio

Requirement:  Create a new Link list with pre-populated list items as a feature-based solution. Steps: 1. Lets create a SharePoint 2010 list instance feature with Visual Studio. Create a New Empty SharePoint Project, Give it a name, I’ve named it as Crescent.Portal.DashboardLinks 2. In the next dialog box, Select either Farm solution…

Read more