Search This Blog

Saturday, 4 April 2015

Data Protector built-in reports

There are four ways of getting reports out of HP Data Protector:

  • Using the built-in reports (listed below)
  • Querying the internal database directly (e.g. by setting up an ODBC connection to the PostgreSQL server on port 7116)
  • Running commands like omnidb and then massaging the results
  • Buying a copy of HP Backup Navigator -- note that HPE are currently running a Free Cloud-Hosted Trial of Backup Navigator which you can use even if you are behind a firewall.
The following list shows the built-in reports, which can be automatically emailed, logged, put on an intranet, broadcast as a Windows popup, and piped through another program. If the report you need is on this list, it will be very quick to set up. If it is not on this list, then the least effort will be to get a copy of Navigator and use that instead.

I have mostly copied this from the CLIReference.pdf documentation.

Configuration

Cell Information
A count of the number of clients, and some details about where the media management database is (local or remote).
Configured Clients not Used by Data Protector
Lists configured clients that are not used for backup and do not have any device configured.
Configured Devices not Used by Data Protector
Lists configured destination devices that are not used for backup, object copy, or object consolidation at all.
Lookup Schedule
List of backup, object copy, and object consolidation specifications that are scheduled to start in the next n number of days up to one year in advance (where n is the number of days specified by user).
Clients not Configured for Data Protector
List of clients in selected domain(s) that are not configured for Data Protector. Note that Data Protector will display also routers and other machines that have IP address in selected domain.
Licensing Report
Lists all licenses and the available number of licenses.
Client Backup Report
Report output is all end-user backup related information about a specific client: list of filesystems not configured for selected clients, list of all objects configured in backup specifications for the selected client, list of all objects with a valid backup for specified client with times and average sizes. Note that Client Backup reports do not include information about application integration backup objects and backup specifications.

Internal Database

Internal Database Size Report
Provides a table that contains information about the MMDB, CDB, archived log files, datafiles, and information for DCBF and SMBF.

Pools and Media

List of Pools
List of all media matching the search criteria. The following information is provided for each medium: ID, label, location, status, protection, used and total MB, the time when media was last used, the media pool, and media class.
Extended List of Media
List of all media matching the search criteria. The following information is provided for each medium: ID, label, location, status, protection, used and total MB, the time when media was last used, the media pool and media type, session specifications that have used this medium for backup, object copy, or object consolidation, as well as the session type and subtype. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, or object consolidation specification.
Media Statistics
Reports the statistics on the media matching the search criteria. The following information is provided: number of media; number of scratch media; number of protected, good, fair and poor media; number of appendable media; and total, used, and free space on media.
List of Media
Lists all pools matching a specified search criteria. For each pool the following information is provided: pool name, description, media type, total number of media, number of full and appendable media containing protected data, number of free media containing no protected data, number of poor, fair and good media.

Session Specifications

Trees in Backup Specification
Lists all trees in the specified backup specification. It also shows names of drives and the name of a tree.
Objects Without Backup
Lists all objects, specified for backup in selected backup specifications, which do not have a valid backup. A valid backup means that the backup completed successfully and its protection has not expired. For each object that does not have a valid protected full backup, the following items are shown: backup specification, an object type, an object name and a description. Only objects from the selected backup specification are used for the report. If HOST object is used: Host object is expanded (get disks) and report checks that expanded objects are in database. UNIX and Windows filesystems are supported. This option is not available for backup specifications for integrations.
Object's Latest Backup
Lists all objects in the IDB. For each object, it displays the last full and the last incremental backup time, the last full and the last incremental object copy time, and the last object consolidation time. Objects of the Client System type (host backup) are expanded; it means that the information is listed for each volume separately. As for objects of the Filesystem type (filesystem objects), only the UNIX and Windows filesystems are supported.
Average Backup Object Sizes
Lists all objects, specified for backup in selected backup specifications, which have a valid backup. A valid backup means that the backup completed successfully and its protection has not expired. For each object average full and average incremental backup size is displayed. If HOST object is used: Host object is expanded (get disks) and report checks that expanded objects are in database. UNIX and Windows filesystems are supported.
Filesystems Not Configured for Backup
Displays a list of mounted filesystems which are not in selected backup specifications. Output is a list of filesystems. If HOST object is used, the report will not report any disk from client as not configured (assuming that HOST backup will backup all disks). If HOST object is used, the report will not report any disk from client as not configured (assuming that HOST backup will backup all disks).
Session Specification Information
Shows information about all selected backup, object copy, object consolidation, and object verification specifications, such as type (for example, IDB, MSESE, E2010), session type, session specification name, group, owner, and pre & post exec commands. Host does not influence the report. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, object consolidation, or object verification specification.
Session Specification Schedule
Shows information about all selected backup, object copy, object consolidation, and object verification specifications and their next scheduled time up to one year in advance (type, session type, session specification name, group, next execution, and backup operation time). HOST does not influence report. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, object consolidation, or object verification specification.

