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?

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

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. 

http://www.itninja.com/question/add-machines-to-manual-label-in-bulk

 

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>')))))
Answered 10/08/2013 by: dugullett
Red Belt

Please log in to comment

Answers

0

If you created a label off of the logged in user I would think that would change frequently depending on what machine that user logged into. So say a user who wanted a pop-up logged into a machine that didn't want the pop-up for whatever reason. That machine would then have that other label.

Have you thought about doing a manual label, or LDAP label? Do you have a list of the machine names, or just the users?

Answered 10/08/2013 by: dugullett
Red Belt

  • I definitely did not make it clear in the post, however I'm willing and able to figure out what the machine names are for the users in question. So, given I have a manual label of x machines, can I union it with a smart label? The union is the important part. I'm figuring I'll have to go pure sql if there's no method of doing it in the interface, but it just feels kludgey to have to do that.
Please log in to comment
Answer this question or Comment on this question for clarity

Share