Acronis backup recovery 10 management server reports Guía De Instalación
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:
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:
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.
machine runs.
Status – The status of the machine, which depends on the statuses of the backup tasks that exist
on it:
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.
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.
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
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.
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.
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.