Acronis backup recovery 10 management server reports Guida All'Installazione
6
Copyright © Acronis, Inc., 2000-2009
4 Relationship diagram
The following diagram shows the relationship between the report views. Only the columns that
uniquely identify the entry and establish the relationships are shown here.
uniquely identify the entry and establish the relationships are shown here.
5 Current state reports
5.1 Machines
5.1.1 Description
The Machines view represents all physical and virtual machines. You can differentiate between the
types of machines by using the ManagedEntityType column.
types of machines by using the ManagedEntityType column.
5.1.2 Query samples
The following query returns all “critical” physical and virtual machines—the ones with a last
backup time or last connection time of more than five days, and the ones that have never been
backed up:
backup time or last connection time of more than five days, and the ones that have never been
backed up:
SELECT * FROM Machines WHERE
(DATEDIFF(d, LastConnection, GETUTCDATE()) > 5 OR
DATEDIFF(d, LastBackup, GETUTCDATE()) > 5 OR
LastBackup IS NULL) AND
((ManagedEntityType = 'PHYSICAL MACHINE') OR
(ManagedEntityType = 'VIRTUAL MACHINE'))