Column "Noted" appears on custom-report

Hi,

I'm trying to get all save set's listed and grouped by save set name in start time order within time window (one month). I have some 70 different save set's that I need to have listed in this report and my plan was to parse those out with condition-definition in merge-operator. This will generate some 5000- 7000 rows but our customer want's this so I have no options.

Can I use csv-file(or something else method) to import those save set's to report condition?

Teemu

Good Day,

The Note column appears when you have more that one row with the same set of key fields. The key fields are the fields displayed in Bold, and the Noted column is added to help uniquely identify the rows from one another. It does not exist as a field in the database and cannot be selected/deselected as part of Table Data.

Could you tell me what data you are trying to obtain from Backup Statistics that is not available from backup Save Set details?

Kind Regards

David

EMC Technical Support

Hello,

Thanks for reply. I need total duration of save set's from statistics, I

haven't found it form any other source. Last week we had an 2 days

course here in Finland (Elvin Kan was the instructor but I forgot to ask

him ).

Br,

Teemu Vinnikka

Hi Teemu,

Are you trying to break down the output via an interval (e.g. Daily) or are you looking for the total per Save Set over the time window?

Thanks

David

EMC Technical Support

Hi Teemu,

In that case you can just use my instructions but without the Rollup operator. That will generate the Duration for you (end time - start time of save set) and can be included in the output.

Kind Regards

David

EMC Technical Support

Hi,

I propably made my point somehow wrong. I need all save set's listed, not rollupped to one line. So I have to group by save set and order those lines by start time. So I will have 20-200 lines per one save set when running report for one month.

Here is example:

And I have some 70 different save set's to include in this report (total rows will be somewhere around 7000). I know, there is no sense but it's our customer's will that rules. Duration must be real duration that that current backup really did take and this is that info why I need Backup Statistics -source (and get that Noted column).

Excellent, now I get proper report!. One question still, is there any way to fetch save set-names which should be included to report, into condition? Now I can add those to save set details-source but this is so time consuming and hard to keep updated. If there is a way to fetch data (like from CSV-file), this would help a lot!

Br,

Teemu

Here is my dataflow. For some reason, this won't produce wanted results. Where I could start searching problems? What should be selected in Add Field-operators "Cast"?

Br,

Teemu

Hello again,

When looking reporte-log, it says following:

reporter - com.sysdm.wysdm.reporter.source.ReadCSVFile(): [pool-1-thread-3]Line has different number of values to number of fields - ignoring

What are these pool 1 and thread 3?

Teemu

Hi Teemu,

The message indicates that you have configured a ReadCSV data source with less fields than the actual csv file has. If any of the rows in your csv file has more fields than you defined in the ReadCSV data source, then you will need to either remove those extra fields, or add them into the Read CSV data source.

Thanks

David

EMC Technical Support

Quick update to this issue, I found another way to fetch needed client-data (thanks to our NetWorker-guys). There is always customers name in comment-field so with this same procedure, I could fetch that data and with same workflow now I can have needed host's included to report.

Edit: I celebrated too soon, now reports are using lots of time and memory to beeing produced. Here is my workflow:

In Backup server mapping, there is condition to include only when certain string of text is found on comment. Only neccesary fields are returned (bolded ones).

Add field-operator adds field "Include", value Yes. In this point only client name and Include-filed are returned, anything else is dropped.

Backup server details: all returned

Rollup: Save set's are rollupped by client

Merge: Condition "include equals yes" so anything else is dropped.

What am I doing wrong? This shouldn't take 15 minutes to run and use 10gigs of memory and if I run it against of all our NetWorker-servers, it will crash. And also this Noted-field appeared again on report and there is 3 times all of the rows needed, only noted-filed changes.

This issue would be better resolved by contacting EMC support where they can gather logs and configuration information to investigate. Note as well EMC provides Professional Services for creating custom reports that you wish to take advantage of.

Excellent tip, didn't realize that possibility. Now after quick troubleshooting everything is running smoothly, I had to use "Add field" -operator and use it to parse certain save set's to report and after that do rollup and order. Thank you all who participated on this!