Operations Center Analytics
Does anyone have a report that shows Backup Image Retention Summary by Client report ?
What we need is a list of backup images with their retention (backup date and expiration date), showing the cl...
Forum Discussion
This query will only show incs for 30 days and fulls for 90. To get the other column added it will take me a while to figure out the logic but I will work on it:
Client Search
SELECT ms.networkName AS 'Master Server'
, di.id AS 'Image'
, utcBigIntToNomTime(di.writeStartTime) AS 'Backup Date'
, utcBigIntToNomTime(di.expirationTime) AS 'Expiration Date'
, utcBigIntToNomTime(di.deletionTime) AS 'Deletion Date'
FROM domain_Image di
INNER JOIN domain_MasterServer ms
ON di.masterServerId = ms.id
WHERE ((di.filesFileName LIKE '%INCR%' AND utcBigIntToNomTime(di.expirationTime) > GETDATE()+30)
OR (di.filesFileName LIKE '%FULL%' AND utcBigIntToNomTime(di.expirationTime) > GETDATE()+90))
AND di.id LIKE '%[ClientName]%'
Master Search
SELECT ms.networkName AS 'Master Server'
, di.id AS 'Image'
, utcBigIntToNomTime(di.writeStartTime) AS 'Backup Date'
, utcBigIntToNomTime(di.expirationTime) AS 'Expiration Date'
, utcBigIntToNomTime(di.deletionTime) AS 'Deletion Date'
FROM domain_Image di
INNER JOIN domain_MasterServer ms
ON di.masterServerId = ms.id
WHERE ((di.filesFileName LIKE '%INCR%' AND utcBigIntToNomTime(di.expirationTime) > GETDATE()+30)
OR (di.filesFileName LIKE '%FULL%' AND utcBigIntToNomTime(di.expirationTime) > GETDATE()+90))
AND ms.networkName = '[MasterServerName]'
