Hey all, wondering how does one create a label to ...
# windows
d
Hey all, wondering how does one create a label to break out Windows servers? I've been playing with various string based around the os_version name but can't figure it out. What would be a good sql string?
s
select 1 from os_version where platform='windows'
should work
If you need to split servers from desktop os you would want
select 1 from os_version where platform='windows' and instr(name, 'Server') > 0;
d
Thanks, the second one worked out perfect.