Query Question

[abetzold]

Select count(*),
tblADGroups.Name As ADGroupName
From tblADMembership
Left Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Right Join tblADusers On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Where tblADGroups.Name Like 'VPN%'
group by tblADGroups.Name

Can someone help me with this? It works in management studio but not in LanSweeper.

[Bruce_B · Accepted solution]

The report was likely being rejected by the report builder because your count column didn't have an alias.

Select Count(*) As Total,
  tblADGroups.Name As ADGroupName
From tblADMembership
  Left Join tblADGroups On tblADMembership.ParentAdObjectID =
    tblADGroups.ADObjectID
  Right Join tblADusers On tblADMembership.ChildAdObjectID =
    tblADusers.ADObjectID
Where tblADGroups.Name Like 'VPN%'
Group By tblADGroups.Name