/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 4 years 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 4 years ago
Posted by: consolvoj1 4 years 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. 

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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