ehaupt1
1 Nickel

DPA Report Card view of NetApp Filer volumes?

Jump to solution

Hi. I am looking for any suggestions or feedback for configuring a "Report Card" view of NetWorker backups of NetApp Filer volumes.

At one of my data centers I have six NetApp filers, each with about 30 to 60 volumes. We use NetWorker 7.61 with direct ndmp to backup these volumes over the SAN to LTO4 drives. The NetApp volumes are between 300 Gb and 2 TB in size. In NetWorker I have the six filers as Clients, with each volume being it's own Client. My Groups are set-up to contain 1 or 2 volumes each.

We really like the "Report Card" in Data Protection with the "One Week" window to get a nice gree\red overview of our server\client based backups.

When I run this kind of Report Card for my six NetApp filers I only get six rows, one for each 'Backup Client'

What I want is a Report Card that has a row for each NetApp volume. I need to get the SaveSet value of the volume to be treated like the Node volume of the Client.

Output something like:

Node                                                                         2 Mar       3 Mar     4 Mar      5 Mar

netapp_filer_01:/vol/us_accounting                       Green      Green     Red        Green

netapp_filer_01:/vol/us_hr                                      Green         Red      Green

netapp_filer_02:/vol/us_email_server01

netapp_filer_03:/vol/us_file_server02

Any ideas or suggestions are welcome.

Thanks in advance for your help!

- Eric

0 Kudos
1 Solution

Accepted Solutions
ElvinKan
2 Iron

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

yes, this can easily be done but will require a custom report.   Firstly, if you want to group by Saveset, you will need to provide the saveset field to the report, so copy and mofify the Report Card report and on the Properties of the "Num Save Sets" (or "Nuim Jobs" depending on what terminology you are using), on the Group By tab, tick/check the "saveset" field as well ie. group by client, status and saveset.

Then in the Report Appearance Toolbar , use the Field Mapping icon (the yellow cylinder) to multi-select BOTH the client and the saveset field and that should do the trick.

If you want to use the drill-downs as well, you will also need to create custom versions of the Backup Save Set Summary and those it calls - and the change would be to pass the saveset name through to each drill down report too.

I have tested this in our demo environment 

rc2.jpgrc1.jpg

0 Kudos
7 Replies
JPinTokyo
1 Nickel

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

Hi Eric - I recently created something similar.  This is a report card that uses "Backup Jobs" instead of clients as the node.  Take a look at the sample below.

Screen shot 2011-03-04 at 10.53.09 AM.png

You should be able to modify it for groups as you mentioned pretty easily.  I will paste the XML below:

Thanks

JP

