PowerShell, Programming, Security, SharePoint, Troubleshooting, Windows

SharePoint/PowerShell – Get the AD groups associated with a site collection and output to CSV file

iamjaredmeredith

Need to deliver or better understand the AD groups associated with your SharePoint site collection? Try this:

$SPWebApp = Get-SPWebApplication http://sitecollectionURLhere/

foreach ($SPSite in $SPWebApp.Sites)
{
    write-host -foregroundcolor green "Working on Site Collection: " + $SPsite.RootWeb.Title 
    $SiteURL = $SPsite.RootWeb.URL
    $ADgroup=Get-SPUser -Web $SiteURL -Limit ALL | Where { $_.IsDomainGroup }
}
echo $ADgroup | Export-Csv "C:\Temp\FileNameGoesHere.csv"

PS1 download is here: https://1drv.ms/u/s!Ag4C3w6EUQIggowvfXrE0Z3tfWKJeA

Published by iamjaredmeredith

Director. Architect. Engineer. Trusted Partner in Solution Delivery. Got CS Degree @ ETSU, Worked as Programmer Analyst for 3 years @ Lincoln Memorial University, .Net Mobile Apps Developer for 1 year @ ORAU, .Net Developer for 1 year @ Oak Ridge National Laboratory, Currently Director of Solutions Architecture @ TEAMHealth.