Members of windows group

  • 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

  • Koen Verbeeck (3/13/2014)


    Nice question, had me to do some research.

    Same here.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • 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

  • 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