Email reports not functioning properly- coming in blank
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
Answers (3)
Please log in to answer
Posted by:
jdornan
11 years ago
Make sure the name doesnt contain > or : try uptime report and try that
Posted by:
nshah
11 years ago
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
Posted by:
areiner
11 years ago
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" 
Comments:
-
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. - nshah 11 years ago
-
Yeah i think i am, i really appreciate your help. I will post back here with a solution from Dell. - areiner 11 years ago