Post reply

Using sql to search inside an AD group

  • November 7, 2013 at 12:06 pm

    #279000

    I am having issues with a LAN admin putting their username in a SQL AD group to gain access to SQL.

    Is there a way to use a SQL query to scan the inside of an AD group to see the members?

    I have been looking and haven't found a way yet. Any help would be greatly appreciated

    This way I can monitor the group from SQL.

    Thanks

  • November 7, 2013 at 2:26 pm

    #1664928

    Just replace Domain\SecurityGroup in the query below with the actual domain and security group you want to know about.

    EXEC xp_logininfo 'Domain\SecurityGroup','members'

  • November 7, 2013 at 3:46 pm

    #1664949

    Perfect! Works like a charm. Now I can track the members of my group.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply