ACRONIS BACKUP RECOVERY 10 MANAGEMENT SERVER REPORTS -, Installation Manual

Page: 14 / 23

14 Copyright © Acronis, Inc., 2000-2009
 The following query returns all failed backup plans that back up virtual machines:
SELECT * FROM BackupPlans WHERE
ManagedEntityType = 'VIRTUAL MACHINE' AND
Status = 'ERROR'
5.4.3 Column values
The BackupPlans view contains the following columns:
 Name – The name of the backup plan. For centralized backup plans, this is the same as the name
of the corresponding backup policy

Owner – The name of the user who owns the backup plan
 Type – The type of data that is backed up under the backup plan:
 CENTRALIZED DISK BACKUP – Disks or volumes of physical or virtual machines; centralized
backup plan

CENTRALIZED FILE BACKUP – Files; centralized backup plan
 VIRTUAL DISK BACKUP – Disks or volumes of a virtual machine; local backup plan

VIRTUAL DISK GROUP BACKUP – One or more entire virtual machines; local backup plan
 DISK BACKUP – Disks or volumes of a physical machine; local backup plan
 FILE BACKUP – Files of a physical machine; local backup plan
Known issue: In build 11345, the value VIRTUAL DISK BACKUP is shown when the value VIRTUAL DISK
GROUP BACKUP should be shown; and the value UNKNOWN is shown when the value VIRTUAL DISK
BACKUP should be shown. This issue will be fixed in the next product updates.
 Origin – The origin of the backup plan:

LOCAL – Local backup plan
 CENTRALIZED – Centralized backup plan

ExecutionState – The current execution state of the backup plan, which is based on the states of
its tasks:
 NEED INTERACTION – At least one task needs user interaction.
 RUNNING – At least one task is running, and there are no tasks that need user interaction.

WAITING – At least one task is waiting, and there are no tasks that are running or need user
interaction.
 STOPPING – At least one task is stopping, and there are no tasks that are running, need user
interaction, or waiting.

IDLE – All the tasks are idle.

Status – The status of the backup plan, which is based on the statuses of its backup tasks:
 OK – All the backup tasks have completed successfully.

WARNING – At least one backup task has succeeded with warnings, and there are no backup
tasks that have failed.
 ERROR – At least one backup task has failed.
 ScheduleType – The type of the backup plan's schedule:
 SCHEDULED – The backup plan is scheduled.
 MANUAL – The backup plan is not scheduled (you can only start its tasks manually).

LastBackupTime – The date and time when the last backup under the backup plan finished,
regardless of the result.