cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Domain computers and the Active Directory NESTED groups they belong to

Viper
Engaged Sweeper II
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?
0 REPLIES 0