In WILY version 9.5.3, I would like to create a report with all of the hostname of application servers that are instrumented WILY. How can I do that ?
Thank you for checking.
So you just want a report that lists unique hostnames hosting one or more agents and you are not interested in agent names or any agent metrics?
I believe the below may be what you are looking for.
1. Create a metric group based on the Metric Expression "EM Host". I named my metric group "EM Host". Set the Metric Group Agent Expression to "(.*)\|(.*)\|(.*)"
2. Add a "Metric Data Table" element to the report.
3. Under "Data Properties", select "EM Host" as the metric group
4. Under "Display Properties", set "Table Columns" to "Text Value". What this will do is take away the default count, min value, max value away from the report as they are not applicable to a String element. This will only show the host names.
Apply the changes and preview the report. Let us know if this works for you.
musma03 - is there a way to remove the repetitive/duplicate host names? B/c you could have multiple agents per host name.
Thanks in advance.
I am marking this as answered since Matt provided a possible solution and no additional questions were asked . You of course may follow up with your progress after following the solution
Thanks Hal German