LDAP Object reports

 

LDAP Plus AD Help Desk Professional Tool has a comprehensive list of LDAP Object reports, such as:

 

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

 

 

 

 

 

Ldapsoft Home page LDAP Plus AD Help Desk Professional Tool Home Page