Public/Get-GroupMemberships.ps1
|
Function Get-GroupMemberships { <# .DESCRIPTION Get a list of Active Directory User Accounts and the groups they are a member of .PARAMETER Path Specifies the export directory and filename for the report .NOTES Requires Active Directory and ImportExcel Modules .Example Get-GroupMemberships -Path "$env:USERPROFILE\downloads\Group Memberships.xlsx" .Link Get-UserReport Get-EndpointReport Get-GroupMembers #> [CmdletBinding()] Param ( [Parameter(Mandatory = $false)]$Path = "$env:USERPROFILE\downloads\AD Group Membership.xlsx" ) $ErrorActionPreference = 'silentlycontinue' Get-ADUser -Filter 'enabled -eq $true' -Properties DisplayName, memberof | ForEach-Object { New-Object PSObject -Property @{ UserName = $_.DisplayName Groups = ($_.memberof | Get-ADGroup | Select-Object -ExpandProperty Name) -join "," } } | Select-Object UserName, Groups | Export-Excel -WorksheetName "Group Memberships" -Path $path $ErrorActionPreference = 'continue' } |