Find Detailed Information About Exchange Groups in Your Network
List all your Exchange groups along with information about the number of members, type, OU, SID and more. When scanning an Exchange server, information about mailboxes, users, licenses, groups and active sync devices is all retrieved. This report provides an overview of all the groups that were scanned along with details like the number of members, type, OU, SID and more. Find obsolete and empty groups or simply take a look at which users are a member of a specific group. From this report, you can also view the members of the groups by clicking on the group name. This way you can navigate from the group name, all the way to detailed information of the devices they use.
Exchange Groups Query
Select Top 1000000 'adgroup.png' As Icon,
tblExchangeGroup.GroupId,
Case
When tblExchangeGroup.DisplayName Is Null Or
tblExchangeGroup.DisplayName = '' Then tblExchangeGroup.Name
Else tblExchangeGroup.DisplayName
End As DisplayName,
Case
When members.cnt Is Null Then 0
Else members.cnt
End As Members,
tblExchangeGroup.SamAccountName,
tblExchangeGroup.GroupType,
tblExchangeGroup.RecipientTypeDetails,
tblExchangeGroup.OrganizationalUnit,
tblExchangeGroup.[Identity],
tblExchangeGroup.DistinguishedName,
tblExchangeGroup.Sid,
tblExchangeGroup.IsDirSynced,
tblExchangeGroup.WhenCreatedUTC,
tblExchangeGroup.WhenChangedUTC,
tblExchangeServer.AssetId As ServerAssetId,
tblExchangeServer.Name As ExchangeServer
From tblExchangeGroup
Inner Join tblExchangeServer On tblExchangeServer.ServerId =
tblExchangeGroup.ServerId
Left Outer Join (Select Count(tblExchangeGroupMember.UserId) As cnt,
tblExchangeGroupMember.GroupId
From tblExchangeGroupMember
Group By tblExchangeGroupMember.GroupId) members On members.GroupId =
tblExchangeGroup.GroupId
Order By DisplayName
