Thanks for the reply,
I tried running this query agains tthe DB via SQL SMS and it didn't bring back anything.
When I tried to add it as a new filter (in Raw SQL query mode) the filter won't save and says theres an invalid resource or something?
I need to create a software filter for Symantec Endpoint Protection and Endpoint Encryption.
The idea here is to have the filters update as systems are inventoried, and if I use these filters for deployment, I can have the managed policy deliver to only PCs which are NOT in the software filter (which will detect installations)
Is this the best way to go about this?
The GUID for SEE is 7EDD1CCA-F75D-4DB2-A958-B2E83C840EAF
and for SEP its 2EFCC193-D915-4CCB-9201-31773A27BC06