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.
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):
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.
