Hi All,

Does anyone know how to return members of the Active Directory Group? I tried the above with no results:

SELECT * FROM OPENQUERY(ADSI, 'SELECT ciscoEcsbuDtmfID, department, ciscoEcsbuDtmfID, mail, title, cn, SAMAccountName
		FROM ''LDAP://DC=stago,DC=local''
		WHERE objectCategory = ''Group''
		AND memberof = ''appIPO''')

Thank you,
Daniel