cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

Catalog Size Report needs last successful catalog backup time added

lisareinhart
Level 4

Can someone please help add this field into this report for me?

select M.friendlyName as "Master Server", cast(J.bytesWritten / 1073741824 as decimal(10,2)) as "Catalog Size (GB)"
from domain_jobarchive J, domain_MasterServer M,
(select masterServerId, max(startTime)as "startTime"from domain_JobArchive
where policyType = 35
group by masterServerId ) T
where J.startTime = T.startTime
and J.masterServerId = T.masterServerId
and J.policyType = 35
and J.masterServerId = M.id

 

0 REPLIES 0