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.

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

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
Answered 09/14/2012 by: dugullett
Red Belt

  • Thanks dugullett, going to try that now
Please log in to comment
Answer this question or Comment on this question for clarity