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:
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 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.
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.
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
Primary 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 primary 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 primary 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 primary 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