1) Save the ClientName.csv file with the name of the clients in a location which can be accessed from any PC. Often customers will use the reports sub-directory on the DPA server (e.g. \webapps\root\reports) as this is accessible via the built in DPA web-server.
2) This file has only one column with the name of 3 clients (just for the test).
3) Created the report using the default Backup Client Config Report as source.
4) Added the External/ReadCSVFile source to the report
DavidRussell1
141 Posts
0
September 5th, 2011 01:00
Hi,
The way you would want to do this would be:
1) Save the ClientName.csv file with the name of the clients in a location which can be accessed from any PC. Often customers will use the reports sub-directory on the DPA server (e.g. \webapps\root\reports) as this is accessible via the built in DPA web-server.
2) This file has only one column with the name of 3 clients (just for the test).
3) Created the report using the default Backup Client Config Report as source.
4) Added the External/ReadCSVFile source to the report
5) Set the READCSVFile source as follow:
Cast String: Text
Field String: Client
Filename: C:\Program Files\EMC\DPA\webapps\root\reports\ClientName.csv
Key String: True
Separator: ,
Please note I have changed the Field String name so that it matches the name of the client field in the Backup Client Config data source.
6) Add a Join operator to join both sources and only return those clients which are in the csv file.
Thanks
David
David Russell
EMC Technical Support
Enr2010
25 Posts
0
September 6th, 2011 08:00
Hi David:
I just got back to work this morning and tried creating the report following your instructions and it did work perfectly.
Thank you very much.