AD OU Reports

 

Organizational unit reports provide adminsitrators and developers a quick insight into OUs, when they were created or modified. OU reports can be easily customized to suit the organization needs.

 

Active Directory All OUs Report

All OUs report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit subtreescope

 

Active Directory All OUs Created Today Report

All OUs Created Today report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and createTimestamp <= CurrentEndofDay and createTimestamp >=CurrentStartofDay
subtreescope

Active Directory All OUs Created Yesterday Report

All OUs Created Yesterday report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and createTimestamp <= CurrentEndofDay -1 days and createTimestamp >=CurrentStartofDay -1 days
subtreescope

 

Active Directory All OUs Created in Last 7 Days Report

All OUs Created in Last 7 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and createTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All OUs Created in Last 30 Days Report

All OUs Created in Last 30 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and createTimestamp >= CurrentTimestamp -30 days subtreescope

 

Active Directory All OUs Created in Last 60 Days Report

All OUs Created in Last 60 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and createTimestamp >= CurrentTimestamp -60 days subtreescope

 

Active Directory All OUs Created in Last 90 Days Report

All OUs Created in Last 90 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and createTimestamp >= CurrentTimestamp -90 days subtreescope

 

Active Directory All OUs Created between.. Report

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

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and createTimestamp >= $Timestamp1 and createTimestamp <= $Timestamp1 subtreescope

 

Active Directory All OUs Modified Today Report

All OUs Modified Today report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and modifyTimestamp <= CurrentEndofDay and modifyTimestamp >=CurrentStartofDay subtreescope

 

Active Directory All OUs Modified Yesterday Report

All OUs Modified Yesterday report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and modifyTimestamp <= CurrentEndofDay -1 days and modifyTimestamp >=CurrentStartofDay -1 days
subtreescope

 

Active Directory All OUs Modified in Last 7 Days Report

All OUs Modified in Last 7 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and modifyTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All OUs Modified in Last 30 Days Report

All OUs Modified in Last 30 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and modifyTimestamp >= CurrentTimestamp -30 days subtreescope

 

Active Directory All OUs Modified in Last 60 Days Report

All OUs Modified in Last 60 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and modifyTimestamp >= CurrentTimestamp -60 days subtreescope

 

Active Directory All OUs Modified in Last 90 Days Report

All OUs Modified in Last 90 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and modifyTimestamp >= CurrentTimestamp -90 days subtreescope

 

Active Directory All OUs Modified between.. Report

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

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and modifyTimestamp >=$Timestamp1 and modifyTimestamp <=$Timestamp2 subtreescope

 

Active Directory All OUs Specified Attribute is null or not present

All OUs 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,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and $Attribute is null subtreescope

 

Active Directory All OUs Specified Attribute is not null or present

All Printers 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,sAMAccountName,userAccountControl from RootDSE where objectClass=organizationalUnit and $Attribute is not null subtreescope

 


Ldapsoft Home page AD Admin & Reporting Tool Home Page