Getting more information from the list plans command about each plan
On the Acronis Cyber Backup web application under Pans > Backup, you can see a list of plans along with some useful information in a table about each one. Things like: how many devices are associated with the plan, Status (by severity), Schedule and Destination.
I wanted to know if it was possible to get this level of information by using the command line? I noticed that you can get a list of all plans using "list plans" whicgh is a good start, but I'd like to see things like how many devices are associated with that plan, Status (by severity) etc - basically the information you get on the web application.
Péter Szatmári wrote:
Hello Alex!
This is more like an alternative, but you could configure a report. Take a look at the "plans widget" when making a custom report, but there are others witch contain similar aggregate info. You can schedule it to output its content to an excel each day.
With command line I don't think there is a single command to achieve this. You might be able to assemble similar data with multiple commands, but then you might also consider queries the databases acronis uses directly for similar info.
-- Peter
Hi Peter.
I need to be able to extract this data and display some of it in our in house software. Just checked out the report configuration and scheduling options - this is exactly what I needed! I can use the excel document the report schedule generates to write a script and extract the data I need.
I have one further question regarding the database option you mentioned.
I've read that by default AMS uses SQLite as an embedded database, but during installation it's possible to setup AMS to use something like Microsoft SQL Server. I believe this would allow you to connect to the database via something like SSMS and get the required information.
I wasn't the one who installed the Acronis software, and that person is long gone. Is there a way I can verify how the database has been installed to see if its queryable? Maybe through the acronis software itself, or looking at the installed files, or perhaps the windows registry has a key pointing to a .db3 file somewhere.
Hello Alex!
Is there a way I can verify how the database has been installed to see if its queryable?
Look into "C:\ProgramData\Acronis\VaultManager\vault_manager_db.db3" with DBBrowser for SQLite. If you can see entries in the Backups table for example, SQLite is in use (mine is empty and I'm using MSSQL backing store). If you don't have SQLite, I haven't yet found a way to find out where it connects. I guess you could monitor network traffic from your AMS machine and look for the user that's running AMS services having write rights on a database, if you otherwise have no internal knowledge how it was set up.
The schema appears to be really close for both SQLite and MSSQL, probably a similar query (barring SQL differences) can do the job whichever you have. Do take into account that some info will still be in SQLite dbs (like tasks) and you might need to handle joins accross several dbs. That and checking your solution won't break when upgrading as it's really not a supported way to integrate with Acronis.
-- Peter
I've found the .db3 file where you suggested looking - "C:\ProgramData\Acronis\VaultManager\vault_manager_db.db3" Opened it up in DBBrowser and there are entries in the backups table so it must be in use.
That's a good point about making sure the solution won't break when upgrading. I'll keep that in mind.
Thank you for your help!