Find-DbaLoginInGroup
Stephen Bennett, sqlnotesfromtheunderground.wordpress.com | Simone Bizzotto (@niphlod)
Find-DbaLoginInGroup View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com , Simone Bizzotto (@niphlod) Windows, Linux, macOS Synopsis Discovers individual Active Directory users within Windows group logins on SQL Server instances. Description Connects to SQL Server instances and recursively expands all Windows Active Directory group logins to reveal the individual user accounts that inherit access through group membership. This function queries Active Directory to enumerate all users within each Windows group login, including nested groups, providing a complete view of who actually has access to your SQL Server through group-based authentication.
Read more
dbatools