Andrea Allred presents RoyalSQL

Bringing happy endings to all your data stories.

Tag Archives: Active Directory

August 5, 2013 by andreaallred

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’

Posted in Awesome T-SQL
Tagged Active Directory, members, T-SQL
3 Comments

Post navigation

  • Pictures -Taken by Magic Mirrors
  • About the Royals
  • Playlist
  • SQL Server 2016 Discovery Day – SLC

News From The Kingdom

  • These are the ints that never die, we reseeded negative.
  • I Made That Slow Query Run, Run, Run
  • I can query multiple instances, I am King!
  • Hit me with them good vibes, CTfP is set nice. Everything is so fire, little bit of sunshine!
  • I’m going on down to New Orleans and renaming some database things…

Enter your email address to follow this blog and receive notifications of new posts by email.

Find Your Data Story

Royals Magic

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Blog at WordPress.com.
  • Follow Following
    • Andrea Allred presents RoyalSQL
    • Join 2,028 other followers
    • Already have a WordPress.com account? Log in now.
    • Andrea Allred presents RoyalSQL
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar