ACRONIS BACKUP RECOVERY 10 MANAGEMENT SERVER REPORTS -, Installation Manual

Page: 13 / 23

Copyright © Acronis, Inc., 2000-2009 13
 The following query returns failed backup policies that perform file-level backups:
SELECT * FROM Policies WHERE
Status = 'ERROR' AND
SourceType = 'CENTRALIZED FILE BACKUP'
5.3.3 Column values
The Policies view contains the following columns:
 Name – The name of the policy
 SourceType – The type of data that is backed up under the policy:

CENTRALIZED DISK BACKUP – Disks or volumes of physical or virtual machines
 CENTRALIZED FILE BACKUP – Files

IsDeploying – Equals 1 if the policy is in the Deploying state on at least one machine; otherwise,
equals 0
 IsDeployed – Equals 1 if the policy is in the Deployed state on at least one machine; otherwise,
equals 0

IsUpdating – Equals 1 if the policy is in the Updating state on at least one machine; otherwise,
equals 0
 IsRevoking – Equals 1 if the policy is in the Revoking state on at least one machine; otherwise,
equals 0
 Status – The cumulative status of the policy statuses on all machines the policy is applied to:

OK – The policy status on all machines is OK .
 WARNING – There is a machine on which the policy status is Warning , and there are no
machines on which the policy status is Error .

ERROR – There is a machine on which the policy status is Error .

Schedule – The schedule type of the policy:
 SCHEDULED – The policy is scheduled.

MANUAL – The policy is not scheduled (you can only start the corresponding centralized
backup plans manually).
 Owner – The name of the user who owns the policy
 Comments – Policy comments

OwnerUID – The unique identifier of the user who owns the policy
 ID – The unique identifier of the policy
5.4 Backup plans
5.4.1 Description
The BackupPlans view contains the list of all local and centralized backup plans. The origin of the
backup plan (local or centralized) is determined by the Origin column.
5.4.2 Query samples

The following query returns the scheduled backup plans that have not run within the past week:
SELECT * FROM BackupPlans WHERE
ScheduleType = 'SCHEDULED' AND
DATEDIFF(d, LastBackupTime, GETUTCDATE()) > 7