Unsolved
This post is more than 5 years old
14 Posts
0
1035
January 24th, 2013 05:00
Using CSV file as a source for a canned report
Due to political decisions at a much higher pay grade than me, I'm having to use CSV files as a source for a lot of my reports that I once had running natively against my NetApp filers (vaulting/backup and replication). I know how to use the "Read CSV File" source to build a report for items that don't have canned reports already built, however I want to add the CSV file as a source for reports that are already built, such as "Remote Mirror Status."
In the Report Editor, the "Remote Mirror Status" item is a source. Is there any way that I can turn it in to a downstream object that I can feed the CSV file to?
Thanks in advance,
--Blake Roberts
No Events found!
DavidRussell1
141 Posts
1
January 24th, 2013 07:00
Hi Blake,
No it isn't possible to feed a data source into a csv data source or another data source. It is possible to merge 2 data sets, however you would need to have common keys between the 2 sources that you wish to merge on.
Are you able to provide me with details of what the csv file will contain and what you are trying to achieve, and I will let you know if it is possible to do in DPA?
Thanks
David
David Russell
EMC
Blake_Roberts
14 Posts
0
January 24th, 2013 08:00
The headers on the report are the following:
"Relationship ID","Source Name","Destination Name","Timestamp","Bytes Transferred","Transfer Rate /sec","Transfers","Transfer Failures","Data Growth"
I was going to try to merge it into the "Remote Mirror Status" report to make it look similar to the one that would normally run if the service account was on the NetApp.
Thanks for the help!
--Blake
DavidRussell1
141 Posts
0
January 24th, 2013 08:00
Hi Blake,
Would the Remote Mirror Status report return any data when run on the NetApp if it is no longer being monitored?
Assuming it does, then if you made sure the field names of the matching keys matched (i.e. in the csv they are called Source Name and in the Remote Mirror Status data source it is called Source Node and Source Path) in both sources, then the merge operator should merge the 2 data sets into 1 based on the matching keys.
HTH
David
David Russell
EMC