/build/static/layout/Breadcrumb_cap_w.png

Aggressively patching a new machines added to Kace

I am trying to create a smart label that will collect machines that have been recently (within the last 24 hours) added to Kace; I do not care when the OS was installed.  
What I would like to do with this label is then assign it to an aggressive patching sequence.   However, it appears that most of my machines are being added to this smart label.  Which is really strange because if I run the mysql using MYSQL workbench it works correctly.  So with smart labels, if a machine is added does it not remove itself once it no longer satisfies the criteria?  

SELECT MACHINE.NAME AS SYSTEM_NAME
 FROM MACHINE where CREATED   > DATE_SUB(NOW(), INTERVAL 1 DAY)   ORDER BY SYSTEM_NAME

2 Comments   [ + ] Show comments
  • Are you using this exact query in the smart label? I made a label like this on my KBox using the wizard and this is the query is generated:
    SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE (((TIMESTAMP(MACHINE.CREATED) <= NOW() AND TIMESTAMP(MACHINE.CREATED) > DATE_SUB(NOW(),INTERVAL 1 DAY))))

    At this point it is only applying to the correct machines. - chucksteel 10 years ago
    • Chuck that appears to be working! Thanks again! - Jbr32 10 years ago
  • Thanks Chuck! Yes I am using the exact query above, I created it manually. I will try your query and let you know. - Jbr32 10 years ago

Answers (1)

Posted by: MacDude 10 years ago
Fifth Degree Brown Belt
0
Answered in Comments.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