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

* Get-SqlShowMbrs

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.