Creating a custom report in OpsCenter

In addition to using the reports that come by default with OpsCenter, you can use the Custom Report Wizard to create custom reports that are unique to your installation.

After creating a custom report, you can modify the report, print, save, and email it.

As you work with different report categories, the Report Wizard displays different parameters. Many of the parameters are used for multiple report categories, and they appear in different combinations for each type.

You can create a custom report by using the parameters that are available in the Custom Report Wizard.

To create a custom report

In the OpsCenter console, click Reports > Report Templates.
Click Create New Report.
On the Select Report Creation Option page, click Create a Custom Report to start the Custom Report Wizard.

Select a report category from the Category drop-down list:

Agent	Select this category if you want to know about the configured Agents on the OpsCenter Server.
Backup/Recovery	Select this category to create reports on jobs, disk pool, logs, image, media, tape drive etc.

The Subcategories appear as per what you select from the Category drop-down list. From the Subcategory drop-down list, select one of the following report subcategories:

The following subcategory appears when you select Agent as the main category:

Agent Status

Select to view information specific to the Agent. For example, you can create a report that shows the configured Agents on the OpsCenter Server and the Agent status.

The following subcategories appear when you select Backup/Recovery as the main category:

Disk Pool	Select to view a consolidated report related to disk pool.
Job/Image/Media/Disk	Select to view job, image, media, or disk data. The reports based on this subcategory provide a consolidated view of job, image, media, and disk. For example, you can create a custom report that tells the number of images per job type or a tabular report that tells which image is backed up on which media. You can also view the backups that are taken on the disk.
Log	Select to view logs that are generated as a result of backup and recovery activity in NetBackup and Backup Exec.
Media	Select to view reports on media like tape media etc.
Tape Drive	Select to view reports on tape drives. This subcategory does not show reports related to media servers.The associated filter parameters, such as Tape Drive Device Host or Tape Drive Type appear.
Scheduled Jobs	Generate reports on Scheduled Jobs using this category. For example you can create a report that compares the scheduled time and the actual time for scheduled jobs.

Select a report format from the following formats in the View Type drop-down list:

Distribution	Display groupings or objects or resources in a pie chart.
Ranking	Display a horizontal bar graph showing all the data for each view level object, from greatest to the least, within the selected time frame.
Historical	Display a stacked (segmented) bar graph with a trendline superimposed over it showing the average upward and downward trends of the data over time.
Tabular	Display data in the form of a table.

Click Next.
In the Select Parameters panel of the Custom Report Wizard, select values for one or more report parameters. The report parameters that appear depend on the report category and the view type that you selected.
See Configuring timeframe parameters.
See About Custom Report Wizard parameters.
As you select parameters, the Content pane may refresh to display additional selections. For example, when you select a view filter, you are then given a choice of items on which to filter the report display.
Click Next.
In the Modify Display Options panel, define the measurements to be collected for historical, ranking, tabular, and distribution reports. Different display options are displayed for different view types.
See About display options.
Click Next.
In the View Report Data panel, you can view the report that is created as per your selection.
Click Next.
To return to the Custom Report Wizard and make changes to the report, click Back.
Save the report. Enter a report name, a description (optional), and location where you want to save the report.
Click Save.

Example 1: You may want to create a custom report based on your specific requirements. For example, you may want to create a daily status report of the clients that are backed up everyday.

This report gives the detailed tabular information of the jobs directory being backed up, its status (if it's successful, partially successful or failed), Level Type (Incremental, Full, Differential Incremental), the job file count and job size in the datacenter . You can enhance this report by adding more available columns based on the report requirement.

See the procedure to know how you can create a daily status report of the clients that are backed up everyday.

To create a daily status report of the clients that are backed up everyday

In the OpsCenter console, click Reports.
On the Report Templates tab, click Create New Report.
On the Report Wizard, select the Create a custom report option and click Next.
Select the Report Category as Backup/Recovery and the Subcategory as Job/Images/Media/Disk.
Select the Report View type as Tabular.
Click Next.
Select the appropriate timeframe for which you want to view the data.
Select the Job filter. Select the Column as Backup Job data type, Operator as =, and Value as Yes. Click Add.
Click Next.
Under Tabular Report Properties, select the Time Basis as Job End Time. Change the Display Unit as per your requirement.
Select Available columns from the list that appears:
- Backup Job File Count
- Backup Job Size
- Job Directory
- Job End Time
- Job Start Time
- Job Status
- Job Status Code
- Job Type
- Master Server
- Schedule Name
- Schedule/Level Type
Click Add.
Click Next to run the report.

Example 2: You may want to create a report that examines the number of tapes in each status category and its percentage.

To report on the distribution of tape status in your environment

In the OpsCenter console, click Reports.
On the Report Templates tab, click Create New Report.
On the Report Wizard, select the Create a custom report option and click Next.
Select the Report Category as Backup/Recovery and the Subcategory as Media.
Select the Report View type as Distribution.
Click Next.
Select the appropriate timeframe for which you want to view the data. You can also select No Time Basis.
Optionally, select any filters based on your requirement.
Click Next.

In the Distribution Chart Properties section, make the following selections:

Chart Type

Pie Chart

Report On

Media History Status

Report Data

Media ID

Count

Click Next.

Example 3: You may want to create a custom tabular report that shows the following information:

Know what jobs were successful in the past week for a specific master server
Show the amount of time the backup took
Show how large the backup was

To create a report showing successful backup job details for a master server

In the OpsCenter console, click Reports.
On the Report Templates tab, click Create New Report.
On the Report Wizard, select the Create a custom report option and click Next.
Select the Report Category as Backup/Recovery and the Subcategory as Job/Image/Media/Disk.
Select the Report View type as Tabular.
Change Relative Time Frame to Previous 1 Week
Under Filters, select Job. In the Column area, select Job Type, select the = Operator and choose a value of Backup.
Click Add.
Back under the Column heading, select Job Status leave the Operator at "=" and choose Successful as the value
Click Add.
Click Next.
Select the Time Basis as Job Start Time
You may change the Display Unit or Time Duration. For example if the master server takes smaller backups, then you may change the Display Unit to MB.
From the Available Columns list, select the following:
- Backup Job Size
- Client Name
- Job Duration
Click Add to move them under the Selected Columns area.
In the Selected Column area, perform the following operations for each of the rows:
- Click the check box next to Client Name on the right and click Move Up to make it the first row.
- On the Job Duration row, change Operation to Total.
- On the Job Size row, change Sort Order to Descending and Operation to Total.
Click Next.

More Information

About Custom Report Wizard parameters

Creating a custom report in OpsCenter

Feedback

Feedback