3.2.2 Outputting aggregated data to periodic reports
To output periodic (for example, weekly or monthly) reports, download the aggregated Item data from the Item management server and then execute an Excel macro.
Prerequisites
This operation is performed by the incident management administrator or the problem management administrator.
Procedure
-
In the main window (Item list view), click the Switch from the main screen button .
The main window (Item status view) appears.
-
From the menu of the main window (Item status view), select Accumulation data output to file.
The Accumulation data output to file window appears.
-
Specify conditions about the aggregated data to be output.
Specify settings, by referring to the examples in the following table.
Item
Configuration information
System
Business system
Process
Incident management
Accumulation unit
Day unit
Accumulation range
2015/10/01 to 2015/10/31
Data type
[Item data CSV]
- Note
-
The aggregated data to be output varies depending on Data type. For details, see Outputting accumulated Item data to a file in the JP1/Service Support Configuration and Administration Guide.
-
Click the Download data button.
The dialog box for downloading the aggregated data appears.
-
Save the aggregated data in a location of your choice.
-
From the menu of the Accumulation data output to file window, select Download macro.
The dialog box for downloading the macro appears.
-
Save the macro in the location where you saved the aggregated data in step 5.
-
In Excel, open the macro that was saved in step 7.
- Note
-
If Security Warning Macros have been disabled appears, click the Options button to display the Microsoft Office Security Options dialog box. In the dialog box, select Enable this content, and then click the OK button.
-
Select the report to be created, and then click the Generate report button.
In this example, select Average required time and then click the Generate report button.
The macro runs, and the report is automatically created.
Related topics
-
Outputting accumulated Item data to a file of the JP1/Service Support Configuration and Administration Guide