Create view from CSV file

Question

Hi, I have a CSV file that consists of a single column.  The column is a list of NetWorker Clients.  These NetWorker Clients may exist in one of many different data zones.  I would like to create a Standard Query that populates a View with just these Clients.  Looking at other examples here, I attempted to use the ReadCSVFile  source and the Backup Client Config source to generate my Client list.  But, I am having difficulties getting this to work properly. Is this the best way to generate a View of NetWorker Clients based on an input file when the Clients are spread across many different NetWorker Data Zones?

DavidRussell1 · Accepted Answer

Hi Aaron,

Yes you could use this approach.

I would recommend using the Backup Client Configuration data source and feeding it into the left hand side of a Merge. On the right hand side use the ReadCSV data source and feed this into an AddField operator. In this operator add a Flag field called Include with a value of True. The feed this into the right hand side of the Merge operator and add a condition of Include equal to True.As the output type for the query node you can specify Backup Client and choose Server as the Server field and Client as the Client field.

HTH

David

David Russell

EMC Technical Support

Data Protection Advisor

Was this post helpful?