Amount of data (active data, <45 days) for a customer

select
domain_JobArchive.clientName as 'Client',
COALESCE(CAST(SUM(domain_JobArchive.preSISSize)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Protected Size (GB)'
FROM domain_JobArchive
WHERE DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 45
GROUP BY "Client"

select
domain_JobArchive.clientName as 'Client',
COALESCE(CAST(SUM(domain_JobArchive.preSISSize)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Protected Size (GB)'
FROM domain_JobArchive
WHERE DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) > 45
GROUP BY "Client"

So the 1st  query should represent all data from a given date, which have retention less then 45 days?

PLease note thte client for su represent the Policy name.

And the 2nd is a query representing all unexpired data but with more then 45 days retention?

Thnak you.

George

Correct,

<= 45 is less than 45 days

> 45 is greater (older) than 45 days

You can replace

domain_JobArchive.clientName as 'Client',

with

domain_JobArchive.policyName as 'Policy",

Thank you Rian,

One question, for the fist query, what do I have to add in order to say the start date.

1st report is base on a certain start date, let`s say 1st of last month.(management thinking...<45 days retention time, but within last month)

//George

All reports are based on today, so up to 45 days from today, and 45 days and more from today.

One more question:

What does Protected Data Size actualy means: it reports un-deduplicated data regardless of its expiration from a particular time frame?

And what does active data, shoud report only protected data size and unexpired from a particular time frame, is it correct?

How do you think I can reveale active data in opscenter?

//George

Hi,

Protected is my own term, basically OpsCenter (and NetBackup) records to sets of figures in the job archive, BytesWritten and PreSisSize. It does this because of deduplication. Pre(SingleInstanceStorage)Size is the amount that reflects the REAL amount of Data as it is on your client. BytesWritten is the amount that is stored once deduplication has taken place.

What do you mean with Active Data?
 

Hi,

I saw Protected Size in OpsCenter too.

Active Data is data that has less then 45 days of retention and its not expired within a period of time.

Lets say I want to know how much data a customer has, and I take time-frame of last month.

But this clients has retention of 1month, 2months and 3months, that means some of the data with > 45 days is archive data, based on our company calculations.

So for this client all data within that month, but with retention less then 45 days, is Active Data, of course we exclude expired data within that month.

Is this possible?

//George

Hi,

Sorry but I still don't understand the distinction you're making between active (<45) and archive (>45). I understand its logical way your company (which I presume is a service provider) looks at it, but how does it relate to the netbackup storage? Is the data kept on disk for active and tape for archive or something like that?

HI,

Well the data that have less then 45 days retention (and it`s not expired) is called Active Data

And the data that has more then 45 days retention (and it`s not expired) is called Archive Data.

Do I have an operator in the report who can tell OPSCenter to show me only the unexpired data whithin this retention periods??

I am affraind if I choose a no time basis report based on retention level it will show me all backups that had this retention (>45 days or <45 days) regardeless if it`s expired or not. SO in this way i wil have a huuuuuge report, maybe a stuck report which I usualy have.

//George