Data Protector 9 Database Schema
I'd like to write some reports straight from the Data Protector 9 Postgres database.
Is there a published schema of this database out there? If so does anyone have a link to it or is it HPs secret?
Thanks for that.
I have tried Backup Navigator and it doesn't provide what I need. The people that think they know more than everyone else want some quite specific reports 😉
Really quite soecific reports actually. My servers together provide 'services' (ie, general application services) and the reports required are to reference the backups of these 'services' and as such are not defined by server name or backup specification.
One way of providing this is to use, for instance, the "Description" field of the specification since this is not a technical configuration setting. I may be wrong but this doesn't seem definable within any reports, hence why I'd like to be able to run reports upon the actual IDB itself.
If anyone out there has any suggestions I'd be really receptive to them.
There is no public Schema description so far and I doubt there will ever be one.
Also saw HP changing the IDB Interna quite frequently with hotfixes, your Queries may therfore be short-lived.
We also need extensive Reports for our Customers and ended up using the session_objects Report, executed for each Backup-Type Session.
Uploaded to a separate DB it allows pretty much every Summary we need without impact to the Backup-Operation and even back several years for trend analysis.
please refer to OmniBack\bin\dbscripts. You can find all SQL procedures that are used to initialize/upgrade the database . HP did a great job to document everything in there. I found it pretty handy.
Please use the Like button below, if you find this post useful.