Inventory Device Query
I am looking to create a SQL query that will identify the status of all devices in KACE.
So Duncan, define “Status”?
There is a status field in every device asset but that is set manually ( or by ticket rule), so for example, if you say Status as active is used when a device has checked in within the last 7 days, you can build your report to show you devices that have a check date of within the last 7 days.
If you are using ticket rules you could then get the report SQL to drive the rule and set the status to active on a schedule.
Reversely, you could then create the SQL to mark any device with a check in date older than 7 days as “missing” using a copy of the original ticket rule.
Is that the kind of stuff you had in mind?