Scheduling and Emailing Report Results

[Alex Williams_2]

Hi there

Is it possible to schedule reports to run automatically, and then once the results have been gathered, emailed to a recipient ? I already have alerts being emailed to me, but would like to set this up for disk utilisation reports to be run daily and the results emailed to me.

All help would be gratefully received

Regards
Alex

[Aravindh Rajaram]

There is no straightforward way available. What you can do is make use of the following command and then create a script that executes it as per your schedule and mail it for you.

Note: This command is available only with HPSIM 5.0

mxreport -e [-x HTML|XML|CSV] [-o fully-qualified-file-name] -x [report|category]

And for more info as to how to e-mail using scripts...http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=928452&admit=-682735245+1127860929338+28353475

[Alex Williams_2]

AMicSys

Many thanks for your help, although I will be honest and ask for more help ! When you mention about creating a script to schedule a report, would it be possible for you to detail this more ?

Many thanks
Alex

[Aravindh Rajaram]

You can write a perl script (or any other script/programming language that you are familiar with) that executes the command that i had mentioned earlier and the same script should be able to pick up the output of that command (basically the report) and send it as a mail. Now use the Microsoft's in built task scheduler and execute the script when required.

[deceit]

Hey dude,

I just wrote a simple one today to email me disk sizes each week. You can modify it to suit your reporting needs.

*Create the Report in HP SIM and call it "DiskUtilisation"
* Download Blat SMTP dos tool from http://sourceforge.net/project/showfiles.php?group_id=81910

Place blat in C:\Program Files\HP\Systems Insight Manager\Custom and create a report.cmd file.
Contents of file:
..\bin\mxreport -e -x HTML DiskUtilisation > "C:\Program Files\HP\Systems Insight Manager\Custom\Diskutilisation.htm"
blat Diskutilisation.htm -to Youremail@yourdomain.com -subject "Disk Utilisation Report for %date%"

This will generate the "DiskUtilisation" report and save it to "Diskutilisation.htm"
Blat will then email the html code inside the body of the email message.

(dont forget to run blat -install to configure your mail server/from address)