978Backup Filer Volumes-TEST-falsefalse1<XML><REPORTTYPE>com.sysdm.wysdm.guireport.renderers.tablebased.reportcard.ReportCardRenderer</REPORTTYPE><CONTENT><REPORTITEM><ITEMDEF><NAME>Backup Filer Volumes</NAME><DESCRIPTION></DESCRIPTION><TREE><REPORTITEMSOURCE><DATASOURCE>Num Jobs</DATASOURCE><LABEL>Num Jobs</LABEL><TIMECONSTRAINTS>true</TIMECONSTRAINTS><TIMETYPE>0</TIMETYPE><STARTTIMETYPE>1</STARTTIMETYPE><ENDTIMETYPE>2</ENDTIMETYPE><INTERVALTYPE>2</INTERVALTYPE><INTERVALVALUE>-1</INTERVALVALUE><NODETYPE>0</NODETYPE><OUTPUTFIELDS><FIELDDEF alwaysreturned='true' logical='true' display='true' cast='Int'><FIELDNAME>Num Jobs</FIELDNAME><LABEL>Num Jobs</LABEL><DISPLAYCAST>Int</DISPLAYCAST></FIELDDEF><FIELDDEF display='true' key='true' cast='String' condition='true'><FIELDNAME>job_name</FIELDNAME><LABEL>Job</LABEL><DISPLAYCAST>String</DISPLAYCAST></FIELDDEF><FIELDDEF display='true' key='true' cast='String' condition='true'><FIELDNAME>status</FIELDNAME><LABEL>Status</LABEL><DISPLAYCAST>String</DISPLAYCAST></FIELDDEF></OUTPUTFIELDS><AGGREGATEFIELDS><FIELDNAME>status</FIELDNAME><FIELDNAME>job_name</FIELDNAME></AGGREGATEFIELDS><SMOOTH>0</SMOOTH><SOURCE_REQUIRED>true</SOURCE_REQUIRED></REPORTITEMSOURCE></TREE></ITEMDEF><DISPLAYFIELD><DISPLAY>true</DISPLAY><FIELDNAME>Num Jobs</FIELDNAME><LABEL>Num Jobs</LABEL><DISPLAYCAST>Int</DISPLAYCAST></DISPLAYFIELD><DISPLAYFIELD><DISPLAY>true</DISPLAY><FIELDNAME>Job</FIELDNAME><LABEL>Job</LABEL><DISPLAYCAST>String</DISPLAYCAST></DISPLAYFIELD><DISPLAYFIELD><DISPLAY>true</DISPLAY><FIELDNAME>Status</FIELDNAME><LABEL>Status</LABEL><DISPLAYCAST>String</DISPLAYCAST></DISPLAYFIELD></REPORTITEM></CONTENT><RENDERERPARAMS><REPORTTITLE version='v4.1'><DISPLAY>true</DISPLAY><LABEL>@report-name@</LABEL></REPORTTITLE><REFRESHRATE><USE_USER_PREFS>true</USE_USER_PREFS></REFRESHRATE><STYLE><SERIESSTYLE><LABEL>failed</LABEL><COLOR>#FF0000</COLOR></SERIESSTYLE><SERIESSTYLE><LABEL>success</LABEL><COLOR>#00FF66</COLOR></SERIESSTYLE></STYLE><FIELDMAPPING><NODEFIELD>Job</NODEFIELD><STATUSFIELD>Status</STATUSFIELD><VALUEFIELD>Num Jobs</VALUEFIELD><ORDERFIELD>Job</ORDERFIELD><ORDERPOLICY>ascending</ORDERPOLICY><INTERVAL_COUNT>1</INTERVAL_COUNT><INTERVAL_UNIT>DAY</INTERVAL_UNIT></FIELDMAPPING><TABLESTYLE><BACKGROUND>User Selected</BACKGROUND><FOREGROUND>User Selected</FOREGROUND><HEADERBACKGROUND>User Selected</HEADERBACKGROUND><HEADERFOREGROUND>User Selected</HEADERFOREGROUND><REPEATCOLOR1>User Selected</REPEATCOLOR1><REPEATCOLOR2>User Selected</REPEATCOLOR2><SHOWGRID>User Selected</SHOWGRID><GRIDCOLOR>User Selected</GRIDCOLOR><DATEFORMAT></DATEFORMAT><COLUMNORDERING>latest_last</COLUMNORDERING></TABLESTYLE></RENDERERPARAMS></XML>

Highlighted

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

Eric

You need to change the properties of the report card to use the saveset name as the node name - hit the little triangle in the top left of the report then click on the gold volume icon and you get something like this:

field mapping.jpg

It may be what you are hoping to do is have server/client as the node; however I have found no way of combining two non-numeric fields together to make one.

ElvinKan
2 Iron

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

yes, this can easily be done but will require a custom report.   Firstly, if you want to group by Saveset, you will need to provide the saveset field to the report, so copy and mofify the Report Card report and on the Properties of the "Num Save Sets" (or "Nuim Jobs" depending on what terminology you are using), on the Group By tab, tick/check the "saveset" field as well ie. group by client, status and saveset.

Then in the Report Appearance Toolbar , use the Field Mapping icon (the yellow cylinder) to multi-select BOTH the client and the saveset field and that should do the trick.

If you want to use the drill-downs as well, you will also need to create custom versions of the Backup Save Set Summary and those it calls - and the change would be to pass the saveset name through to each drill down report too.

I have tested this in our demo environment 

rc2.jpgrc1.jpg

0 Kudos

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

Thanks for posting that Elvin, I spent hours trying to figure out how to get two fields to be the node without success.  Now if I can just remember the report I wanted to do that on...!

0 Kudos
ehaupt1
1 Nickel

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

ElvinKan,

     Perfect! I followed your suggestions and it worked perfectly. Thank you very much for sharing this knowledge with me. This feature takes our DPA reporting to a new level and gives my team a really nice tool to help manage our NetWorker backups of our storage. I just joined this ECN forum this week and it was really coolfour respo my question in the first day. I hope I can return the favor someday. Take care.

0 Kudos
ehaupt1
1 Nickel

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

JPinTokyo,

     Thanks for the feedback.

0 Kudos
ehaupt1
1 Nickel

Re: DPA Report Card view of NetApp Filer volumes?

Jump to solution

David,

     Thanks for the feedback and suggestion!

0 Kudos