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