AnsweredAssumed Answered

Daily reporting with Tuning Manager and RRDtool

Question asked by Vinod Subramaniam Employee on Feb 17, 2014
Latest reply on Jun 4, 2015 by jordan smith

Quite often there are situations where you may want a daily performance report emailed out from Tuning Manager.

You can modify the attached scripts to email daily reports on almost any metrics that is visible in Performance Reporter

 

1. Extract the attached XMLCONFIG.zip file to /opt/HiCommand/TuningManager/PerformanceReporter/conf/

 

2. Ensure that the following reports are present in Performance Reporter

    [ Import the attached file "ScheduledReports" in Performance Reporter ]

 

scheduledreportsscreen.png

3. Extract the scripts to any directory such as /usr/local/san

 

4. Modify daily_report.sh to use the email program you prefer to email the generated pdf file.

    e.g echo "Daily Performance Report" | mailx -a "daily_report_"$timestamp".pdf" -s "Daily Report" admin@company.com

 

5. Modify any constants such as array serial number etc in the shell scripts and run ./daily_report.sh

 

6. The generated report is attached as a pdf file. Generated RRDgraphs are below.

 

daily_report_1390580806_Page_1.png

 

daily_report_1390580806_Page_2.png

 

daily_report_1390580806_Page_3.png

 

daily_report_1390580806_Page_4.png

Outcomes