Apologies if this question has been asked already.
I am trying run a query searching for all machines with Office 2000 SR-1 because we still have machines with this version and also with Office 2000 SR-3 too. The query works and produces the correct result however I would also like to use a wildcard for searching for specific departmental OU's but to exclude others. The query I run is using the 'Not Like' value. The OU's I have are as follows:
The x above indidicates the department which can one of many and I would like to exclude specfically any departments within the following value only:
I've tried various examples of using the % wildcard such as % % and %*% etc. If I search for a specific department such as OU=Legal,OU=SRG,DC=caaroot,DC=internal then this works ok but because I have many departments I would like to use a wilcard instead for the first part of the string.
The backend database is a SQL2000 server. Please see file attached showing query used.
Does anyone know if this is possible or is it a limitation with using wildcards in queries? Unless the syntax I am using is wrong?