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 »

Add users to SharePoint using PowerShell

Add-PSSnapin “Microsoft.Sharepoint.PowerShell” $web = Get-SPWeb “https://Marketing” $userObject = $web.EnsureUser(“ABC\a.b”) $group = $web.SiteGroups[“Site Members”] $group.AddUser($userObject)

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 »

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 »

PowerShell Script to Copy/Replace items from one list to another list

Ok guys, I did work on this script for couple of hours and came up with working solution, basically this script will copy/replace items from one SharePoint List to another SharePoint List. Tip: Save the Source list as templace without Content and create desination list with source template and disable any workflows that are associated… Read More »

PowerShell – Update HREF – Rich Text Field

I do have a very strange requirement that i need to change the hyperlink of a item in list (like upload documents link to another library) but unfortunately I cannot edit the item as the link if formed dynamically in workflow, so to update the link I need to use PowerShell. And below is the… 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 »