is there a good way to exclude a label from a quer...
# kolide
w
is there a good way to exclude a label from a query like if i have a label for Windows Servers but want exclude a label with only DCs
z
That kind of operation is not supported. You could make a new label with a query that would do the exclusions and then target that.
w
ok im new to queries can i do one query then not another like
select codename from os_version where codename like "%server%" AND select hostname from system_info where hostname NOT like "%dc%"
z
You probably want something like `SELECT 1 FROM os_version JOIN system_info WHERE codename LIKE "%server%" AND hostname NOT LIKE "%dc%". Try it out via live query to see if returns the hosts you expect.
w
ok cool ill give it a shot