Skip to main content


Showing posts from 2014

Copy List Item Programmatically

public void CopyItem(SPListItem srcItem, SPListItem destItem) { foreach (SPField field in srcItem.Fields) { if (!field.ReadOnlyField && field.InternalName != "Attachments") { destItem[field.InternalName] = srcItem[field.InternalName]; } } foreach (string attachmentName in srcItem.Attachments) { SPFile file = srcItem.ParentList.ParentWeb.GetFile(srcItem.Attachments.UrlPrefix + attachmentName); byte[] data = file.OpenBinary(); destItem.Attachments.Add(attachmentName, data); } destItem.Update(); }

Export ContentDataBase Name in csv file

<# Created by: Gaurav Goyal
   Purpose : To Export Content Database Name in csv file.
   Comments: Run With Admin Privileges \ Read operation.

SC $csv "ID,DBName,WebApplicationName,CurrentSiteCount"
write-host "`nGetting WebApplication Names`n";
$WebApps = Get-SPWebApplication 
foreach($WebAppUrl in $WebApps)
write-host "$i) Getting ContentDataBase name of WebApp"$WebAppUrl.Url "`n" ;$i++;
$toCSV=Get-SPContentDatabase -site $WebAppUrl.Url;
AC $csv"$($toCSV.Id),$($toCSV.Name),$($toCSV.WebApplication),$($toCSV.CurrentSiteCount)"
write-host "Exporting List of All DB.....`n"
Get-SPDatabase | epcsv ".\AllDataBaseList.csv"

Configure ADFS, Claim-Based Authentication and IFD for MS CRM 2013

Limitation of Active Directory Federation Services (ADFS)1.ADFS requires default website & default port like port 80 & 443. On the server where you are going to install & configure ADFS, port no 80 & 443 should be available. 2.When Claim is enabled HTTPS must be used both for internal & external.
You need wild card certificate for Claim-Based Authentication & IFD
DNS ConfigurationYou need to create at least 5 host name in DC: Forward Lookup Zone (For DNS Resolution) 1.ADFS 2.0 URL (External Domain : adfs2. : 2.CRM Server IFD URL (CRM IFD Federation endpoint, e.g. 3.CRM Discovery Service endpoint ( 4.CRM Org URL ( 5.Internal URL to access the CRM (CRM Claims Federation endpoint, Install ADFS on CRM server or on a different server1.Go to Server Manager 2.Add Roles & Features 3.Select Insta…

New Site Collection Through PowerShell

#Creates a SPSite in a new content database
Add-PSSnapin Microsoft.SharePoint.Powershell - ErrorAction SilentlyContinue;

$siteName = "IT";
$webAppUrl = "";
$template = "STS#0";

$ownerAlias = "mydomain\ggoyal";
$secondaryOwnerAlias = "mydomain\ggoyal";

$siteUrl = "$webAppUrl/sites/$siteName";
$databaseName = "SharePoint_Intranet_$siteName";
$databaseServer = "Test-Server";

New-SPContentDatabase -Name $databaseName -DatabaseServer $databaseServer -WebApplication $webAppUrl;

New-SPSite -Url $siteUrl -OwnerAlias $ownerAlias -SecondaryOwnerAlias $secondaryOwnerAlias -ContentDatabase $databaseName -Template $template -Name $siteName;

# New SPSite does not create the default groups

$web = Get-SPWeb $siteUrl;
$web.CreateDefaultAssociatedGroups("i:0#.w|$ownerAlias", "i:0#.w|$secondaryOwnerAlias", $siteName);

Find Missing Web Part

Whenever a SharePoint Developer or Administrator opens Central Administration site, they usually see a notification on top of CA site which shows all the warnings & issues with the SharePoint Farm & Servers.

When you hit “View these issues”, You will get list of issues and warnings. In this list you will find a common error “Missing server site dependencies”.