cancel
Showing results for 
Search instead for 
Did you mean: 

SLP images reporting using OPScenter

PDragon
Level 4

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

0 REPLIES 0