We’re currently experiencing a high volume of support requests, which may result in longer response times — thank you for your patience and understanding.
Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
abetzold
Engaged Sweeper III
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.
1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Bruce_B
Lansweeper Alumni
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

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now