I am using Crystal Reports XI to query Active Directory. Basically, I am able to create two separate reports, but I want to combine the info somehow into one report. So, I want to show the user account name, the users last and first name, and also the corresponding AD computer account as well as the operating system and operating system version.
I have and OLE DB (ADO) source setup and I have two ADSI commands that look like this.
Command1:
select Name, operatingSystem, operatingSystemVersion from 'LDAP://DC=domainname,DC=local' Where objectClass='computer'
Command2:
select samaccountname, sn, givenname, mail from 'LDAP://DC=domainname,DC=local' Where objectClass='user'
The problem is that I do not know how to link the two tables in order to find corresponding user and computer info.
Any help would be greatly appreciated.
Thanks.