PRUEBA AHORA

Exchange Groups

Active Directory Exchange Users

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

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

Show

Hide