AD Exchange Reports

 

Ldap plus AD Help Desk Professional Tool provides administrators and developers a quick view of the users and groups with email proxy enabled, users with webmail access etc. Out of the box it comes with the following exchange reports.

 

Active Directory Mailbox Enabled Users Report

All Mailbox Enabled Users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null subtreescope

 

Active Directory All Mail Enabled Users Report

All Mail Enabled Users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and targetAddress is not null subtreescope

 

Active Directory All Enabled Exchanges Report

All Enabled Exchanges 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 Users with Email Proxy Enabled Report

All Users with Email Proxy Enabled report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and proxyAddresses is not null subtreescope

 

Active Directory All Users with Email Proxy Disabled Report

All Users with Email Proxy Disabled report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and proxyAddresses is null subtreescope

 

Active Directory All Users with Default Sending Size

All Users with Default Sending Size report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname, msExchHomeServerName,submissionContLength from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and submissionContLength is null
subtreescope

 

Active Directory All Users with Restricted Sending Size

All Users with Restricted Sending size report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname, msExchHomeServerName,submissionContLength from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and submissionContLength is not null
subtreescope

 

Active Directory All Users with Default Recipient Size

All Users with Default Recipient size report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname, msExchHomeServerName, msExchRecipLimit from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and msExchRecipLimit is null subtreescope

 

Active Directory All Users with Restricted Recipient Size

All Users with Restricted Recipient size report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname ,msExchHomeServerName, msExchRecipLimit from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and msExchRecipLimit is not null subtreescope

Active Directory All Users with Default Receiving Size

All Users with Default Receiving size report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname, msExchHomeServerName,delivContLength from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and delivContLength is null subtreescope

Active Directory All Users with Restricted Receiving Size

All Users with Restricted Receiving size report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, mailNickname, msExchHomeServerName,delivContLength from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and delivContLength is not null
subtreescope

Active Directory All Users with Accept Messages from Everyone

All Users with accept messages from everyone report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName, userAccountControl, mailNickname,homeMDB, msExchHomeServerName,targetAddress,unauthOrig from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and (homeMDB is not null or msExchHomeServerName is not null or targetAddress is not null) and authOrig is null and unauthOrig is null subtreescope

 

Active Directory All Users with Accept Messages Restricted

All Users with restriction on accepting messages report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,mailNickname, homeMDB,msExchHomeServerName,targetAddress,unauthOrig from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and (homeMDB is not null or msExchHomeServerName is not null or targetAddress is not null) and (authOrig is not null or unauthOrig is not null) subtreescope

 

Active Directory All Users with Default Storage Limit

All Users with default storage limit report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,mailNickname, msExchHomeServerName,mDBUseDefaults from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and mDBUseDefaults=TRUE
subtreescope

 

Active Directory All Users with Mailbox size limit

All Users with mailbox size limit report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,mailNickname, msExchHomeServerName,mDBUseDefaults from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and mDBUseDefaults=FALSE subtreescope

 

Active Directory Users hidden from Exchange Address List

All Users hidden from exchange address list report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHidefromAddressLists from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and msExchHideFromAddressLists=TRUE subtreescope

 

Active Directory Users unhidden from Exchange Address List

All Exchanges Created in Last 30 Days report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHidefromAddressLists, msExchHideFromAddressLists from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and (msExchHideFromAddressLists=FALSE or msExchHideFromAddressLists is null) subtreescopepe

 

Active Directory Users whose mail is forwarded to another address

All users whose email is forwarded to another address report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl,altRecipient from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and altRecipient is not null
subtreescope

 

Active Directory All Outlook web access enabled users

All Outlook web access enabled users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHomeServerName,protocolSettings from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and (protocolsettings=*HTTP§1§1* or protocolsettings!=*OWA§0*) subtreescope

 

Active Directory All Outlook web access disabled users

All Outlook web access disabled users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHomeServerName,protocolSettings from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and (protocolsettings=*HTTP§0§1* or protocolsettings=*OWA§0*) subtreescope

 

Active Directory All POP3 enabled users

All POP3 enabled users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHomeServerName,protocolSettings from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and (protocolsettings=*POP3§1*) subtreescope

 

Active Directory All POP3 disabled users

All POP3 disabled users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHomeServerName,protocolSettings from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and (protocolsettings=*POP3§0*) subtreescope

 

Active Directory All IMAP4 enabled users

All POP3 enabled users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHomeServerName,protocolSettings from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and (protocolsettings=*IMAP4§1*)
subtreescope

 

Active Directory All IMAP4 disabled users

All POP3 disabled users report is created using the following sqlldap statement

Select cn,creatorsName,createTimeStamp,modifiersName,modifyTimeStamp,sAMAccountName,userAccountControl, msExchHomeServerName,protocolSettings from RootDSE where objectCategory='person' and objectClass='user' and sAMAccountType!=805306370 and mailNickname is not null and msExchHomeServerName is not null and (protocolsettings=*IMAP4§0*)
subtreescope

 

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