08-16-2010 02:50 AM
Solved! Go to Solution.
08-16-2010 06:13 AM
08-16-2010 02:55 AM
08-16-2010 04:13 AM
08-16-2010 04:34 AM
USE VSDB
SELECT
'Archived Date' = LEFT (convert (VARCHAR, ArchivedDate,20),13),
'VSNAME VS01 - Hourly Rate' = count (*),
'Size in MB' = SUM (ItemSize)/1024 FROM Saveset
WHERE
ArchivedDate > dateadd("hh", -24, getdate ())
GROUP BY
left (convert (VARCHAR, archivedDate,20),13)
ORDER BY
'Archived Date' DESC
Or
USE VSDB
SELECT COUNT (*)
AS 'VSNAME VS01'
FROM
Saveset
WHERE
ArchivedDate > dateadd("hh", -168, getdate ())
08-16-2010 05:41 AM
08-16-2010 06:13 AM