I am using the query:
https://www.lansweeper.com/forum/yaf_postst10519_Domain-computers-and-the-Active-Directory-groups-they-belong-to.aspx#post39491
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?
