I'm trying to use Crystal Reports 2008 to create a report in Active Directory. I need to report on employees and the groups they are members of. I have currently set up to queries:
1. pulls data relating to users:
SELECT sAMAccountName, employeeID, department from 'LDAP://dc=test,dc=com' where objectClass = 'user' and objectCategory = 'person'
2. pulls a list of different groups.
SELECT cn, mail, memberOF FROM 'LDAP://dc=test,dc=com WHERE objectCategory='group'
What I need to do is find a column I can use to link between these two queries, but I cant seem to find a column I can use to link it with. Is this possible?