Unsolved
This post is more than 5 years old
12 Posts
0
2334
How to have recurring informations in a report and realize an Advanced Query based on it ?
Hello All,
I will describe 3 problems that I encount with a report than I have to provide to different entities
1. I need to have a reccurent information in a report (backup client)
I have an CSV files with a list of applications with their servers. the servers can be used with more than one application
APP1 -> Serv1, Serv2, Serv3
APP2 -> Serv4, Serv5, Serv2
APP3 -> Serv3, Serv5, Serv6
I create a report who merge the information with the
all the backup client are found but the report doesn't display the reccurent backup client
APP1 -> Serv1, Serv2, Serv3
APP2 -> Serv4, Serv5
APP3 -> Serv6
My report is not what I want but It can be used to create an Advanced Query... I guess
2. How to realize the advanced Query ???
I heard about it but never saw it during a demo
I am very confuse about what it will produce and how to fill Name, Sub Name and Type fields...
I expect something like
Advanced Query
-- APP1
-------Serv1
-------Serv2
-------Serv13
--APP2
-------Serv4
-------Serv5
--APP3
-------Serv6
3. In fine, how to create a scheduled report for every APPx ???
I need to provide the report to each owner of each APP
I would automate this to directly take charge of new APPs that can be added in the CSV file
and because it cannot be done manually, I have not 3 APPs but more than 150
thank you in advance to read my post and help me to have something to realize these reports
Vincenzo.
DavidRussell1
141 Posts
0
March 1st, 2011 04:00
Hi Vincenzo,
1. Is the format of your csv file fixed or are you able to change it to a format like the below?
Serv1, APP1
Serv2, APP1
Serv3, APP1
Serv4, APP2
Serv5, APP2
Serv2, APP2
Serv3, APP3
Serv5, APP3
Serv6, APP3
If you can change it to the above then your report can use this data source on the left (with 2 fields of Client and App) and merge in the Backup Client Configuration on the right using the Client fields as the key fields in each source. This should then give you the mapping and output you require.
2. I don't believe you would be able to use an advanced query node here and instead would have to create a standard query for each application that used the report mentioned in point 1. You would then have a filter on the query node to only return the clients for those applications.
3. As far as I am aware it is not possible to automatically create a schedueld report for each application and you would need to create a scheduled report for each standard query application node.
Kind Regards
David
David Russell
DPA Subject Matter Expert
EMC Technical Support
David_Hampson_90e289
243 Posts
0
March 1st, 2011 06:00
I'm a little confused as to what you are trying to get out here. From the information you have given you have a CSV file that maps (150) applications to the servers on which they are installed on. You import this into DPA, merge this with the Backup Client Configuration datasource; however it is unclear where we go from here to arrive at the data you want as the example of the report you give is the same data but in slightly different form. Can you explain what it is you wish to show here?
Arnonev
12 Posts
0
March 7th, 2011 00:00
Hello and sorry to be late with my answer
my goal is to create a view where I wish to see the name of the application as "folder" and the list of servers linked to it as backup clients and as a server is not exclusive to an application, it has to appear under multiple folders.
At the end, I will be able to send a report concerning an application and all the linked servers
Actually, it is not the case because with my actual report, it reports only 1 time the backup client and not each time under the linked application.
And in my dreams, I wish that view is automatically generated
DavidRussell1
141 Posts
0
March 7th, 2011 00:00
Hi Vincenzo,
You should be able to achieve the structure you want by using a csv file in the format I suggested with the ReadCSV data source on the left hand side of the merge.
Thanks
David
DavidRussell1
141 Posts
1
March 7th, 2011 02:00
Hi Vincenzo,
I would recommend taking a look at the DPA API Reference guide which can be downloaded from Powerlink. This contains details on how you can use the Controller API to create views, nodes, etc.
Kind Regards
David
Arnonev
12 Posts
0
March 7th, 2011 02:00
Thank you David but I resolved the problem due to a goup by not well located and an index missing
now I can see the same backup client under multiple applications
So any way to create automatically that view ?
Can something be directly inserted in the DPA DB ?
with an API or SQL commands ?
Arnonev
12 Posts
0
March 7th, 2011 22:00
Hello,
I used the API and it is really usefull. Thank you David.
but I don't know if I have to open another discussion (or ticket to emc) or continue here because I encountered a problem with the createnode
I will create a node type Query-Single with a condition as attribute on a report, the node is well created and all the attributes are well registered except the condition.
I take for model an existing node:
Aleri Be
Test_API_node Aleri Be
Query-Single
[...]
3
991
5
SrvInst_Name Aleri Be
-1
DavidRussell1
141 Posts
0
March 8th, 2011 01:00
Hi Vincenzo,
Yes at this point I would recommend opening a support ticket via Powerlink so that one of the support team can assist you in troubleshooting why the CREATENODE xml isn't setting the condition.
Kind Regards
David
Arnonev
12 Posts
0
March 8th, 2011 03:00
OK, I will do that
Thank you for your help and time.
Regards,
Vincenzo.