Hi Kris.
If I execute the following command ( with a whereclause as suggested by cdtj )
bop_odump domsrvr cr "active=1 and ( not ( affected_service.name in ( 'name1', 'name2' )) or affected_service is null)" ref_num affected_service.name
I get tickets with and without an affected service, but none with an affected service equals to 'name1' or 'name2'.
Is this what you are looking for? Does it work for you in the same way? If so, I would wonder, that this would not work as a data partition view constraint. Did you relogin after changing the constraint?
Kind regards
...............Michael