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

Hi Teemu ,

Yes there is a ReadCSV data source (under External category) which you could use to merge in to use as a filter. For example the csv file used could contain a field called "Save Set" which held the names of the save sets you wanted to include in the report output. You can then use the Add field operator to add a field called "Include" with a value of "Yes". You could then merge this with the Backup Save Set Details data source (Backup Save Set Details on the left, and ReadCSV on the right of the merge) and apply a condition of "Include is equal to Yes". This should then only return rows from the Backup Save Set Details data source where the save set name matches the name in your CSV file.

Kind Regards

David

EMC Technical Support