Get-SqlShowMbrs
Recursively enumerates AD and local groups handling built-in SQL Server Windows groups.
Syntax
Get-SqlShowMbrs [-server] <Server> [-group] <String> [<CommonParameters>]
Detailed Description
The Get-SqlShowMbrs function recursively enumerates AD/local groups handling built-in SQL Server Windows groups.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
server |
|
true |
false |
|
group |
|
true |
false |
|
Input Type
None
You cannot pipe objects to Get-SqlShowMbrs
Return Values
System.String
Get-SqlShowMbrs returns an array of System.String.
Examples
EXAMPLE 1
Get-SqlShowMbrs $(Get-SqlServer "Z002\sql2K8") "Z002\PayrollUsers"
This command gets a fully recursive list of members for the Windows group Z002\PayrollUsers.