/build/static/layout/Breadcrumb_cap_w.png

Kace Label New Machine

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.


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Nico_K 11 months ago
Red Belt
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

Comments:
  • thanks for the information, it was very detailed. - IT_Guy82 10 months ago
Posted by: consolvoj1 10 months ago
Senior White Belt
0

Top Answer

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

 
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