AD Printer Reports

 

Out of the box AD Admin & Reporting Tool provides the following printer reports:

 

Active Directory All Printers Report

All Printers report is created using the following sqlldap statement

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

 

Active Directory All Disabled Printers Report

All Disabled Printers report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=printqueue and userAccountControl:1.2.840.113556.1.4.803:=2 subtreescope

 

Active Directory All Enabled Printers Report

All Enabled Printers report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=printqueue and userAccountControl:1.2.840.113556.1.4.803:!=2 subtreescope

 

Active Directory All Managed Printers Report

All Managed Printers report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,managedBy from RootDSE where objectClass=printqueue and managedby is not null subtreescope

 

Active Directory All UnManaged Printers Report

All UnManaged Printers report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,managedBy from RootDSE where objectClass=printqueue and managedby is null subtreescope

 

Active Directory All Recently Deleted Printers Report

All Recently deleted Printers report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=printqueue and isDeleted=true subtreescope

 

Active Directory All Printers Created Today Report

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

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

Active Directory All Printers Created Yesterday Report

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

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

 

Active Directory All Printers Created in Last 7 Days Report

All Printers 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=printqueue and createTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All Printers Created in Last 30 Days Report

All Printers 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=printqueue and createTimestamp >= CurrentTimestamp -30 days subtreescope

 

Active Directory All Printers Created in Last 60 Days Report

All Printers 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=printqueue and createTimestamp >= CurrentTimestamp -60 days subtreescope

 

Active Directory All Printers Created in Last 90 Days Report

All Printers 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=printqueue and createTimestamp >= CurrentTimestamp -90 days subtreescope

 

Active Directory All Printers Created between.. Report

All Printers 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=printqueue and createTimestamp >= $Timestamp1 and createTimestamp <= $Timestamp1 subtreescope

 

Active Directory All Printers Modified Today Report

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

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

 

Active Directory All Printers Modified Yesterday Report

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

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

 

Active Directory All Printers Modified in Last 7 Days Report

All Printers 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=printqueue and modifyTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All Printers Modified in Last 30 Days Report

All Printers 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=printqueue and modifyTimestamp >= CurrentTimestamp -30 days subtreescope

 

Active Directory All Printers Modified in Last 60 Days Report

All Printers 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=printqueue and modifyTimestamp >= CurrentTimestamp -60 days subtreescope

 

Active Directory All Printers Modified in Last 90 Days Report

All Printers 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=printqueue and modifyTimestamp >= CurrentTimestamp -90 days subtreescope

 

Active Directory All Printers Modified between.. Report

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

 

Active Directory All Printers Specified Attribute is null or not present

All Printers 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=printqueue and $Attribute is null subtreescope

 

Active Directory All Printers 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=printqueue and $Attribute is not null subtreescope

 

Ldapsoft Home page AD Admin & Reporting Tool Home Page