Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reporting with Active Directory

I have to create Crystal report on Active Directory database. The fields I want to use have some date Field for Example lastLogon and pwdLastSet.Active Directory stores the value of these fields in nano seconds since January 01, 1601 and the data type of the field is Large Integer/Interval. Here is an example of what is showing up in Active Directory for this field:

pwdLastSet: 127298886538437500

I am using the LDAP Query in Crystal Report Designer to fetch the data. Below is the example of LDAP Query I am using.

SELECT name, adsPath, pwdlastset

FROM ''LDAP://OU=comp,DC=AS,DC=local''

WHERE objectCategory = ''Person'' AND objectClass= ''user'''

Query runs successfully and I get these objects in Crystal report. Now when I drag these objects in CR I can see the value of name and adsPath but pwdlastset is blank even though the data is there for this field in Active Directory.

Crystal Reports shows the fields type of pwdlastset object as a String [65534] even though the field only contains numbers. Crystal might consider it to be a string since the number is so large. Does anyone know how I can get this data to show up in a report?

Not what you were looking for? View more on this topic or Ask a question