Using the Report Generator

Identifying the Reports

The first thing you need to decide is which reports you are going to require on a regular basis. Listed below are the modules in QSystem Monitor and the types of reports that can be obtained in each:

ModuleReport
History Summary Yearly Summary
  Monthly Summary
  Daily Summary
  Monthly Summary by Hour
Job Accounting Yearly Summary by Accounting Code
  Monthly Summary by Accounting Codes
  Monthly Summary by All Accounting Code
  Daily Summary by All Accounting Code
  Monthly Summary by User ID
  Daily Summary by User ID
  Monthly Summary by All User Ids
  Daily Summary by All User Ids
Disk Summary Monthly Summary by Library
  Monthly Summary by Attribute
  Monthly Summary by Object Type
  Monthly Summary by Owner
  Monthly Summary by Days Used
  Monthly Summary by Application
  Daily Summary by All Libraries
  Daily Summary by All Attributes
  Daily Summary by All Object Types
  Daily Summary by All Owners
  Daily Summary by All Days Used
  Daily Summary by All Applications

Identifying the Frequency

Once you've decided which reports you require, you must then determine when you want the reports to be generated. Typical examples might be an annual report of average response times, a monthly report of CPU usage, a weekly report of library growth, and so on.

Identifying the Format

Now you've decided which reports you require and when you want them generated, you must decide in which format you'd like to see the data.

The report generator allows you to output the data in a number of differing formats. The formats are defined below:

OutputDefinition
Print The graph is printed.
Bitmap The graph is output to a bitmap (.bmp) file.
Windows meta file The graph is output to a Windows metafile (.wmf) file.
JPEG The graph is output to a JPEG (.jpg) file.
CSV The data is output to a file in comma separated variable format.
Tabbed text The data is output to a file in tabbed format.

Creating a Report Generator File

In the following example, we've decided that we'd like to see the average CPU, RSP and TRN figures for two systems on a monthly basis. This data is to be reflected in a graphical JPG format.

The first thing we need to do is open the Report Generator module and then the History Summary module for the first system. Then, drill down to the data as we'd expect to see it.

Now, right-click this window and select the option to Add to Report Generator.The following window displays:

We've decided that we'd like the output in JPEG format, so select JPEG. You're asked where to save the file.

Enter the file name and click OK.

The next window asks you how the run date of the report is to be calculated:

Select a date in the calendar to ensure that you get the required date calculations in the Date Formula field. Experiment by changing the date in the calendar to see what effect it has on the formula.

In this example, we always want the previous month’s report, so select the option for "The last day of the month." This gives us the date calculation formula. Whenever we run the report, it will always produce data as if it were being run on the last day of last month.

Click OK.

Enter a title for the graph:

Click OK. You can see a record in the Report Generator window for this report:

Repeat the above for each of the other two bars, and then repeat for each of the other two systems. You should end up with the following window:

So, we now have a file holding six records, each of which generates a JPEG file of our monthly requirements.

Click File, then Save As and choose an appropriate name for the file.

To run the file, open the Report Generator module, open the file, and click the green triangle icon. Or, you can add the file to your PC scheduler so that the report runs automatically.

The Report Generator as a Windows Task

Reports that are created in Report Generator can be added to Windows as a task. Below are examples of setting up the task in Windows Vista and Windows 7.

Windows Vista

Use the parameter, Program/script, to run the Report Generator, and the parameter, Add arguments, to specify which Report Generator report to run.

In this example, the entire Program/script command will be:

"C:\Program Files\QSystem Monitor\rptgen.exe"

In this example, the Add arguments (optional) command will be:

/r "C:\Program Files\QSystem Monitor\Data\testsjb.rpt"

 

Windows 7

Use the parameter, Program/script, to run Report Generator, and the parameter, Add arguments, to specify which Report Generator report to run.

In this example, the entire Program/script command will be:

"C:\Program Files (x86)\QSystem Monitor\rptgen.exe"

In this example, the Add arguments (optional) command will be:

/r "C:\Program Files (x86)\QSystem Monitor\Data\testsjb.rpt"

  

 

REPORT GENERATOR FILE NAME VARIABLES

When creating Report Generator reports, you can use variables in the file name.

Below is an example of a report using the following variables:

%S for system name.
%M for month.
%D for day.
%Y for year.

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: January 11, 2018