Exporting list of machine names from Acronics Backup

Hello Nilsson!

I couldn't find a straightforward way to get a list from either the backup console or acrocmd. On SQL server you could use something like the below script. 

use acronis_backup_manager
go
SELECT TOP (1000) [id]
      ,[name]
      ,[display_name]
      ,[tenant_name]
      ,CASE WHEN [created_at] = 0 THEN null else DATEADD(S, CONVERT(int,LEFT( [created_at], 10)), '1970-01-01') end as [created_at]
      ,case when [updated_at] = 0 then null else DATEADD(S, CONVERT(int,LEFT( [updated_at], 10)), '1970-01-01') end as updated_at
      ,[comment]
      ,case when [last_backup] = 0 then null else DATEADD(S, CONVERT(int,LEFT( [last_backup], 10)), '1970-01-01') end as last_backup
      ,case when [last_success_backup] = 0 then null else DATEADD(S, CONVERT(int,LEFT( [last_success_backup], 10)), '1970-01-01') end as last_success_backup
      ,case when [next_backup] = 0 then null else DATEADD(S, CONVERT(int,LEFT( [next_backup], 10)), '1970-01-01') end as next_backup
FROM [acronis_backup_manager].[dbo].[resources]
where deleted_at = 0
and type = 1
order by name asc

go

-- Peter

Hello Per Nilsson,

welcome to Acronis forums!

I have configured a custom report (Overview -> Reports, click Add report, scroll down the list and select Custom, open it and click Add widget, select the first table Devices, in this new report click on the gear icon and uncheck all unnecessary columns):

Now you can download it either in PDF or Excel:

Unfortunately the Report option is available only in Acronis Backup

Advanced

How can I access the management servers sql backend? I use SQL Management Server but I don't know what credentials to use.

Hello Per Nilsson!

How can I access the management servers sql backend? I use SQL Management Server but I don't know what credentials to use.

It depends on how you chose to install AMS. Specifically if you specified an already existing user for the AMS service, and whether you chose SQL server/Windows authentication for connecting to MSSQL. You can likely login with a local administrator with windows auth though.

By the way with SQLite the same database can be found at C:\ProgramData\Acronis\BackupManager\acronis_backup_manager.db, and queried with DB browser https://sqlitebrowser.org/

-- Peter

Thanks. This is what i wanted.
I have never seen any SQL server installation option so I have obviously not used it.
From within sqlite browser I can find my info. Thanks.

Hello again.
When browsing through the sqlite databse, I cannot find the differnt backup plans.
I'd like to map machines <> applied backup plans.

Can you please give me a hint where the backup plan is located in the database?

Hello Per Nilsson!

Here's some more info:

•  collector DB
  • Path: C:\ProgramData\Acronis\MonitoringServer\am-database\collector.db
  • Table: backup_plan
    • You can find the backup_plan_id and backup plan displayname here. This info is probably aggregated from somewhere else, but I couldn't find both the id and displayname in other DBs.
    • Which machines it's applied to is also here in the protected devices column, but it's stored as binary. It looks like resource_ids are embedded here as string. If you convert the whole blob to string you can search for the resource ids with this regex:
      • [A-Z0-9)]{8}-[A-Z0-9)]{4}-[A-Z0-9)]{4}-[A-Z0-9)]{4}-[A-Z0-9)]{12}
•  backup manager DB
  •  Path: C:\ProgramData\Acronis\BackupManager\acronis_backup_manager.db
  • table: applied_policies, resources
    • Snippet to list machines with their backup plans:
                  select
                      policy_id,
                      r.display_name
                  from applied_policies ap
                  join resources r on ap.resource_id = r.id
                  order by policy_id

Join these two datasets and you have a BackupName - Machine name list

-- Peter

Hello Peter,

thank you for publishing and sharing the request examples.

Hello Per!

When browsing through the sqlite databse, I cannot find the differnt backup plans.
I'd like to map machines <> applied backup plans

This request could also be simply configured in the Reports section of the Management Console of the Advanced license version.

 

•  collector DB
  • Path: C:\ProgramData\Acronis\MonitoringServer\am-database\collector.db

Hello. 
On my server I don't have this MonitoringServer folder.

EDIT: Double post

Hello Per Nilsson!

It's likely only present if you installed monitoring server during installation.

-- Peter