{"id":347,"date":"2013-02-27T07:17:35","date_gmt":"2013-02-27T07:17:35","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=347"},"modified":"2024-04-12T06:28:06","modified_gmt":"2024-04-12T06:28:06","slug":"sharepoint-full-farm-site-collection-admin-report","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/sharepoint-full-farm-site-collection-admin-report\/","title":{"rendered":"SharePoint Full Farm Site Collection Admin report"},"content":{"rendered":"<h4>Reporting on SharePoint Full Farm Site Collection Admins<\/h4>\n<p>Site Collection Administrators retain a great deal of power and capability within a SharePoint Site Collection. Wouldn\u2019t it be nice to know are the Site Collection admins across an entire farm? This script will generate a report that is easily loaded and pivoted in Excel. First, let\u2019s pick a column separator that\u2019s not in use by any of the fields. This is a bit of a challenge, because with Claims based authentication, there\u2019s quite a few characters in use that precludes them being a separator. Here\u2019s the script:<\/p>\n<p>&nbsp;<\/p>\n<pre lang=\"Java\">$Sep=\"~\"\r\n Write-Host \"WebApp$($sep)SiteCollection$($sep)UserName$($sep)UserLogin\"\r\n $spWebApps = get-spwebapplication\r\n  \r\n foreach ($spWebApp in $spWebApps)\r\n {\r\n    foreach($site in $spWebApp.Sites)\r\n    {\r\n        foreach($siteAdmin in $site.RootWeb.SiteAdministrators)\r\n        {\r\n            Write-Host \"$($spWebApp.Name)$($sep)$($siteAdmin.ParentWeb.Url)$($sep)$($siteAdmin.DisplayName)$($sep),$($siteAdmin.UserLogin)\"\r\n        }\r\n        $site.Dispose()\r\n    }\r\n    $spWebApp=$null; #this is not an IDisposable object\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Reporting on SharePoint Full Farm Site Collection Admins Site Collection Administrators retain a great deal of power and capability within a SharePoint Site Collection. Wouldn\u2019t it be nice to know are the Site Collection admins across an entire farm? This script will generate a report that is easily loaded and pivoted in Excel. First, let\u2019s [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":354,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[26],"tags":[],"class_list":["post-347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=347"}],"version-history":[{"count":10,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/347\/revisions"}],"predecessor-version":[{"id":498,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/347\/revisions\/498"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/354"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}