AD Computer reports

 

Ldap plus AD Help Desk Professional Tool has a comprehensive list of Active Directory Computer reports, such as:

 

Active Directory All Computers Report

All Computers report is created using the following sqlldap statement

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

 

Active Directory All Disabled Computers Report

All Disabled Computers report is created using the following sqlldap statement

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

 

Active Directory All Enabled Computers Report

All Disabled Computers report is created using the following sqlldap statement

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

 

Active Directory All Managed Computers Report

All Managed Computers report is created using the following sqlldap statement

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

 

Active Directory All UnManaged Computers Report

All UnManaged Computers report is created using the following sqlldap statement

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

 

Active Directory All Recently Deleted Computers Report

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

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName, userAccountControl from RootDSE where objectClass='computer' and isDeleted=TRUE subtreescope

 

Active Directory All Computers With Windows Vista Operating System Report

All Computers with Windows Vista Operating System report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Vista% subtreescope

 

Active Directory All Computers With Windows XP all Service Packs Report

All Computers with Windows XP Operating System all Service Packs report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem,operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows XP% subtreescope

 

Active Directory All Computers With Windows XP Service Pack 1 Report

All Computers with Windows XP Operating System Service Packs 1 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows XP% and operatingSystemServicePack=Service Pack 1 subtreescope

 

Active Directory All Computers With Windows XP Service Pack 2 Report

All Computers with Windows XP Operating System Service Packs 2 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows XP% and operatingSystemServicePack=Service Pack 2 subtreescope

 

Active Directory All Computers With Windows XP Service Pack 3 Report

All Computers with Windows XP Operating System Service Packs 3 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows XP% and operatingSystemServicePack=Service Pack 3 subtreescope

 

Active Directory All Computers With Windows Server 2003 Report

All Computers with Windows Server 2003 Operating System all Service Packs report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2003% subtreescope

 

Active Directory All Computers With Windows Server 2003 Service Pack1 Report

All Computers with Windows Server 2003 Operating System Service Pack 1 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2003% and operatingSystemServicePack=Service Pack 1 subtreescope

 

Active Directory All Computers With Windows Server 2003 Service Pack2 Report

All Computers with Windows Server 2003 Operating System Service Pack 2 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2003% and operatingSystemServicePack=Service Pack 2 subtreescope

 

Active Directory All Computers With Windows Server 2003 Service Pack3 Report

All Computers with Windows Server 2003 Operating System Service Pack 3 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2003% and operatingSystemServicePack=Service Pack 3 subtreescope

 

Active Directory All Computers With Windows Server 2000 Operating System Report

All Computers with Windows Server 2000 Operating System all Service Packs report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2000% subtreescope

 

Active Directory All Computers With Windows Server 2000 Service Pack1 Report

All Computers with Windows Server 2000 Operating System Service Pack 1 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2000% and operatingSystemServicePack=Service Pack 1 subtreescope

 

Active Directory All Computers With Windows Server 2000 Service Pack2 Report

All Computers with Windows Server 2000 Operating System Service Pack 2 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2000% and operatingSystemServicePack=Service Pack 2 subtreescope

 

Active Directory All Computers With Windows Server 2000 Service Pack3 Report

All Computers with Windows Server 2000 Operating System Service Pack 3 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2000% and operatingSystemServicePack=Service Pack 3 subtreescope

Active Directory All Computers With Windows Server 2000 Service Pack4 Report

All Computers with Windows Server 2000 Operating System Service Pack 4 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Windows Server 2000% and operatingSystemServicePack=Service Pack 4 subtreescope

Active Directory All Computers With Windows 2000 Operating System Report

All Computers with Windows 2000 Operating System all Service Packs report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Window 2000% subtreescope

Active Directory All Computers With Windows 2000 Service Pack1 Report

All Computers with Windows 2000 Operating System Service Pack 1 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Window 2000% and operatingSystemServicePack=Service Pack 1 subtreescope

 

Active Directory All Computers With Windows 2000 Service Pack2 Report

All Computers with Windows 2000 Operating System Service Pack 2 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Window 2000% and operatingSystemServicePack=Service Pack 2 subtreescope

 

Active Directory All Computers With Windows Server 2000 Service Pack3 Report

All Computers with Windows 2000 Operating System Service Pack 3 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Window 2000% and operatingSystemServicePack=Service Pack 3 subtreescope

Active Directory All Computers With Windows Server 2000 Service Pack4 Report

All Computers with Windows 2000 Operating System Service Pack 4 report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,operatingSystem, operatingSystemServicePack from RootDSE where objectClass=computer and operatingSystem like Window 2000% and operatingSystemServicePack=Service Pack 4 subtreescope

 

Active Directory All Non-Windows Operating System Report

All Computers 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=computer and operatingSystem !=Win* subtreescope

 

Active Directory All Computers Created Today Report

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

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

Active Directory All Computers Created Yesterday Report

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

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

 

Active Directory All Computers Created in Last 7 Days Report

All Computers 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=computer and createTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All Computers Created in Last 30 Days Report

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

 

Active Directory All Computers Created in Last 60 Days Report

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

 

Active Directory All Computers Created in Last 90 Days Report

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

 

Active Directory All Computers Created between.. Report

All Computers 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=computer and createTimestamp >= $Timestamp1 and createTimestamp <=$Timestamp2 subtreescope

 

Active Directory All Computers Modified Today Report

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

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

 

Active Directory All Computers Modified Yesterday Report

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

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

 

Active Directory All Computers Modified in Last 7 Days Report

All Computers 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=computer and modifyTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All Computers Modified in Last 30 Days Report

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

 

Active Directory All Computers Modified in Last 60 Days Report

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

 

Active Directory All Computers Modified in Last 90 Days Report

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

 

Active Directory All Computers Modified between.. Report

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

 

Active Directory All Computers Specified Attribute is null or not present

All Computers 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=computer and $Attribute1 is null subtreescope

 

Active Directory All Computers Specified Attribute is not null or present

All Computers 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=computer and $Attribute2 is not null subtreescope

 


Ldapsoft Home page Ldap plus AD Help Desk Professional Tool Home Page