/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Kace Label New Machine

02/21/2020 247 views

Hello,


I been trying to create a label that would push software to new machines detected with Kace1000 but I am not having much luck. Does anyone have a post/thread that I can look to see how I can build such label? Thank you.

Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0

The easiest may be just to create a smart label based on the creation date. ie creation date within the last two days. 

Answered 02/26/2020 by: consolvoj1
Senior White Belt

All Answers

0

There are two options:
1. you can create a label with the label wizard which checks for new machines (it checks for machines which are new in the inventory in the last 36hr)
This would give a SQL like that:

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 36 HOUR))))  

2. you can check for specialities when the system was deployed. (it checks for systems which were deployed in the last 2 days (48hr)
If you are using the SDA for the deployment, an option would be a Custom Inventory Rule which checks for the deployment file.

As an example this one checks for both, the old Dell and the current Quest location

FileInfoReturn(C:\ProgramData\Dell\KACE\k2000_deployment_info.conf, CreatedDate, DATE) OR FileInfoReturn(C:\ProgramData\Quest\KACE\k2000_deployment_info.conf, CreatedDate, DATE)

Then you can create a label querying for that like the option 1.
Please be aware that the CIR number is different in your env so you need to check this by yourself (or create it via wizard)

SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE   WHERE ((( exists  (select 1 from MACHINE_CUSTOM_INVENTORY where MACHINE.ID = MACHINE_CUSTOM_INVENTORY.ID and MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = 119 and (TIMESTAMP(MACHINE_CUSTOM_INVENTORY.DATE_FIELD_VALUE) <= NOW() AND TIMESTAMP(MACHINE_CUSTOM_INVENTORY.DATE_FIELD_VALUE) > DATE_SUB(NOW(),INTERVAL 48 hour)))) ))  
Hope this helps
Answered 02/21/2020 by: Nico_K
Red Belt

  • thanks for the information, it was very detailed.
 
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