Download list of protected computers PC

Currently reading
Download list of protected computers PC

1
0
NAS
RS3618xs, ...
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
 
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?

Bash:
$ 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.
 

Create an account or login to comment

You must be a member in order to leave a comment

Create account

Create an account on our community. It's easy!

Log in

Already have an account? Log in here.

Welcome to SynoForum.com!

SynoForum.com is an unofficial Synology forum for NAS owners and enthusiasts.

Registration is free, easy and fast!

Trending threads

Back
Top