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 »

SharePoint and Information Rights Management (IRM)

I do get lot questions from my SharePoint friends and colleagues regarding IRM’s in SharePoint. The questions are: 1. What is IRM 2. Why do someone need that 3. Where should we apply it. Actually I do not need to answer point 1, as you can Google/Bing it to get the definition but point 2… Read More »

Category: IRM

SharePoint Mobile Application – Thoughts

I ask myself every time I use my mobile (Android or IOS, I know windows phone has this default SharePoint app but not UX friendly) to open SharePoint site and feel why I should have mobile master and device channel settings to have good UX to navigate the site. How an app that just works… 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 »