09-25-2013 01:12 PM
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