/build/static/layout/Breadcrumb_cap_w.png

How do I generate a report that shows me a list of computer names and the amount of time since their last sync?

Hello Folks,

I'm trying to generate a really simple report. I'm new to KACE and I'm still getting the hang of things. I tried looking for an answer to this question before I wrote it but couldn't find one.

I'm trying to generate a report of all the computers whose last sync was >3 hours ago. When I use the 'Computer Topic' in the report wizard there is no option to generate the report based on time since the last sync. I might be in the wrong place but I don't see it under any of the other topics and the Computer topic seems the most likely to allow me to generate this report based on the other options that are available to me.

Thank you for any assistance you can provide.

Asked 12 years ago 1302 views
0 Comments   [ + ] Show comments

Answers (1)

Posted by: dugullett 12 years ago
Red Belt
3

Not sure what all is needed in your report so I just added some random items.

select M.NAME, LAST_SYNC, IP, MAC

from MACHINE M

where (LAST_SYNC > CURDATE() - INTERVAL 3 hour)

ORDER BY M.NAME
Comments:
  • Thanks dugullett, going to try that now - jobla 12 years ago
 
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