Sharepoint

Create mysite using Powershell

2015-10-14T14:10:00.000+02:00

Function Create-MySite
{
[CmdletBinding()]
Param
(
[Parameter(Mandatory = $True,Position=2,valueFromPipeline=$true)][String]$Username,
     [Parameter(Mandatory = $True,Position=1)][String]$MySiteRootURL
)
[void][reflection.assembly]::Loadwithpartialname("Microsoft.Office.Server");
$site=new-object Microsoft.SharePoint.SPSite($MySiteRootURL);
try
{
$serviceContext = Get-SPServiceContext $site;
$upm = new-object Microsoft.Office.Server.UserProfiles.UserProfileManager($serviceContext);
if($upm.UserExists($Username) -eq $false)
{
   Write-Host "User $Username was not found in the profile store." -f yellow;
   return;
}
$userProfile = $upm.GetUserProfile($Username);
if($userProfile.PersonalSite -eq $Null)
{
   Write-Host "Creating MySite for user $Username" -f darkyellow;
   $userProfile.CreatePersonalSite();
   Write-host "Successfully created MySite for user $Username" -f green;
}
else
{
   Write-Host "User $Username already has a MySite." -f darkgreen;
}
}
catch
{
Write-Host "Encountered an error creating a MySite for user $Username. Error:"$_.Exception -f Red;
}
finally
{
$site.Dispose();
}
}
Create-MySite -MySiteRootURL "http://url" -Username "domain\user"

Powershell script remove contenttypes from list

2015-10-09T10:52:00.002+02:00

#Get site object and specify name of the library to look for in each site
$site = Get-SPSite http://URL
$lookForList = "ListName"
$ContentType = "CTName"
#Walk through each site and change content types on the list specified
$site | Get-SPWeb -Limit all | ForEach-Object {

write-host "Checking site:"$_.Title

#Check list exists
$docLibrary = $_.Lists[$lookForList]

#Remove unwanted content types from the list
if($docLibrary -ne $null)
{
$ctToRemove = $docLibrary.ContentTypes[$ContentType]
write-host "Removing content type" $ctToRemove.Name "from list" $docLibrary.Title
$docLibrary.ContentTypes.Delete($ctToRemove.Id)
$docLibrary.Update()
}
else
{
write-host "The list" $lookForList "does not exist in site" $_.Title
}
}
#Dispose of the site object
$site.Dispose()

Export managed metadata

2015-06-11T16:34:00.001+02:00

Get-SpServiceApplication | select DisplayName, ID
Get-SPServiceApplicationProxy | select DisplayName, ID
$mmsAppId = "GUID"
$mmsproxy = Get-SPServiceApplicationProxy -Identity GUID
Export-SPMetadataWebServicePartitionData -Identity $mmsAppId -ServiceProxy $mmsproxy -Path \\server\path\filename.bak

Migrate SharePoint social tag comments

2015-06-11T16:29:00.001+02:00

Add-PSSnapin microsoft.sharepoint.powershell

$upaProxy = Get-SPServiceApplicationProxy GUID

$site = get-spsite #URL

$listName = #LISTNAME

foreach($web in $site.AllWebs){

$oldurl = ""

$newurl = ""

if($web.ParentWeb.Url -eq $site.url){

$list = $web.Lists[$listName]

$items = $list.items

foreach($item in $items)

{

if($item.xml -Like "*#RELPATH/PAGE.aspx, PAGETYPE*"){

$newurl = $web.url + "/" + $item.url

[System.uri]$newurl = $newurl

$newurl.AbsoluteUri

$oldurl = $newurl.AbsoluteUri

$oldurl = $oldurl -replace "SITE1", "SITE2"

$oldurl

Move-SPSocialComments -ProfileServiceApplicationProxy $upaProxy -OldUrl $oldurl -NewUrl $newurl.AbsoluteUri

}

}

}

}

Security Token Service is down or showing errors?

2014-07-07T11:44:00.003+02:00

Some examples of errors that may show up in your ULS log.

