User Guide

 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