Creating a custom report in OpsCenter

Article:HOWTO71513  |  Created: 2012-02-08  |  Updated: 2012-02-08  |  Article URL http://www.symantec.com/docs/HOWTO71513
Article Type
How To


Environment

Subject


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.

See About Custom Report Wizard parameters

To create a custom report

  1. In the OpsCenter console, click Reports > Report Templates.

  2. Click Create New Report.

  3. On the Select Report Creation Option page, click Create a Custom Report to start the Custom Report Wizard.

  4. 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.

    Archive

    Select this report category if you use Enterprise Vault. To create reports, ensure that data is being collected from Enterprise Vault using the OpsCenter Agent.

    Backup/Recovery

    Select this category to create reports on jobs, disk pool, logs, image, media, tape drive etc.

  5. 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 Archive as the main category:

    Archive Storage

    Using this category you can generate reports to display information on archive storage, such as Vault Store or Vault Partition.

    Archive Target

    Using this category you can generate reports to display information of mailboxes / targets that were archived.

    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.

    With OpsCenter 7.5, 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 comapres the scheduled time and the actual time for scheduled jobs.

  6. 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.

  7. Click Next.

  8. 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.

  9. Click Next.

  10. 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.

  11. 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.

  12. 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

  1. In the OpsCenter console, click Reports.

  2. On the Report Templates tab, click Create New Report.

  3. On the Report Wizard, select the Create a custom report option and click Next.

  4. Select the Report Category as Backup/Recovery and the Subcategory as Backup Job/Image.

  5. Select the Report View type as Tabular.

    Click Next.

  6. Select the appropriate timeframe for which you want to view the data.

  7. Select the Job filter. Select the Column as Backup Job data type, Operator as =, and Value as Yes. Click Add.

  8. Click Next.

  9. Under Tabular Report Properties, select the Time Basis as Job End Time. Change the Display Unit as per your requirement.

  10. 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.

  11. Click Next to run the report.

    The following is a sample report view:

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

  1. In the OpsCenter console, click Reports.

  2. On the Report Templates tab, click Create New Report.

  3. On the Report Wizard, select the Create a custom report option and click Next.

  4. Select the Report Category as Backup/Recovery and the Subcategory as Media.

  5. Select the Report View type as Distribution.

    Click Next.

  6. Select the appropriate timeframe for which you want to view the data. You can also select No Time Basis.

  7. Optionally, select any filters based on your requirement.

    Click Next.

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

    Chart Type

    Pie Chart

    Report On

    Media History Status

    Report Data

    Media ID

    Count

  9. Click Next.

    The following is a sample report view:

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

  1. In the OpsCenter console, click Reports.

  2. On the Report Templates tab, click Create New Report.

  3. On the Report Wizard, select the Create a custom report option and click Next.

  4. Select the Report Category as Backup/Recovery and the Subcategory as Job/Image/Media/Disk.

  5. Select the Report View type as Tabular.

  6. Change Relative Time Frame to Previous 1 Week

  7. Under Filters, select Job. In the Column area, select Job Type, select the = Operator and choose a value of Backup.

    Click Add.

  8. Back under the Column heading, select Job Status leave the Operator at "=" and choose Successful as the value

    Click Add.

  9. Click Next.

  10. Select the Time Basis as Job Start Time

  11. 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.

  12. 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.

  13. 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.

  14. Click Next.

    The following is a sample report view:


Legacy ID



v34977559_v71396211


Article URL http://www.symantec.com/docs/HOWTO71513


Terms of use for this information are found in Legal Notices