Download list of protected computers PC

[CarlosPrg]

Hello,
does anyone know how to access information about backed up PCs for export (for example to the xls table)?

I need to receive a regular (or online) list of all my computers with status (name, user, last backup time and result). Is there a database or txt file from which I can get this information automatically? The list of all jobs results should be also fine.

The system-generated report is not very suitable.

Thanks a lot.
Karel

 

[Rusty]

ABB has a very detailed (but messy) log at /volume#/@ActiveBackup/log/agent/active-backup-agent.log

Maybe you can find some info in there.

 

[fredbert]

Looking in /volume#/@ActiveBackup there is activity.db which is a sqlite3 database. Maybe able to infer something from the tables after parsing the data?

$ sqlite3 activity.db
SQLite version 3.10.2 2016-01-20 15:27:19
Enter ".help" for usage hints.
sqlite> .headers on
sqlite> .tables
device_result_table  report_table         storage_log_table 
info_table           result_detail_table
log_table            result_table       
sqlite> select * from result_table;
result_id|status|task_id|task_name|backup_type|time_start|time_end|detail_path|task_config|success_count|warning_count|error_count|none_count|job_action
....<table data here>
sqlite> .exit
$

Could write a bash script to export out the table data in a format that can be opened by Excel.

 

[Rusty]

Good point m8!