ITNinja

ORIGINAL: Gearshock

Is there a way to have a report sent on Monday, Wednesday, and Friday without creating multiple report instances? I would rather have one scheduled report than to have to create one for Monday, one for Wednesday, etc.
schedule it daily but first in report sql you could add a date component so it only returns results on those days:
... WHERE ...
and DAYOFWEEK IN (2,4,6)

You would have to remember that if you manually triggered it in between that it would return nothing. you could add more complexity in the where clause so that your restriction is only in place when the schedule fires. e.g. if your schedule is daily at 1am.
... WHERE ...
and 1= case when CURTIME()>'00:50:00' and CURTIME()<'1:10:00' and DAYOFWEEK(NOW()) IN (1,3,5,7) then 0
else 1 end)


Also how would I go about creating a scheduled report that notifies on run but then makes it available for later viewing without having files sent all over the place. Would that just be in the log files somewhere? Essentially, I want to be able to send notifications of ready reports but not load up the exchange server with a bunch of files every time a report runs. Then whoever gets the notification can go into the box or some alternate location and read the report at their convenience.

You cannot cache a report. You could send an email without a report that reminds them to go check it out and include a link to the helpdesk. but when they check it out it willbe run in that moment. similar to this except send it to a distribution list not a ticket. only follow steps 3.1, 3.2, 3.3 for this one since you're not sending it to the helpdesk here..

You could have it send the report to the helpdesk to create a ticket and read the attachment on a ticket? follow only step 1 and 2 for this option as the reporting schedule is creating the email (step 3)

Thanks very much for answering, I think that will likely solve my issues. I may try the service ticket idea if the team really needs to keep files out of exchange. Maybe that's a feature that the KACE team could consider; cache run reports for x amount of time and allow them to be viewable via HTML link sent in email notification.

If it works please +1 me. It's a good idea.

you may want to vote on:
http://kace.uservoice.com/forums/82699-k1000/suggestions/1414873-improved-report-scheduling-options

and perhaps create a new one for a cached copy as i couldn't find one existing

Voted before you requested. I'm not new to forums, just KACE. ;)

thanks!

You are welcome. :)