An exception occurred when trying to issue security token: The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error (OR)
Request for security token failed with exception: System.ServiceModel.ServiceActivationException: The requested service,'http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc/actas' could not be activated (OR)
An exception occurred when trying to issue security token: The requested service,'http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc/actas' could not be activated

Run the following commands, it will do a new provisioning of the Security Token Service.

$h = Get-SPServiceHostconfig
$h.Provision()
$services = Get-SPServiceApplication
foreach ($service in $services) { $service.provision();
write-host $service.name}

Perform an IIS Reset and try to browse the STS, http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc

Set user default regional settings from website default

2014-06-05T15:36:00.002+02:00

$spweb = Get-SPWeb http://yourURL.com
$user = get-spuser -Web $spweb -Identity "DOMAIN\USER"
$reg = $user.RegionalSettings
$newReg = new-object Microsoft.SharePoint.SPRegionalSettings($spweb);
$user.RegionalSettings = $newReg;
$user.Update();

Powershell script activate developer dashboard on demand in your Sharepoint 2013 environment

2014-06-04T11:17:00.000+02:00

$svc = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$dds = $svc.DeveloperDashboardSettings
$dds.DisplayLevel = "OnDemand"
$dds.TraceEnabled = $true;
$dds.Update()

Add list column to list contenttype

2014-04-07T11:29:00.001+02:00

$web = Get-SPWeb -Identity "URL to your site"
$list = $web.Lists["List name"]
$ct = $list.ContentTypes["Contenttype Name"]
$field = $list.Fields["Field Name"]
#$field = $list.Fields[{GUID}]
$fieldLink=New-Object Microsoft.SharePoint.SPFieldLink($field)
$ct.FieldLinks.Add($fieldLink);
$ct.Update()
$web.Dispose()

Count of all Documents in SharePoint 2010 Farm with Powershell

2013-08-28T15:29:00.001+02:00

Get-SPSite -Limit All | Get-SPWeb -Limit All | % { $_.Lists} | ? { $_ -is [Microsoft.SharePoint.SPDocumentLibrary] } | % { $total+= $_.ItemCount} ; $total

Open PDF

2013-05-02T12:53:00.000+02:00

$webApp = Get-SPWebApplication http://url
If ($webApp.AllowedInlineDownloadedMimeTypes -notcontains "application/pdf")
{
Write-Host "Adding PDF MIME Type..."
$webApp.AllowedInlineDownloadedMimeTypes.Add("application/pdf")
$webApp.Update()
Write-Host "MIME Type saved."
} Else {
Write-Host -ForegroundColor red "PDF MIME type is already added."
}

Fucked up timer job?

2013-04-18T10:30:00.000+02:00

Update userinfo from Active Directory to Site Collection, if timer job is fucked up.

get-spuser -Web http://url -Identity domain\user
set-spuser -Web http://url -Identity domain\user -SyncFromAD

Import photos from AD to SharePoint 2010

2013-03-20T06:55:00.002+01:00

This is a time comsuming feature, here's the step for doing it right and saving time and insanity... :)

PreReq
User Profile Service application
MySite
Walkthrough
At present there is no picture associated to this user inside Active Directory.

Note- You will not see all the user attributes if you have not turned on the “Advanced Features”. You can also view the same information from ADSI.

How to import Pictures
Now our Goal is to import the user profile along with his picture, we will also upload his picture in AD.
1) First we need to make sure we are able to import users. So I will create connection to OU – PictureOU and import users

Note- I am only importing users from OU PictureOU
2) Let’s check user’s profile in SharePoint and make sure there is no picture associated to it.

Picture for this user is set to be blank
3) Upload Pictures to Active Directory.
Lots of people also have trouble in finding out ways to upload pictures in Active Directory. Following are the two best methods that I am aware off

A. Run these commands in Windows Powershell. We need to have Windows Administrative tools loaded for this to work
Import-Module ActiveDirectory
$photo=[byte[]](Get-Content C:\photo.jpg -Encoding byte)
Set-ADUser "username" -Replace @{thumbnailPhoto=$photo}

