→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
NiceGuy
Engaged Sweeper
Hi,

I've been wrestling with trying to get this to work. Basically, I'm trying to get the total count of Windows 7 installs in a specific Active Directory OU tree, but also excluding one of the sub OUs within that tree.

Basically, our AD tree looks something like this

Computers_US
-California
-Florida
-Colorado
-Montana

How would I build a report that shows how many Windows 7 installs there are for all of the OUs in the Computers_US, excluding Montana, for example?
1 REPLY 1
SBSTech
Engaged Sweeper II
I would try:

Where tblADComputers.OU Not Like '%California%' And Not Like 'Florida' And Not Like ...etc.