How to Create a label for last sync time
So we are having licensing issues on our Kace 1000 and its due to old computers not on the kace anymore, trying to figure out a label to find computers that havnt synced up in the last 10 days 20 days etc so i can clean up the Kace a bit but i cant seem to figure out a proper Label to get what i want. Could anyone help me with the right process to create a label? Would be much appricated!
Answers (4)
Smart Labels are only assigned when a machine checks in, so that application will not work with machines which are not checking in. You can automatically cleanup MIA machines with the options under: Inventory > MIA > Choose Action > Configure Settings.
I totally forgot about the MIA option >< i knew there was some stuff i missed in the K1000 kick off! thank you very much! and Ty Philologist for the Query that def works for some other inventory tasks i am working on. Thanks guys
Comments:
-
No need to thank me; as I said, I'm pretty sure that's a default query. I use it to remind my help desk when they haven't cleaned up machines from the system by sending it out as an email report once a week. - philologist 12 years ago
You need solution specific to a label or any other solution will help as well? Considering you want to clean-up data of old machines from KACE, you can configure KACE to clean-up the machines automatically. Inventory - MIA - Configure Settings - (Mention the number of days.) Machines older than the specified days will be automatically deleted during a particular time. You dont need to manually do the task. KACE will take care of it automatically.
Hope this will help.
As per my understanding you can't create the lables for those machines that havn't synced up for last 10 -20 days, because machine checkin is required to bring the machines under any label..
This cleanup activity can be done via MIA, as suggested by Nitika...
Of note, you can also sort the machines by Last-Sync in computer inventory. I would use this and the MIA tab, as suggested. There is also a default report called Missing Machines in the reports section:
SELECT MACHINE.NAME AS SYSTEM_NAME, SC.DISCONNECT_TIME AS SC_DISCONNECT_TIME FROM MACHINE LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID WHERE ((DATE(SC.DISCONNECT_TIME)<= DATE_SUB(NOW(), INTERVAL 14 day)) AND (DATE(SC.DISCONNECT_TIME) != 0)) ORDER BY SC.DISCONNECT_TIME asc
This would be 14 days, you could just change the number to 10.
That said, if you really want a label, you can do it with Last-Sync and a regex, but it would be significantly over-complicated rather than just doing it with the inventory or MIA reports.