AD Object reports

 

AD Admin & Reporting Tool has a comprehensive list of Active Directory Object reports. All reports except for a few can be easily customized to fit your needs, you can easily add or remove more attributes to your report, set the report search base etc. You can also easily run the reports on different domain controllers. Below you can find detailed information on how these reports are created.

 

Active Directory All Objects Report

All Objects report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE
subtreescope

 

Active Directory All Objects Created Today Report

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

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

 

Active Directory All Objects Created Yesterday Report

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

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

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where createTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where createTimestamp >= CurrentTimestamp -30 days subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where createTimestamp >= CurrentTimestamp -60 days subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where createTimestamp >= CurrentTimestamp -90 days subtreescope

 

Active Directory All Objects Created between.. Report

All Objects 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 createTimestamp >$TimeStamp1 and createTimestamp <= TimeStamp2 subtreescope

 

Active Directory All Objects Modified Today Report

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

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

 

Active Directory All Objects Modified Yesterday Report

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

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

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where modifyTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where modifyTimestamp >= CurrentTimestamp -30 days subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where modifyTimestamp >= CurrentTimestamp -60 days subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where modifyTimestamp >= CurrentTimestamp -90 days subtreescope

 

Active Directory All Objects Modified between.. Report

All Objects 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 modifyTimestamp >= $Timestamp1 and modifyTimestamp <= $Timestamp2 subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where $Attribute is null subtreescope

 

Active Directory 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,sAMAccountName,userAccountControl from RootDSE where $Attribute is not null subtreescope

 

 

 

 

 


Ldapsoft Home page AD Admin & Reporting Tool Home Page