Sessions in Timeframe

List of Sessions
Lists all sessions in the specified time frame. The report is defined by set of options that specify report parameters. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, object consolidation, or object verification specification.
Session Flow Report
Graphically presents duration of each session specified in certain time frame. Flow chart of the backup, object copy, object consolidation and object verification sessions matching search criteria is shown. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, object consolidation, or object verification specification.
Device Flow Report
Graphically presents usage of each device. Flow chart of the backup, object copy, and object consolidation sessions matching search criteria is shown. If you set the RptShowPhysicalDeviceInDeviceFlowReport global option to 1, the same physical devices (presented by their lock names or serial numbers) are grouped together. If there is no lock name or serial number specified, the logical name is displayed. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, or object consolidation specification.
Report on Used Media
Lists destination media that have been used by backup, object copy, and object consolidation sessions in the specific time frame together with their statistics. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, or object consolidation specification.
Extended Report on Used Media
Provides extended information on destination media that have been used by backup, object copy, and object consolidation sessions in the specific time frame, as well as the session type and subtype. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, or object consolidation specification.
Client Statistics
Lists of clients and their backup status - only clients that were used by the backup sessions matching the search criteria are displayed.
Session Statistics
Shows statistics about backup, object copy, and object consolidation status in the selected time frame, limited to sessions matching the search criteria. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, or object consolidation specification.
Session Errors
Shows list of messages that occur during backup, object copy, object consolidation, and object verification sessions in the specified time frame for selected session specifications. The messages are grouped by clients (for all selected clients). By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, object consolidation, or object verification specification.
Object Copies Report
Lists object versions that are created in the specified time frame with the number of their valid copies. The number of copies includes the original object version. By default, the report is generated for all session specifications. Use the report filtering options to generate a report only for a specific backup, object copy, or object consolidation specification.

Single Session

Generally, these reports only make sense to run at the end of a backup. You wouldn't put these into a scheduled report.
Single Session Report
Report displays all relevant information about single Data Protector backup, object copy, object consolidation, and object verification sessions.
Session Objects Report
Returns all information about all backup, object copy, or object consolidation objects that took part in a selected session.
Session per Client Report
Provides information for each client that took part in the selected backup session: statistics about backup status for the client, list of objects and their related information for the client, error messages for the client.
Session Devices Report
Provides information about all devices that took part in a selected session.
Session Media Report
Provides information about all destination media that took part in a selected session.
Session Object Copies Report
Lists object versions that are created in the selected backup, object copy, and object consolidation session with the number of their valid copies.


Greg Baker is an independent consultant who happens to do a lot of work on HP DataProtector. He is the author of the only published books on HP Data Protector (http://www.ifost.org.au/books/#dp). He works with HP and HP partner companies to solve the hardest big-data problems (especially around backup). See more at IFOST's DataProtector pages at http://www.ifost.org.au/dataprotector, or visit the online store for Data Protector products, licenses and renewals at http://store.data-protector.net/