SWQL for Application Monitor name

I want to use and filter the "All Applications Tree" for a specific user view. I know how to filter by a custom property, but that doesn't work in this case.

Example:

I have HTTPS Monitors on this application, but the monitor is from a test server. That way it's not testing against itself. I don't want to lump the test server into the same custom properties as the application servers.

To get the HTTPS monitor included in the tree I just need to filter by the name of the HTTPS monitor. I was hoping somebody knew the SWQL for Application Monitor Name.

In the example my HTTPS Monitor is named, "Application Name - HTTPS Monitor." So for the SWQL it should be something like ApplicationMonitor.Name = 'Application Name - HTTPS Monitor'

Thank you!

Find more posts tagged with

SWQL

swql_filter

swql filters

application_monitor

swql filter

Accepted answers

All comments

TMKKCC

Hopefully this helps, as I am some what looking for the same thing. I will update this comment if I do find it.

I would check the SWIS SDK Schema here http://solarwinds.github.io/OrionSDK/schema/index.html

and I suspect it to be under either Orion.APM.Application or Orion.APM.Component

mesverrum

That widget doesnt exactly use SWQL, IIRC its actually older than SWQL has even been around. The syntax is describe when you hit the edit button

Application.Name like '%orion%'

chucksimalchik

I use this as a base to find where specific applications are deployed. Could also change the WHERE clause to search for component names instead.

Alternatively you can construct it using Orion.APM.Application but this works for me and seems like it would get you where you are looking to go.

SELECT c.Application.Node.Caption, c.Application.Node.IPAddress, c.Application.Name as [App Name], c.ComponentName, c.UserDescription, c.UserNotes, c.Description, c.StatusDescription, c.Disabled FROM Orion.APM.Component c where c.Application.name like '%Application Name - HTTPS Monitor%'