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

SELECT USER_NAME, uptime, name

FROM MACHINE M

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   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1

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

Answers

0

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. 

 

Sorry

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
0

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
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share