Kace Label New Machine
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.
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