Looking for a way to query AD and get all groups a user is a member of including nested

• dan.denson

  SSC Enthusiast

  Points: 138

  More actions

  June 22, 2012 at 11:18 am

  #271673

  From active directory I need to pull a complete, recursive/nested listing of groups for a given list of users.

  For example

  User1 is in GroupABC

  GroupABC is in GroupDEF and GroupDEF is in GROUPGHI

  I need this output

  user | group

  User1 | GroupABC

  User1 | GroupDEF

  User1 | GroupGHI

  Need to be able to query it from SSRS, so I need this in a view or a snapshot of the output into a table. A view would be best.

  Any help greatly appreciated.

• okbangas

  SSChampion

  Points: 11773

  More actions

  June 23, 2012 at 5:16 am

  #1504734

  What you want is covered in Chapter 5 of Pro SQL Server 2005 Assemblies. Basically, you'll write a .NET CLR function querying AD.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]