09-23-2016 11:03 AM
I am currently working on a report to show Client Images when they were backed up, when they expire, the name of the image, and the SLP Job they were part of, . So far I have te following shown below...
SELECT DISTINCT domain_image.id AS "Image ID" ,utcbiginttonomtime(writeendtime) AS "Backup EndTime" ,utcbiginttonomtime(expirationTime) AS "Expires" ,DATEDIFF(dd, utcbiginttonomtime(writeendtime), utcbiginttonomtime(expirationTime)) AS "Days of Retention" ,clientname AS "Client" ,policyname AS "Policy" ,scheduleLabel AS "Schedule Name" ,ssName AS "SLP" FROM domain_masterserver INNER JOIN domain_image ON domain_image.masterserverid = domain_masterserver.id INNER JOIN domain_jobimage ON domain_jobimage.imageid = domain_image.id WHERE unexpiredcopycount > 0 AND NOT Policy like '%Cat%' AND SLP like '%SUN%' ORDER BY "Expires" ASC
This produces the results as shown in the below exmaple.
Image ID
Backup EndTime
Expires
Days of Retention
Client
Policy
Schedule Name
SLP
Now the next part I am having problems fidning, as I want to show the diskpool each image sits on. The end goal is to show all the above fields plus the diskpool to show where offsite copies sit with in our enviroment along with there repected image names and retention.
Any help is welcom...