LDAP Group Reports

 

LDAP Admin & Reporting tool give ldap administrators and developers a quick view of all available groups. It provides the following group reports:

 

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

 

 

 

 

 

Ldapsoft Home page LDAP Admin & Reporting Tool Home Page