I just want to find out the details or list the emmbers of a Particular Distibutin List by connecting through SQL. I understand tat there is a limitation of 1000 record, but my DL is not that big.My requirement is not very dynamic : Just list the members of a particular DLI followed the following but it gives a list of users but not the member of the DL.Step 1: Create a linked server to your Active Directory sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'Step 2: Create a view in SQL server using OPENQUERY to select from Active DirectoryCREATE VIEW dbo.vw_AD_USER_INFOAS SELECT * FROM OpenQuery(ADSI, 'SELECT title, displayName, sAMAccountName, givenName, telephoneNumber, facsimileTelephoneNumber, sn FROM ''LDAP://DC=whaever,DC=domain,DC=org'' where objectClass = ''User''')GO
Query AD for Group Membership
Posted - 2010-11-24 : 20:03:06
