Category Archives: Powershell

Get all Metadata Columns

Get all Metadata Columns using PowerShell, this will come handy when you need to know the column details. Add-PsSnapin Microsoft.SharePoint.PowerShell function GetMapping($site, $MMSField, $Field, $ContentTypes) { $taxonomySession = Get-SPTaxonomySession -Site $site $termStore = $taxonomySession.TermStores[“Managed Metadata CTH”] $MMSGroup = $termStore.Groups[“Global Taxonomy”] $termset = $MMSGroup.TermSets[$MMSField.TermSetId] Write-Host “Site Column Name : “$Field.Title Write-Host “MMS Column Name : “$MMSField.Title… Read More »

Get All Site Collections with Titles

Simple and easy way to get all site collections with Title.    Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue    function GenerateAllSitecollectionsInWebapplication ($url) {     write-host “Sitecollection List Extraction started….” -foregroundcolor red     try       {          $Site=Get-SPSite $url                   $spWebApp = $Site.WebApplication          foreach($SC in $spWebApp.Sites)          {            write-host $SC.Url  – $SC.RootWeb.Title               }                              }    catch       {           write-host “Unable to Extract Sitecollection List…”… Read More »

Download Attachments using PowerShell – SharePoint 2010/2013

[void][System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) #For MOSS 2007 compatibility Function global:Get-SPWeb($url) { $site= New-Object Microsoft.SharePoint.SPSite($url) if($site -ne $null) { $web=$site.OpenWeb() } return $web } #Site URL and List Name variables $WebURL = “https://SharePoint” $LibraryName = “REPORT” #This can be list or document library, if list has multiple attachements it will download all – Note: This PS will create a… Read More »

Delete users from User Information List

Delete Users from User information List. Get the user details from previous script matching the criteria and use excel to import from text and get the CSV #This script will remove users specified in the CSV. $CSVFile = Import-CSV D:\Indra\Users.CSV # Change the path Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue #Get all site collections $Sites = Get-SPSite… Read More »

Get Users matching a Domain

Get Users matching a Domain in User Information List. # Run with SharePoint 2010 Management Shell $webUrl = “http://SharePoint” $web = Get-SPWeb $webUrl #$list = $web.Lists[“User Information List”] $user = Get-SPUser -web $web -Limit All | Where-Object {$_.UserLogin -Like “*AD\*”} | Format-Table -Autosize | Out-File D:\Indra\Users.txt Write-Host Done. Change the URL and out-put file path… Read More »