SharePoint Diary

Change SharePoint 2010 Authentication from Windows to Forms

June 29, 2012 Configuration, PowerShell, SharePoint, SharePoint 2010

While creating a web application, by mistake selected "Windows" authentication, and felt we need "Forms" authentication (Claims Based Authentication) because of a business requirement. Went to Central Administration >> Application Management >> Manage Web Appl…

Hide Contextual Search Scope from Search Dropdown

June 26, 2012 Search, SharePoint

Requirement: Hide the contextual "This Site: Site Name" search scope from Search drop down. Solution: 1. Copy the folder OSearchEnhancedFeature from "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES\OSearchEnhancedFeature" as &q…

Report for SharePoint Access Request Email Configurations

June 23, 2012 Access Request, Admin Reports, Configuration, CSV, SharePoint, SharePoint 2007

Requirement: People are moving to different roles, Few left the company from time to time. Access requests are sent to those in that kind. Its a problem! We had to monitor the access request configurations to make sure its sent to the relevant person. So, Wrote this PowerShell code to generate …

How to Install PowerShell ISE in Windows Server 2008 R2?

June 22, 2012 PowerShell, SharePoint, Utilities, Windows Server

PowerShell ISE is a wonderful tool for creating, Debugging, and executing PowerShell scripts. But it doesn't get installed automatically. Here is how to install PowerShell ISE in Windows 2008 R2. You don't have to download anything to get PowerShell ISE in Windows 2008 R2, Its a Instinc…

Trim audit log to Improve Performance in SharePoint

June 22, 2012 Administration, Performance Optimization, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

Found SharePoint content databases are growing even when no content was added from the user side. I was analyzing SharePoint Database growth, went ahead and generated disk space report from SQL Server Management Studio (Right-click the database, choose Reports >> Standard Reports >>…

Find in Which Content Database Site Collection Lives

June 20, 2012 Administration, SharePoint, SharePoint 2010, SharePoint Database

Requirement: Get which site collections resides in which content database. Solution: Simplest method is: Navigate to Central Admin >> Application Management >> View All Site Collections . This will display the content database name of a particular site collection. Site collec…

How to Set Welcome Page Programmatically in SharePoint?

June 15, 2012 C#, Object Model, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

By default, SharePoint uses "default.aspx" page as the welcome page (or Home page) in SharePoint 2007 and "SitePages/Home.aspx" in SharePoint 2010. It uses Pages/Home.aspx when publishing feature is enabled under MOSS 2007. If you want to change Home Page: SharePoint provide…

Change All SharePoint Site's Access Request Emails with PowerShell

June 15, 2012 Access Request, Configuration, PowerShell, SharePoint, SharePoint 2007, SharePoint 2013

Some time back, I posted an article on Configuring Access Requests from SharePoint .Now, To take the control, Business decided to give the access control requests to SharePoint help desk, instead of site owners. So, the requirement is: Update All SharePoint Site's Access request Emails to:…

Iterate through All SharePoint Web Applications, Site Collections, Sub-sites, Lists and List Items Programmatically

June 12, 2012 C#, Object Model, SharePoint, SharePoint 2010

Often in development, we may have to iterate through all web applications, Site collections, sites, Lists and List Items to get some job done or generate reports. Here are the code snippets to help. Iterate Through all web applications, Site collections, Sites, Lists and List Items Using C#…

Alert Management Web Part - Released in CodePlex

June 12, 2012 Alerts, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint Development

Received lot of mails from People who read my post Alert Management Web part Mock-up on Alert Management Web Part Solution. So, I created a CodePlex Project to Share! Business Problem: In a Project management site, When new project sites created, Project Manager creates alerts for all team m…

SharePoint Web Services Exposed to Anonymous Access Users

June 11, 2012 Anonymous Access, Security, SharePoint, SharePoint 2007, Web Services, web.config

Accidentally found my SharePoint Test environment's web services URLs are exposed in Google as anonymous access! and I was able to access the web services anonymously! Even though SharePoint web services exposed by anonymous access, SharePoint will not allow anyone to do beyond their …

Programmatically Check whether a Particular List/Library Exists or Not

June 07, 2012 C#, Object Model, SharePoint, SharePoint 2007, SharePoint 2010

How to check if list exists in SharePoint programmatically? SharePoint 2010 offers TryGetList Method to determine the existence of a List programmatically. TryGetList returns null, if the specified list doesn't exist. SharePoint 2010 check if list exists: using (SPSite site = new SPSite(…

Read From Excel & Import to Sharepoint List - Using Web Services

June 04, 2012 C#, SharePoint, SharePoint Development, Web Services

Another code snippet using SharePoint-Web Services. Requirement is: End-User wants to read data from Microsoft Excel (it will be placed at c:\contracts.xls ) and append to SharePoint List (List Name: Contracts) on-demand from his desktop. So the idea is: Lets build a console application, Add a …

Setting up Scopes in SharePoint Search Results

June 02, 2012 Search, SharePoint

Requirement is: When user search from a particular site collection, either the default search result or advanced search result, should get content ONLY from a list of sites. Solution? Search Scopes! Search scopes in SharePoint allows users to narrow down the search results based on conten…

Site Traffic Hits Report on Every Item on a SharePoint Site

June 02, 2012 Admin Reports, C#, CSV, SharePoint, SharePoint 2007, SharePoint 2010

Requirement : Get the site traffic hits count for the past 30 days on each and every File/List/Page/etc stored on a MOSS 2007 site. C# Object Model code to Generate SharePoint hits report: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.S…

Custom 404 Page Not Found Error Page in SharePoint 2010

June 01, 2012 Administration, Best Practices, SharePoint, SharePoint 2010, web.config

Its a best practice to show customized 404 page not found error page for any website when user request for a broken URL or mistyped URLs. SharePoint has no exclusions. By default, SharePoint gives this 404 error screen to the user: So, Its great to have custom 404 Page not found error page …

Disclaimer