LDAP Admin & Reporting Tool has a comprehensive list of LDAP Directory Object reports (LDAP Object Reports are only available with LDAP Admin & Reporting Tool and LDAP plus AD Help Desk Tool). All reports except for a few can be easily customized to fit your needs, you can easily add or remove more attributesto your report, set the report search base etc. Below you can find detailed information on how these reports are created.
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE
subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp <= CurrentEndofDay and createTimestamp >=CurrentStartofDay subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp <= CurrentEndofDay -1 days and createTimestamp >=CurrentStartofDay -1 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -7 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -30 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -60 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -90 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >$TimeStamp1 and createTimestamp <= TimeStamp2 subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp <= CurrentEndofDay and modifyTimestamp >=CurrentStartofDay subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp <= CurrentEndofDay -1 days and modifyTimestamp >=CurrentStartofDay -1 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -7 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -30 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -60 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -90 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= $Timestamp1 and modifyTimestamp <= $Timestamp2 subtreescope
Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where $Attribute is null subtreescope
Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where $Attribute is not null subtreescope
LDAP Admin & Reporting Tool User Reports give detailed information on users, below you can find detailed information on how these reports are created.
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp,businessCategory from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp <= CurrentEndofDay and createTimestamp >=CurrentStartofDay subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp <= CurrentEndofDay -1 days and createTimestamp >=CurrentStartofDay -1 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp,businessCategory from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp >= CurrentTimestamp -7 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp >= CurrentTimestamp -30 days
subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp >= CurrentTimestamp -60 days
subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp >= CurrentTimestamp -90 days
subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and createTimestamp >= $Timestamp1 and createTimestamp <= $Timestamp2 subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and modifyTimestamp <= CurrentEndofDay and modifyTimestamp >=CurrentStartofDay subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and modifyTimestamp <= CurrentEndofDay -1 days and modifyTimestamp >=CurrentStartofDay -1 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and modifyTimestamp >= CurrentTimestamp -7 days
subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -30 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp,businessCategory from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and modifyTimestamp >= CurrentTimestamp -60 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and modifyTimestamp >= CurrentTimestamp -90 days
subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and modifyTimestamp >$Timestamp1 and modifyTimestamp <= $Timestamp2 subtreescope
Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and $Attribute is null subtreescope
Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson and $Attribute is not null subtreescope
LDAP Admin & Reporting tool give ldap administrators and developers a quick view of all available groups, below you can find detailed information on how these reports are created.
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames
subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp <= CurrentEndofDay and createTimestamp >=CurrentStartofDay subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp <= CurrentEndofDay -1 days and createTimestamp >=CurrentStartofDay -1 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -7 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -30 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -60 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -90 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= $Timestamp1 and createTimestamp <=$Timestamp2 subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp <= CurrentEndofDay and modifyTimestamp >=CurrentStartofDay subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp <= CurrentEndofDay -1 days and modifyTimestamp >=CurrentStartofDay -1 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -7 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >= CurrentTimestamp -30 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >= CurrentTimestamp -60 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >= CurrentTimestamp -90 days subtreescope
Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >$Timestamp1 and modifyTimestamp <=$Timestamp2 subtreescope
Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and $Attribute is null subtreescope
Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and $Attribute is not null subtreescope