Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Using Summary Top XX Filters and Macros

I have an application summary view, and a top XX component resource, and I want to filter that resource using the application ID.

In the Filter block, I have this (and a gazillion different variations of it):
Application.ID = ${ApplicationID}

I'm trying to use the application ID I'm browsing to filter the resource. I've done this with node reports, using the "NodeID = ${NodeID}" macro, but can't seem to get this to work, and can't find a good resource that explains how I should be constructing this filter.

Does anyone have any ideas on how I can solve this?

Find more posts tagged with

view filters

apm

Accepted answers

All comments

lag

For the record, the current filter displayed works, except I want to make the ID dynamic based on the application you are viewing.

mesverrum

So it sounds like you are trying to figure out which variable works in the ${} on the application entity view, have you tried = ${id} yet?

lag

Yes, I've tried that. Not to be snarky, but did you try it in your own environment?

lag

I've tried application.ID, application.ApplicationID, APM.Application.ApplicaitonID, APM.Applicaiton.ID, APM_Application.ID, and APM_Applicaiton.ApplicationID

mesverrum

I did not, im on leave from a surgery and haven't been "on the clock" so to speak in a bit and my VPN is spitting out errors that I don't care to resolve until i go back to work.

So most of those formats you have tried would be a SWQL style, but this widget specifically calls out in those instructions that its using a SQL syntax. Since I dont have direct access to the db tables right now I can't be sure, but i would expect it should match up to whatever the name of the application id column is in the database when you look at the apm_applications table. Whatever it is there won't be periods as that pattern is unique to SWQL.

mesverrum

So I got into my lab and found that there must be some kind of limitation with this specific Top xx Component by Response Time resource. I tested where I could get it to display the ${applicationid} variable in the title or subtitle of the widget, but no matter what I did if I put any kind of ${anything} variable inside the sql filter section i just stopped getting results completely. Even using OR conditions and other strategies to try and trick the system it just killed the widget if I tried any variable at all in there. This is one of the older widgets in the platform and I guess it just doesn't support this functionality. To get past this limitation I just whipped up a quick starting point of a Custom Query widget that displays the same data SELECT
cs.Component.Application.Node.Caption as Node
, cs.Component.Application.Node.DetailsUrl as [_linkfor_Node]
, cs.Component.Application.Name as Application
, cs.Component.Application.DetailsUrl as [_linkfor_Application]
, cs.Component.Name as Component
, cs.Component.DetailsUrl as [_linkfor_Component]
, cs.componentresponsetime as ResponseTime
FROM Orion.APM.CurrentStatistics cs

where cs.componentresponsetime > 0
and cs.Component.ApplicationID = ${applicationid}

order by cs.componentresponsetime desc

This gets back to a personal rule I have where I just default to making everything myself in SWQL because its saves me from having to chase down all these random quirks of widgets that were added by different devs of different modules across the decades. I know what to expect from the Custom Query so I just use it for everything I can.