Highlighted
tdupouy
1 Copper

DPA advanced query for Avamar domains

Hello,

I'd like to create and advanced query in DPA 5.5 to list the Avamar clients by domain but can't figure how to do that.

I've created a report that show avamar clients grouped by domain:

Avamar domains
Domain Name Client
/FR-city1/XXXXX/Development/Virtualhost1, host2, host3, etc.
/FR-city2/BlackBox/Productionhost4, host5, host6, etc.
/clientshost7, host8, host9, etc.
/FR-city1/XXXXX/Production/Virtualhost10
/FR-city1/XXXXX/Production/Physicalhost11
Generated by DPA 5.5 on 20/11/09 at 15:59.

Then I created an Advanced query to obtain a hierarchical view of hosts grouped by domains (c.f.enclosed). I tried with different parameters  but it never worked.

If someone already did do that, thanks in advance for his help

Best regards,

0 Kudos
1 Reply
PBe1
1 Copper

Re: DPA advanced query for Avamar domains

I tried doing something similar, but I used two reports, one for each level of the hierarchy. In the first report, I added a field "Type" with text value "Group", which I selected as Type Field in the query config; for the second level report, I added a field "Type" with text value "Host", which I selected as Type Field.

This way I ended up with the structure I wanted, however, I'm unable to run reports against the Group-level nodes...