Category Archives: SharePoint 2013

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 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 »