ACRONIS BACKUP RECOVERY 10 MANAGEMENT SERVER REPORTS -, Installation Manual

Page: 8 / 23

8 Copyright © Acronis, Inc., 2000-2009
 The following query returns the list of all offline machines that run any of the Windows Server
operating systems:
SELECT * FROM Machines WHERE
OperatingSystem LIKE '%Windows%Server%' AND
Availability = 'OFFLINE'

The following query returns the list of virtual machines that are hosted on the ESX/ESXi host with
IP address 10.1.2.3 and are managed by Agent for ESX/ESXi:
SELECT
Machine.Name,
Machine.Availability,
Machine.LastBackup,
Machine.Status
FROM Machines AS Machine
INNER JOIN Machines AS Appliance ON Machine.HostID = Appliance.HostID
WHERE
Machine.ManagedEntityType = 'VIRTUAL MACHINE' AND
Appliance.Name = '10.1.2.3-VA'
ORDER BY Machine.Name
5.1.3 Column values
The Machines view contains the following columns:

Name – The name of the machine. This name is determined by the operating system that the
machine runs.

Status – The status of the machine, which depends on the statuses of the backup tasks that exist
on it:
 OK – All backup tasks are successful.

WARNING – There is at least one backup task that issued a warning during the backup, but
there are no errors.
 ERROR – At least one backup task has failed.
 UNKNOWN – No backup tasks have yet run on the machine.

MachineAddress – For a physical machine: the IP address of the physical machine. For a virtual
machine: the IP address of the physical machine where the agent that manages the virtual
machine is installed.
 OperatingSystem – The name of the operating system that the machine runs

LastConnection – The date and time of the last synchronization between the machine and the
management server
 LastBackup – The date and time when the latest successful backup finished on the machine
 Availability – The availability of the machine:

ONLINE – The latest connection to the machine by the management server was successful.
 OFFLINE – The latest connection to the machine by the management server failed.
 WITHDRAWN – The machine has been added to another management server or its
management type has been set to stand-alone management.

EXPIRED – The management server failed to connect to the machine because the machine
refused connection due to the expiration of a trial license.
 ManagedEntityType – The type of machine:

PHYSICAL MACHINE – The machine is a physical machine.
 VIRTUAL MACHINE – The machine is a virtual machine.