Report for Dedupe Rate Per Policy Type grouped by Media Server

[DPeaco]

Greetings,

We are still migrating reports off of OpsCenter over to NBUITA. I would like to know how to put together a report that gives me the Dedupe rate for a given timeframe by backup policy type and by Media Server.

Something like:
Past 30 days:
MediaServer-1 - Average dedupe rate - 88.32 %
MediaServer-2 - Average dedupe rate - 68.99 %

and etc.

[DPeaco]

Something like this:

Deduplication Rates by Policy Type - MediaServer-1

[Robert_Geller]

There are 3 reports in the Report Library that have dedup data.  An option can be to modified one of them to be policy based..

[meuhassan]

Here are the steps on how to put together a report that gives you the Dedupe rate for a given timeframe by backup policy type and by Media Server in NBUITA:

1. Log in to NBUITA.
2. Click on the "Reports" tab.
3. Click on the "Create Report" button.
4. In the "Report Type" field, select "Deduplication Report".
5. In the "Timeframe" section, select the timeframe for which you want to generate the report.
6. In the "Backup Policy Type" section, select the backup policy type that you want to include in the report.
7. In the "Media Server" section, select the Media Server that you want to include in the report.
8. Click on the "Generate Report" button.

The report will be generated and displayed in the "Reports" tab. The report will show the Dedupe rate for each backup policy type and for each Media Server for the specified timeframe.

Here is an example of a Dedupe report in NBUITA:

Backup Policy Type | Media Server | Dedupe Rate
------------------|------------|---------
Full | Server1 | 90%
Incremental | Server1 | 80%
Full | Server2 | 70%
Incremental | Server2 | 60%

As you can see, the report shows the Dedupe rate for each backup policy type and for each Media Server. The Dedupe rate is a percentage that indicates how much data was deduplicated during the backup process. For example, a Dedupe rate of 90% means that 90% of the data was deduplicated during the backup process.

I hope this helps! Let me know if you have any other questions.

[DPeaco]

@meuhassan 

I'm not using OpsCenter. I'm using NetBackup IT Analytics version 11.2x

There is no "Create Report" button and there is no "Report Type". 

It appears that your instructions are directly tied to OpsCenter IT Analytics and not the newer "Veritas NetBackup IT Analytics". Mine looks like this:

[DPeaco]

@Robert_Geller 

I pulled and imported those reports. I get zero output when I run one of those reports. The error I get when I examine the report query: The query failed to evaluate.ORA-00942: table or view does not exist

My guess is that there isn't a view / table name j.master_host_name or j.client_host_name - and etc.

[Robert_Geller]

which report is giving the error ORA-00942: table or view does not exist

[meuhassan]

Thanks, 

Try the following steps on how to create a report that gives you the dedupe rate for a given timeframe by backup policy type and by media server in NetBackup IT Analytics version 11.2x:

1. Open the NetBackup IT Analytics console.
2. Click on the "Reports" tab.
3. Click on the "Create New Report" button.
4. In the "Report Name" field, enter a name for the report.
5. In the "Report Type" field, select "Custom Report".
6. Click on the "Next" button.
7. In the "Select Data Sources" section, select the following data sources:
   • "Backup Policy"
   • "Media Server"
   • "Dedupe Rate"
8. Click on the "Next" button.
9. In the "Select Dimensions" section, select the following dimensions:
   • "Backup Policy Type"
   • "Media Server"
10. Click on the "Next" button.
11. In the "Select Aggregations" section, select the following aggregations:
    • "Average Dedupe Rate"
12. Click on the "Next" button.
13. In the "Select Filters" section, you can select filters to narrow down the results of the report.
14. Click on the "Next" button.
15. In the "Select Schedule" section, you can select a schedule for the report to run.
16. Click on the "Finish" button.

The report will be generated and saved. You can view the report by clicking on the "Reports" tab and then selecting the report from the list of reports.

Here are some additional things to keep in mind:

• You can use the "Advanced Filters" section to create more complex filters.
• You can use the "Sort" section to sort the results of the report.
• You can export the results of the report to a file.

I hope this helps! Let me know if you have any other questions.

[DPeaco]

@Robert_Geller 

It is the NBU Client DeDupe Report MS

[DPeaco]

@meuhassan 

Thank you for your instructions but those are directly related to:

OPSCENTER IT Analytics
That looks like this:

And what I'm referring to is Veritas NetBackup IT Analytics
That looks like this:

They are "worlds" different and OpsCenter will exist no more after an upgrade to 10.1x of NetBackup.

[DPeaco]

@Robert_Geller 
Here is the SQL Query from that report:
--Author: rich.rose@aptare.com
--Last updated: 04/04/2018
WITH
VAR AS (
SELECT
ROUND((${endDate} - ${startDate}),2) nbrOfDays,
${startDate} startDate,
DECODE('${freeCombo1}',
'KB',1,'MB',1024,'GB',(1024*1024),'TB',(1024*1024*1024),'PB',(1024*1024*1024*1024)) div_by
FROM dual
)
SELECT
j.master_host_name,
j.client_host_name,
(100-SUM(dj.cr_sent)/SUM(DECODE(dj.scanned_kb,0,NULL,dj.scanned_kb))*100) dedupe_savings_pct,
COUNT(j.job_id) job_count,
SUM(dj.scanned_kb/div_by) scanned,
SUM(dj.cr_sent/div_by) cr_sent,
SUM(dj.cr_sent)/SUM(DECODE(dj.scanned_kb,0,NULL,dj.scanned_kb)) pct_sent,
SUM(dj.cr_sent)/SUM(DECODE(dj.scanned_kb,0,NULL,dj.scanned_kb))*100 sent_pct,
SUM(dj.hdr_tir_scanned_kb/div_by) tir_scanned,
SUM(dj.hdr_tir_cr_sent_kb/div_by) tir_cr_sent,
SUM(dj.hdr_tir_cr_sent_kb)/SUM(DECODE(dj.hdr_tir_scanned_kb,0,NULL,dj.hdr_tir_scanned_kb)) tir_pct_sent,
SUM(dj.hdr_tir_cr_sent_kb)/SUM(DECODE(dj.hdr_tir_scanned_kb,0,NULL,dj.hdr_tir_scanned_kb))*100 tir_sent_pct
FROM apt_v_nbu_dedup_job dj, apt_v_nbu_job_detail j,var
WHERE j.job_id = dj.job_id
AND j.server_id IN (${hosts})
AND j.start_date BETWEEN ${startDate} AND ${endDate}
AND j.summary_status < 2
AND dj.scanned_kb > 0
AND j.server_id <> j.client_id
GROUP BY
j.master_host_name,
j.client_host_name
ORDER BY 3 ASC

[Robert_Geller]

change FROM dual to FROM apt_v_dual  - this is a known issue and impacted reports imported will be fixed after upgrade, or can be changed manually... 

[DPeaco]

Ok, that fixed that report. And that was the issue with 4 other reports I tried using from the reports library.

Thank you Robert!!!!