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!

Answer Summary:
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.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2

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

Answered 05/14/2012 by: aaronb09
Second Degree Blue Belt

  • 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.
Please log in to comment

Answers

1

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.

Answered 05/14/2012 by: nitikasinghgaba
White Belt

Please log in to comment
1

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...

Answered 05/14/2012 by: manish_sharma3
Senior White Belt

Please log in to comment
1

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.

Answered 05/14/2012 by: philologist
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity