Is there a method to create a union of two smart labels?
I am patching the machines in our organization. I have found that some of my users prefer that there be a KACE pop-up advising them to reboot during patches (install during the day, and notify at time of completion of reboot.) Other users prefer that I delay the patching until the overnight hours and forcefully reboot their systems no matter what.
I have a list of users who want either option, but now I'd like to do a union between the departmental list of what-machines-get-what-patch with the list of who-likes-what-kind-of-updates. Is it possible to reference one smart label from the sql of another smart label?
Community Chosen Answer
Sorry for the new answer. It's easier to read these SQL queries, and to know where you need to edit. If I'm understanding your question correctly this should work.
Edit the label name and machine name fields. My answer on this post may also help with the manual label part.
select MACHINE.*, C.CLIENT_CONNECTED, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE LEFT JOIN KBSYS.KUID_ORGANIZATION O ON O.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION C ON C.KUID = MACHINE.KUID AND O.ORGANIZATION_ID = 1 where ((( (1 in (select 1 from ORG1.LABEL, ORG1.MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID and MACHINE_LABEL_JT.LABEL_ID = LABEL.ID and LABEL.TYPE != 'hidden' and LABEL.NAME = '<LABEL NAME>')) and ( MACHINE.NAME IN ('<MACHINE_1>','<MACHINE_2>', '<MACHINE_3>')))))