AD Contact reports

 

AD Admin & Reporting Tool Logon Reports provides the following contact reports:

 

Active Directory All Contacts Report

All Contact report is created using the following sqlldap statement

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

 

Active Directory All Mail Enabled Contacts Report

All Mail enabled contact report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,mailNickname from RootDSE where objectClass=contact and objectClass=person and mailnickname is not null and targetAddress is not null subtreescope

 

Active Directory Recently Deleted Contacts Report

All Recently deleted Contacts report is created using the following sqlldap statement (All Deleted reports always run against the rootDSE)

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

 

Active Directory All Contacts Created Today Report

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

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

 

Active Directory All Contacts Created Yesterday Report

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

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

 

Active Directory All Contacts Created in Last 7 Days Report

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

 

Active Directory All Contacts Created in Last 30 Days Report

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

 

Active Directory All Contacts Created in Last 60 Days Report

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

 

Active Directory All Contacts Created in Last 90 Days Report

All Contacts 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 Contacts Created between.. Report

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

 

Active Directory All Contacts Modified Today Report

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

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

 

Active Directory All Contacts Modified Yesterday Report

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

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

 

Active Directory All Contacts Modified in Last 7 Days Report

All Contacts 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=group and modifyTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All Contacts Modified in Last 30 Days Report

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

 

Active Directory All Contacts Modified in Last 60 Days Report

All Contacts 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

 

Active Directory All Contacts Modified in Last 90 Days Report

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

 

Active Directory All Contacts Modified between.. Report

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

 

Active Directory All Contacts Specified Attribute is null or not present

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

 

Active Directory All Contacts Specified Attribute is not null or present

All Contacts 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=contact and $Atribute is not null subtreescope

 

 

Ldapsoft Home page AD Admin & Reporting Tool Home Page