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