Public/Get-GroupMembers.ps1

Function Get-GroupMembers {
    <#
    .DESCRIPTION
    Get a list of Active Directory groups and the Members of those groups
 
    .PARAMETER Path
    Specifies the export directory and filename for the report
 
    .NOTES
    Requires Active Directory and ImportExcel Modules
 
    .Example
    Get-GroupMembers -Path "$env:USERPROFILE\downloads\AD Group Members.xlsx"
 
    .Link
    Get-UserReport
    Get-EndpointReport
    Get-GroupMemberships
    #>

    [CmdletBinding()]

    Param (
        [Parameter(Mandatory = $false)]$Path = "$env:USERPROFILE\downloads\AD Group Members.xlsx"
    )

    $ErrorActionPreference = 'silentlycontinue'

    Get-ADGroup -Filter * | Sort-Object Name | ForEach-Object { Get-ADGroupMember -Identity $_.Name |
        Select-Object objectClass, name, SamAccountName, distinguishedName, objectGUID |
        Export-Excel -FreezeTopRow -WorksheetName $_.name -TableName $_.name -Path $Path
    }

    $ErrorActionPreference = 'continue'
}