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. […] 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 […]

  2. […] 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 […]

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s