by

The Fairytale girl’s in deep distress and had to query Active Directory

This is just a quick post about a simple why to find out what members are in an Active directory group.

EXEC master.dbo.xp_logininfo'MyDomain\MyGroup','members'

This will tell you what groups a user is in:

EXEC  master.dbo.xp_logininfo‘MyDomain\MyUser’,‘all’

About andreaallred

SQL Server and helping people is my passion. If I can make someone laugh, I know I have made a difference.

3 thoughts on “The Fairytale girl’s in deep distress and had to query Active Directory”

  1. Finding a common AD group for a set of users. | SQL Studies says:
    December 26, 2014 at 5:23 pm

    […] there are other ways to do this. Andrea Allred(b/t), for example, recently posted about using xp_logininfo to find AD information. This method is great but does require some external (AD) permissions that I don’t actually […]

    Reply
  2. Finding a common AD group for a set of users. - SQL Server - SQL Server - Toad World says:
    December 29, 2014 at 4:46 pm

    […] there are other ways to do this. Andrea Allred(b/t), for example, recently posted about using xp_logininfo to find AD information. This method is great but does require some external (AD) permissions that I don’t actually […]

    Reply
  3. User and User Group Queries | SQL Archives says:
    January 19, 2015 at 7:34 am

    […] https://royalsql.com/2013/08/05/the-fairytale-girls-in-deep-distress-and-had-to-query-acitve-director… […]

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s