Aris56
9 years agoLevel 4
Opscenter : report on data growth on backup with accelarator option enabled.
Hi,
i have this file server(terabytes of data) backed up with accelerator turned on.
i want to calculate the data growth, but not possible to get the exact size of data backed up sinc...
- 9 years ago
You can run a sql query, the result will just be a table, not a graph. You can try
select
COALESCE(CAST(SUM(domain_JobArchive.bytesWritten)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Written (GB)',COALESCE(CAST(SUM(domain_JobArchive.PreSISSize)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Protected (GB)',
domain_JobArchive.ClientName as "Client",
DATEFORMAT(cast(UTCBigintToNOMTime(domain_JobArchive.endTime) as DATETIME), 'yyyy-mm-dd') as "Date"
FROM domain_JobArchive
WHERE
DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 30
AND
domain_JobArchive.type in (0)
AND
domain_JobArchive.clientname like '%CASE SENSITIVE CLIENT NAME%'
group by "Client", "Date" order by "Date"