/build/static/layout/Breadcrumb_cap_w.png

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!


0 Comments   [ + ] Show comments

Answers (4)

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.
Posted by: aaronb09 12 years ago
Second Degree Blue Belt
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


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
Posted by: nitikasinghgaba 12 years ago
White Belt
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.

Posted by: manish_sharma3 12 years ago
Senior White Belt
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...

Posted by: philologist 12 years ago
Red Belt
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.

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