Hi there, I want to find whether specific user is member of the particular distribution group in AD or not. But when i am trying to get memberof field from AD using LDAP i am not getting any values. here is what i am using. So i know the input parameter of User Name and Group i want to look into. SELECT [Name], userPrincipalName, samAccountName,department,memberof FROM OPENQUERY( ADSI, 'SELECT Name, userPrincipalName, samAccountName,department,memberof FROM ''LDAP://Test/ DC=Test1,dC=Test2'' WHERE objectCategory=''person'' AND objectClass=''user'' AND samAccountName=''User-N'' and memberOf=''cn=TestGroup,dc=Test1,dc=Test2''') Is there something i am missing? Thanks!