Acronis backup recovery 10 management server reports 安装指南
Copyright © Acronis, Inc., 2000-2009
7
Note that the function GETUTCDATE is used here instead of GETDATE, because all times in the
databases are in the UTC format.
databases are in the UTC format.
The following query returns the name and the time of the last successful backup for all physical
and virtual machines; the times are shown in the local time zone (that of the SQL server):
and virtual machines; the times are shown in the local time zone (that of the SQL server):
SELECT
Name,
ManagedEntityType,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()), LastBackup)
AS [Last Successful Backup]
FROM Machines
WHERE
ManagedEntityType = 'PHYSICAL MACHINE' OR
ManagedEntityType = 'VIRTUAL MACHINE'
The following illustration shows the result as seen in Microsoft SQL Server Management Studio
Express.
Express.