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.

LDAP All Objects Report

All Objects Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE
subtreescope

 

LDAP All Objects Created Today Report

All Objects Created Today Report is created using the following sqlldap statement

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

 

LDAP All Objects Created Yesterday Report

All Objects Created Yesterday Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp <= CurrentEndofDay -1 days and createTimestamp >=CurrentStartofDay -1 days subtreescope

 

LDAP All Objects Created in Last 7 Days Report

All Objects Created in Last 7 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -7 days subtreescope

 

LDAP All Objects Created in Last 30 Days Report

All Objects Created in Last 30 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -30 days subtreescope

 

LDAP All Objects Created in Last 60 Days Report

All Objects Created in Last 60 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -60 days subtreescope

 

LDAP All Objects Created in Last 90 Days Report

All Objects Created in Last 90 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >= CurrentTimestamp -90 days subtreescope

 

LDAP All Objects Created between.. Report

All Objects Created between the dates specified is created using the following sqlldap statement, you can specify from and to timestamp in the popup dialog.

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where createTimestamp >$TimeStamp1 and createTimestamp <= TimeStamp2 subtreescope

 

LDAP All Objects Modified Today Report

All Objects Modified Today Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp <= CurrentEndofDay and modifyTimestamp >=CurrentStartofDay subtreescope

 

LDAP All Objects Modified Yesterday Report

All Objects Modified Yesterday Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp <= CurrentEndofDay -1 days and modifyTimestamp >=CurrentStartofDay -1 days subtreescope

 

LDAP All Objects Modified in Last 7 Days Report

All Objects Modified in Last 7 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -7 days subtreescope

 

LDAP All Objects Modified in Last 30 Days Report

All Objects Modified in Last 30 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -30 days subtreescope

 

LDAP All Objects Modified in Last 60 Days Report

All Objects Modified in Last 60 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -60 days subtreescope

 

LDAP All Objects Modified in Last 90 Days Report

All Objects Modified in Last 90 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -90 days subtreescope

 

LDAP All Objects Modified between.. Report

All Objects Modified between the dates specified is created using the following sqlldap statement, you can specify from and to timestamp in the popup dialog.

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= $Timestamp1 and modifyTimestamp <= $Timestamp2 subtreescope

 

LDAP All Objects Specified Attribute is null or not present

All Objects where specified attribute is null report is created using the following sqlldap statement, you can specifiy the attribute in the popup dialog.

Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where $Attribute is null subtreescope

 

LDAP All Objects Specified Attribute is not null or present

All Objects where specified attribute is not null report is created using the following sqlldap statement, you can specifiy the attribute in the popup dialog.

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.

LDAP All Users Report

All Users Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp,businessCategory from RootDSE where objectClass=top and objectClass=person and objectClass=organizationalPerson and objectClass=inetOrgPerson subtreescope

 

LDAP All Users Created Today Report

All Users Created Today Report is created using the following sqlldap statement

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

 

LDAP All Users Created Yesterday Report

All Users Created Yesterday Report is created using the following sqlldap statement

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

 

LDAP All Users Created in Last 7 Days Report

All Users Created in Last 7 Days Report is created using the following sqlldap statement

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

 

LDAP All Users Created in Last 30 Days Report

All Users Created in Last 30 Days Report is created using the following sqlldap statement

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

 

LDAP All Users Created in Last 60 Days Report

All Users Created in Last 60 Days Report is created using the following sqlldap statement

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

 

LDAP All Users Created in Last 90 Days Report

All Users Created in Last 90 Days Report is created using the following sqlldap statement

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

 

LDAP All Users Created between.. Report

All Users Created between the dates specified is created using the following sqlldap statement, you can specify from and to timestamp in the popup dialog.

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

 

LDAP All Users Modified Today Report

All Users Modified Today Report is created using the following sqlldap statement

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

 

LDAP All Users Modified Yesterday Report

All Users Modified Yesterday Report is created using the following sqlldap statement

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

 

LDAP All Users Modified in Last 7 Days Report

All Users Modified in Last 7 Days Report is created using the following sqlldap statement

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

 

LDAP All Users Modified in Last 30 Days Report

