Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper II
I am using the query:

But I added the following to the Where statement.

And tblADGroups.Name Like '%Active Directory Group Name%'

When I run the report without my modifications, it will list all computers that are in the desired group, and any computers that are members to any of the sub groups.
When I add the additional WHERE condition, it only lists computers that are direct members of the listed group, but does not list computers that are members of groups in that group.

I tried to include a nested SELECT statement in the WHERE condition, but Lansweeper never finished the save.

Any suggestions?