LDAP User Reports

 

LDAP Plus AD Help Desk Professional Tool User Reports give detailed information on users, it provides following types of user reports.

 

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

 

 

 

 

 

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