How to get backup information (status, size, etc.) for 12.5 programmatically?
Any documents on API, REST, ... regarding how to get backup information for 12.5 programmatically
Hello Peter,
Thanks for the info.
Trying to collect raw data, like backup status, size, duration, ...; thus option 1 probably not working well in this case.
Like to learn more on option 3?
Is this document anywhere?
Where is the DB and what kind of DB?
Found reference to command line, will follow-up.
Hello Peter!
DB isn't documented at all, and unlikely to ever be. I mostly used this approach for ad-hoc queries, but it certainly can be made to work as reporting solution if you accept the risk of the db changing arbitrarily between versions. I mostly figured out what's stored where based on observation.
If you didn't configure an alternate DB during install you are using the built-in SQLite DB. I have the db in SQLServer, so I can't be sure what's what in sqlite. There are quite a few DBs though, so you might need to be prepared to query against several to build the report you want. They are in ProgramData\Acronis somewhere.
Here are my tips for your listed 3 properties. Please not that this is pure guesswork based on what I see in my own db and some developer expierence of how they might fit together.
- size: acronis_vault_manager db -> Backups or Archives table depending on what sort of size you are interested in
- status: this seems more involved as the UI compresses a lot of info that little field. So much so that I question the merit of rebuilding the logic of this
- Not protected: It likely means that your device (called resource on the db level) is missing a record in this table: acronis_backup_manager -> applied_policies
- Then you have all the errors you can see. Probably easier to look at the alerts, than checking for their cause yourself. (acronis_alert_manager -> alerts)
- OK is none of the above.
- duration: From what I can tell this isn't recorded explicitly with the backup, rather you have to look at the activity that produced the backup and see how long it took. Likely in: task_manager db
All in all it looks like a lot of work for what a few Reports would readily present. The downsides being:
- that you can't set a time range more than 30days
- Have the export in csv
- Export more often than once a day
Why do you need raw data if I may ask? What's it for? Perhaps there are less painful ways to achieve what you want.
-- Peter
Thanks for the info.
Our company products mine Backup metadata, such as # of backups, size, status and provide analytic; so asking our customer to create reports for export would not work for most customers.
I looked into the DB, VaultManager/acronis_vault_manager.db3, was not too helpful; perhaps the way how our configuration is.
The BackupManager/acronis_backup_manager.db, appears to have more data, but like you mentioned, there are many downside to this issue.
Perhaps having command as fall back.
Peter L
Hello Peter Leung,
I am also looking for same thing, if some how you were able to get the backup status, size, duration, into CSV then please share steps with me.
I am also straggling for the same thing