This is my SQL script to look at user's uptime > 7 days (I am on 5.4 SP1):

SELECT USER_NAME, uptime, name


WHERE uptime > 7

ORDER BY user_name asc

It works great if you view in it Kace via HTML. However, when i set this up to run as an email report, this is what i get:

0 Comments   [ - ] Hide Comments


Please log in to comment

Community Chosen Answer



Make sure the name doesnt contain > or : try uptime report and try that

Answered 03/11/2013 by: jdornan
Red Belt

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



The only other thing i can think of is you still have Classic Reports as tab and you don't want to use that engine. If you don't, I can't think of anything else within the KBOX that would be causing it. 



Answered 03/07/2013 by: nshah
Red Belt

  • what do you mean by that?
  • When in reporting, there is the Report , Schedule Reports...etc..some KBOX have kept the Classic Reports tab during upgrades. If you don't see it there, you don't have it.
  • see below.
Please log in to comment

Looks like I have it, but i am not using the email report from there, i am using it from Email Alerts and choosing "Add New computer notification" 

Answered 03/07/2013 by: areiner
Fourth Degree Black Belt

  • Honestly...if you are only running this daily I would use the reports as it gives you more control and also the setting to not send a report if there isn't anything to report. If you still want to use Email Alerts and its not working, you may need to involve support to check it out.
  • Yeah i think i am, i really appreciate your help. I will post back here with a solution from Dell.
Please log in to comment