March 14, 2014 at 8:31 am
try
xp_cmdshell 'dsquery group -name <group_name> |dsget group -members -expand'
and this allows for the potential to expand sub-groups
xp_cmdshell IS a correct answer
March 16, 2014 at 2:33 am
Koen Verbeeck (3/13/2014)
Nice question, had me to do some research.
Same here.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
March 16, 2014 at 2:34 am
Anoo S Pillai (3/13/2014)
SQLRNNR (3/13/2014)
Based on the wording of the question, I have to throw this out there too!
xp_cmdshell 'net localgroup administrators'
GO
xp_cmdshell 'WMIC USERACCOUNT LIST BRIEF'
GO
xp_cmdshell 'WMIC USERACCOUNT LIST FULL'
GO
Which extended stored procedure can be used to find members of a Windows group?
By that wording alone, we have multiple correct answers.
I got it right, but xp_cmdshell too can be a right answer. 😉
True.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
March 18, 2014 at 12:51 am
too easy thanks.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply