cancel
Showing results for 
Search instead for 
Did you mean: 

Sizing Report

I have been working on a sizing report for a DeDup disk appliance purchase. I have created a report that I thought might help someone else out. This is a report to see the size of all full backups in the last week. It also lists the policy type's:

 

SELECT dj.clientName AS 'Client', dj.policyName AS 'Policy', dj.bytesWritten AS 'Size', utcBigIntToNomTime(dj.startTime) AS 'Start Time', pt.name AS 'Policy Type'
FROM domain_job dj
INNER JOIN lookup_BackupType bt
ON dj.backupType = bt.id
INNER JOIN lookup_ScheduleType st
ON dj.scheduleType = st.id
INNER JOIN lookup_PolicyType pt
ON dj.policyType = pt.id
WHERE bt.name = 'Scheduled' AND st.name = 'Full' AND dj.statusCode = 0 AND dj.bytesWritten > 0 AND utcBigIntToNomTime(dj.startTime) > GETDATE() - 7
ORDER BY pt.name, dj.policyName, utcBigIntToNomTime(dj.startTime)
 
 
Hope this help's someone!
3 Replies

Thanks, Miles. I've been

Thanks, Miles. I've been searching for other custom reports and your posts have been very helpful!

 

Glad they helped!

Glad they helped!

Good job Miles... I know a

Good job Miles... I know a customer who is looking for something very similar to this!

 

--Tom