4) Let’s check User properties in Active Directory and make sure if has Picture value set

5) Map the Picture property to Thumnail Photo

A) Browse to User Profile Service Application from Central Administration and then click on Manage User Properties
Central Administration > UPA > Manage User Properties
B) Click on Picture and then Edit

C) We need to Map this to Attribute “thumnailPhoto” and Select Import from the Direction. Make sure you click on on Add

D) After clicking on Add make sure it shows up under the “Property Mapping for Synchronization”section

E) Click on OK

6) Start incremental Import
7) Let’s check the User properties and see if the image has been populated

So Picture still showing blank
8) Let’s check MIIS client and see if it made an attempt to import the picture. For this we will need to DS_DELTASYNC

So it does appear that FIM picked up the image successfully from Active Directory
9) Let’s check the Sync DB by running the following query
Select sAMAccountName,SPS_MV_OctetString_PictureURL from MMS_Metaverse with(nolock) Where SAMAccountName like '%UserName%'

So it appears Sync DB has successfully got updated with the Image.

10) Now let’s check the Profile DB by running the following query
Select NTname,PictureURL from UserProfile_full with(nolock) where NTName like ‘%harmeet%’

So it appears that Picture has not made it to the Profile DB
11) Run the following in SharePoint Management Shell
Update-SPProfilePhotoStore -CreateThumbnailsForImportedPhotos 1 -MySiteHostLocation http://mysite

http://support.microsoft.com/kb/2394320
12) Now if you go back to the user profile you will see that the image has been updated

Insert photo to Active Directory

2013-03-20T06:49:00.004+01:00

Import-Module ActiveDirectory
$photo=[byte[]](Get-Content C:\photo.jpg -Encoding byte)
Set-ADUser "username" -Replace @{thumbnailPhoto=$photo}

Pre-create my site

2013-03-20T06:47:00.002+01:00

How to create my site in SharePoint 2010 by powershell or STSADM?