All Users Modified in Last 30 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -30 days subtreescope

 

LDAP All Users Modified in Last 60 Days Report

All Users Modified in Last 60 Days Report is created using the following sqlldap statement

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

 

LDAP All Users Modified in Last 90 Days Report

All Users Modified in Last 90 Days Report is created using the following sqlldap statement

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

 

LDAP All Users Modified between.. Report

All Users Modified between the dates specified is created using the following sqlldap statement, you can specify from and to timestamp in the popup dialog.

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

 

LDAP All Users Specified Attribute is null or not present

All Users where specified attribute is null report is created using the following sqlldap statement, you can specifiy the attribute in the popup dialog.

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

 

LDAP All Users Specified Attribute is not null or present

All Users where specified attribute is not null report is created using the following sqlldap statement, you can specifiy the attribute in the popup dialog.

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.

LDAP All Groups Report

All Groups Report is created using the following sqlldap statement (Depending on Directory Server ObjectClass parameters will be adjusted accordingly)

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames
subtreescope

 

LDAP All Groups Created Today Report

All Groups Created Today Report is created using the following sqlldap statement (Depending on Directory Server ObjectClass parameters will be adjusted accordingly)

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp <= CurrentEndofDay and createTimestamp >=CurrentStartofDay subtreescope

 

LDAP All Groups Created Yesterday Report

All Groups Created Yesterday Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp <= CurrentEndofDay -1 days and createTimestamp >=CurrentStartofDay -1 days subtreescope

 

LDAP All Groups Created in Last 7 Days Report

All Groups Created in Last 7 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -7 days subtreescope

 

LDAP All Groups Created in Last 30 Days Report

All Groups Created in Last 30 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -30 days subtreescope

 

LDAP All Groups Created in Last 60 Days Report

All Groups Created in Last 60 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -60 days subtreescope

 

LDAP All Groups Created in Last 90 Days Report

All Groups Created in Last 90 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= CurrentTimestamp -90 days subtreescope

 

LDAP All Groups Created between.. Report

All Groups Created between the dates specified is created using the following sqlldap statement, you can specify from and to timestamp in the popup dialog.

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and createTimestamp >= $Timestamp1 and createTimestamp <=$Timestamp2 subtreescope

 

LDAP All Groups Modified Today Report

All Groups Modified Today Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp <= CurrentEndofDay and modifyTimestamp >=CurrentStartofDay subtreescope

 

LDAP All Groups Modified Yesterday Report

All Groups Modified Yesterday Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp <= CurrentEndofDay -1 days and modifyTimestamp >=CurrentStartofDay -1 days subtreescope

 

LDAP All Groups Modified in Last 7 Days Report

All Groups Modified in Last 7 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where modifyTimestamp >= CurrentTimestamp -7 days subtreescope

 

LDAP All Groups Modified in Last 30 Days Report

All Groups Modified in Last 30 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >= CurrentTimestamp -30 days subtreescope

 

LDAP All Groups Modified in Last 60 Days Report

All Groups Modified in Last 60 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >= CurrentTimestamp -60 days subtreescope

 

LDAP All Groups Modified in Last 90 Days Report

All Groups Modified in Last 90 Days Report is created using the following sqlldap statement

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >= CurrentTimestamp -90 days subtreescope

 

LDAP All Groups Modified between.. Report

All Groups Modified between the dates specified is created using the following sqlldap statement, you can specify from and to timestamp in the popup dialog.

Select cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and modifyTimestamp >$Timestamp1 and modifyTimestamp <=$Timestamp2 subtreescope

 

LDAP All Groups Specified Attribute is null or not present

All Groups where specified attribute is null report is created using the following sqlldap statement, you can specifiy the attribute in the popup dialog.

Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and $Attribute is null subtreescope

 

LDAP All Groups Specified Attribute is not null or present

All Groups where specified attribute is not null report is created using the following sqlldap statement, you can specifiy the attribute in the popup dialog.

Select mail, cn,creatorsName,createTimestamp,modifiersName,modifyTimestamp from RootDSE where objectClass=groupOfUniqueNames and $Attribute is not null subtreescope