1 of 1 people found this helpful
I think this may be what you are looking for. ( but since I am not so smart please verify)
You may need to modify the format to match exactly what you are seeking but hopefully this is a start.
Screen shot of output:
Thanks that was actually very close to what I was looking for. I stripped the query from your report and revised to suit my needs. Thanks.
Would you mind posting the query you ended up using? I would like to see if it may add value here. Thanks in advance
Sure it's basically the same report but I altered slightly to give it to me by Node and then the applications. Both the Node and Application are live urls that will go into the appropriate areas.
What I would really like is to add one more level to this but I haven't figured that part out yet. I would like to show a tree like format of the following.
Applications on the node
Components that make up the application.
This query gives me the first two levels of that.
I know there is some APM content that will do that but I want the actual query. I do most of my reporting adhoc directly from SQL so I can quickly change to say all nodes with SQL in the caption or something to that effect.