Use the following deprecated STSADM command:
STSADM -o createsite see also http://technet.microsoft.com/en-us/library/cc262594(office.12).aspx
(for MySite use SPSPERS#0 for the site template)
Or Use the following Powershell script:
Get-SPWebTemplate
$template = Get-SPWebTemplate "SPSPERS#0"
New-SPSite -Url "<URL for the new site collection>" -OwnerAlias "<domain\user>" -Template $templatesee also http://technet.microsoft.com/en-us/library/cc263094.aspx

How to find Apppools username AND password?

2013-01-22T15:36:00.003+01:00

At your WFE, C:\Windows\System32\inetsrv>
type appcmd list apppool /text:*

This will bring up a list of every applicationpools at your WFE, showing both Username and Password! Helpful if you have lost any password, but also a possible security issue, everyone having access to your WFE and have administration rights can also gain access to your accounts and password. What about you have accounts with Active Directory permissions?

Powershell script sync Sharepoint user from AD

2012-10-10T14:58:00.000+02:00

Powershell script sync Sharepoint user from AD

get-spuser -identity domain\user -web url
set-spuser -identity domain\user -SyncFromAD -web url

Powershell Bulk upload by putting the keywords in text or csv file

2012-09-10T15:47:00.002+02:00

get-content "C:\path\NameOfFile.csv" | foreach-object { New-SPEnterpriseSearchLanguageResourcePhrase -SearchApplication "Fast Query" -Language en-US -Type QuerySuggestionAlwaysSuggest -Name $_ }

Powershell script update draft version Sharepoint 2010

2012-01-16T10:43:00.000+01:00

#Get site object and specify name of the library to look for in each site
$site = Get-SPSite http://yoursite.com/
$lookForList = "Shared documents"
#Walk through each site and change draft settings on the list specified
$site | Get-SPWeb -Limit all | ForEach-Object {

    write-host "Checking site:"$_.Title

    #Make sure the library exists
    $docLibrary = $_.Lists[$lookForList]

    if ($docLibrary -ne $null)
    {
        $docLibrary.DraftVersionVisibility = 1
        $docLibrary.Update()
write-host $docLibrary.Title "on site" $_.Title "is updated"
    }
    else
    {
        write-host "The list" $lookForList "does not exist in site" $_.Title
    }
}
#Dispose of the site object
$site.Dispose()

Powershell script modify webpart on page Sharepoint 2010

2012-01-16T10:41:00.000+01:00

$site = new-object Microsoft.SharePoint.SPSite("http://yoursite.com")
$web = $site.OpenWeb("RandomSite/AnotherSite/")
$page = $web.GetFile("Pages/default.aspx")
$page.CheckOut()
$wpm = $web.GetLimitedWebPartManager("Pages/default.aspx", [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
$wpm.WebParts | ft

$wp = $wpm.WebParts[1]
$wp.EnableRedirect = $false
$wp.Url = "http://www.google.com/"
$wpm.SaveChanges($wp)
$page.CheckIn("Test")
$page.Publish("Test")
$web.Close()
$site.Close()

Powershell script list all powershell commands in a text file

2012-01-16T10:40:00.001+01:00

Get-Command –PSSnapin “Get-Command –PSSnapin “Microsoft.SharePoint.PowerShell” format-table name > C:\SP2010_PowerShell_Commands.txt

Powershell script install feature Sharepoint 2010

2012-01-16T10:39:00.003+01:00

$MyFeatureId = $(Get -SPFeature -limit all where {$_.displayname -eq "myfeatureName"}).Id
Install -SPFeature $MyFeatureId

Powershell script activate developer dashboard on demand in your Sharepoint 2010 environment

2012-01-16T10:39:00.000+01:00

$dd = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings;
$dd.DisplayLevel = ‘On Demand’;
$dd.TraceEnabled = $true;
$dd.Update ();

Powershell script disable feature Sharepoint 2010 site collection

2012-01-16T10:37:00.003+01:00

$singleSiteCollection = Get-SPSite -Identity http://yoursite.com/
Disable -SPFeature $MyFeatureId -Url $singleSiteCollection.URL

Powershell script change title of a document library in your Sharepoint 2010 site collection

2012-01-16T10:36:00.004+01:00

#Change these variables to your site URL and list name
$site = Get-SPSite http://yoursite.com/
$listName = "Shared Documents"
#Walk through each site in the site collection
$site | Get-SPWeb | ForEach-Object {
#Get the list in this site
$list = $_.Lists[$listName]
#Make the list changes
$list.Title = "Documents"
$list.Description = "Use the Documents library to store shared files"
#Update the list
$list.Update()
}
#Dispose of the site object
$site.Dispose()

Powershell script add webpart to your Sharepoint 2010 sites in your site collection

2012-01-16T10:35:00.000+01:00

$site = new-object Microsoft.sharePoint.SPSite("http://yoursite.com/")
$web=$site.OpenWeb()$pubweb = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($web)$defaultpage=$pubweb.GetPublishingPages()[$pubweb.DefaultPage]$defaultpage.CheckOut()$webpartmanager=$web.GetLimitedWebPartManager($defaultpage.Url,
[System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)$webpart=new-object Microsoft.SharePoint.WebPartPages.ContentEditorWebPart
$webpart.ChromeType=[System.Web.UI.WebControls.WebParts.PartChromeType]::TitleOnly;
$webpart.Title="Name of your Webpart"
$webpartmanager.AddWebPart($webpart, "Left", 0);$defaultpage.CheckIn("Checked in Webpart")
$defaultpage.listItem.File.Publish("Published Webpart")
if ($defaultpage.listItem.ParentList.EnableModeration)
{
   $modInformation = $defaultpage.listItem.ModerationInformation   if($modInformation.Status -ne [Microsoft.SharePoint.SPModerationStatusType]::Approved)
   {
      $defaultpage.ListItem.File.Approve("Approved Page")
   }
}