AD Group reports

 

Ldap plus AD Help Desk Professional Tool give AD administrators and developers a quick view of all available groups (Secuirty, Distribution, Universal, Mail enabled). It provides the following group reports:

 

Active Directory All Groups Report

All Groups report is created using the following sqlldap statement

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

 

Active Directory All Groups with Member Report

All Groups with Member report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,member from RootDSE where objectClass=group and member is not null subtreescope

 

Active Directory All Groups without Member Report

All Groups without Member report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl from RootDSE where objectClass=group and member is null subtreescope

 

Active Directory All Managed Groups Report

All Managed Groups report is created using the following sqlldap statement

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

 

Active Directory All Un Managed Groups Report

All Un Managed Groups report is created using the following sqlldap statement

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

 

Active Directory All Security Groups Report

All Security Groups report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,groupType from RootDSE where objectClass=group and groupType:1.2.840.113556.1.4.804:=2147483648 subtreescope

 

Active Directory All Distribution Groups Report

All Distribution Groups report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,groupType from RootDSE where objectClass=group and (groupType:1.2.840.113556.1.4.804:!=2147483648 or sAMAccountType=268435457)
subtreescope

 

Active Directory All Universal Groups Report

All Distribution Groups report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,groupType from RootDSE where groupType:1.2.840.113556.1.4.803:=8 subtreescope

 

Active Directory All Mail Enabled Groups Report

All Main Enabled Groups report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mail,groupType from RootDSE where objectClass=group and mail is not null and sAMAccountType!=268435457 subtreescope

 

Active Directory Recently Deleted Groups Report

All Recently deleted Groups 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=group and isDeleted=TRUE subtreescope

 

Active Directory All Groups Created Today Report

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

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

 

Active Directory All Groups Created Yesterday Report

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

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

 

Active Directory All Groups Created in Last 7 Days Report

All Groups 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=group and createTimestamp >= CurrentTimestamp -7 days subtreescope

 

Active Directory All Groups Created in Last 30 Days Report

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

 

Active Directory All Groups Created in Last 60 Days Report

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

 

Active Directory All Groups Created in Last 90 Days Report

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

 

Active Directory All Groups Created between.. Report

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

 

Active Directory All Groups Modified Today Report

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

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

 

Active Directory All Groups Modified Yesterday Report

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

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

 

Active Directory All Groups Modified in Last 7 Days Report

All Groups 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 Groups Modified in Last 30 Days Report

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

 

Active Directory All Groups Modified in Last 60 Days Report

All Groups 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 Groups Modified in Last 90 Days Report

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

 

Active Directory All Groups Modified between.. Report

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

 

Active Directory All Groups Specified Attribute is null or not present

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

 

Active Directory All Groups Specified Attribute is not null or present

All Groups 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=group and mail is not null subtreescope

 

 

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