I have a connection to our Active Directory with Crystal Reports XI but not all the fields return data. With the command below I do not get data for description, departmentnumber, and lastlogon. However, data is there in those fields. Any ideas?
SELECT cn, description, extensionAttribute13, extensionAttribute14, operatingsystem, operatingsystemservicepack, operatingsystemversion, departmentNumber, lastLogon
FROM 'LDAP://OU=Refresh 09 SOF Computers,OU=Hardware Refresh OUs,OU=09 Cass,OU=SOF,DC=fssa,DC=state,DC=in,DC=us'
where objectclass='computer'
IP Logged
