Copyright © Acronis, Inc., 2000-2009
9
VIRTUAL SERVER
– This value is reserved for use in future versions. Please disregard any rows
that currently have this value.
ManagedEntityID
– The unique identifier of the machine
HostID
– For a physical machine: the unique identifier of the agent that is installed on the
physical machine. For a virtual machine: the unique identifier of the agent that manages the
virtual machine.
HostType
– Reserved for use in future versions. Currently, the value in this column is always
AGENT
NextBackupStartTrigger
– The types of backup plan schedules on the machine:
NONE
– There are no backup plans.
MANUAL
– There are backup plans, but none of them run on a schedule (you can only start
them manually).
ON TIME
– There is a backup plan that runs on a time-based schedule—for example, daily.
ON EVENT
– There is a backup plan that runs on an event-based schedule—for example,
upon user logoff—and none of the backup plans run on a time-based schedule.
Note:
The backup plans that back up a virtual machine exist on the physical machine whose agent manages
the virtual machine.
NextBackupStartTime
– When the value in the
NextBackupStartTrigger
column is
ON TIME
, this
column contains the time when the next backup that runs on a time-based schedule will start.
5.2
Tasks
5.2.1
Description
The
Tasks
view contains information about the tasks that exist on physical machines and on storage
nodes. By using the
HostType
column, you can determine whether a task exists on a physical machine
or on a storage node.
To retrieve more information about the physical machine on which the task exists, or about the
backup plan to which the task belongs, you can join this view to the corresponding views by using the
LEFT JOIN
operator.
5.2.2
Query samples
The following query returns the list of all failed backup tasks:
SELECT * FROM Tasks WHERE
LastResult = 'FAILED' AND
Type LIKE '%BACKUP%'
The following query returns the list of registered machines on which no tasks have run within the
past two days:
SELECT Machine FROM Tasks WHERE
HostType='AGENT'
GROUP BY HostID, Machine
HAVING MIN(DATEDIFF(d, LastFinishTime, GETUTCDATE())) > 2
