Acronis backup recovery 10 management server reports Guida All'Installazione
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.
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.
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
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).
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.
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.
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.
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.
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.
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:
past two days:
SELECT Machine FROM Tasks WHERE
HostType='AGENT'
GROUP BY HostID, Machine
HAVING MIN(DATEDIFF(d, LastFinishTime, GETUTCDATE())) > 2