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
Store

Monitors within Template Query

We are trying to create a query that we could run against a node, preferably by IP to check what components are in a specific template. I have one that I believe will work for what templates are on a node, but we are trying to automate things. It would be nice to run a query to check instead of click on each node and have to dig into the applications to see if something is already being monitored. I stink at joins and believe I will have to join dbo.Nodes, dbo.APM_Application, dbo.APM_ApplicationTemplate and dbo.APM_Component, but I'm not really sure on how.

Can anyone help me a tad?

Thank,
Lance

Find more posts tagged with

Accepted answers

All comments

dnerdahl

FROM APM_Component

LEFT JOIN APM_Application on (APM_Component.ApplicationID = APM_Application.ID)

LEFT JOIN APM_ApplicationTemplate on (APM_Application.TemplateID = APM_ApplicationTemplate.ID)

LEFT JOIN Nodes on (APM_Application.NodeID = Nodes.NodeID)

Should get you there.

FormerMember

Right on, thanks a tone. I'll let you know how it does

FormerMember

Thanks so much, after figuring out which table and name to select it works awesome. Thanks so much again!

HolyGuacamole

This should be possible with a custom table in web reporter. you don't need to come up with your own Sql queries. Did you try that route first?

FormerMember

The goal was to check to see if the services were being monitored when we get a ticket, the query is faster than a report isn't it?

dnerdahl

HolyGuacamole has a point in that if you are circulating the information it would probably produce a more finished looking document to write it up in a report.