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

Documenting deployed APM test settings

I'm trying to produce documentation of our deployed APM testing settings. The tests are mostly contained in templates, but there are also some discretely applied components. I was looking for a way to produce a list of deployed server, template, test type, component name, parameters and thresholds, but I have not found a way of reporting against templates or components. I imagine that I would need some SQL scripting for this. Is that correct? Has anyone already done this? Thanks.

Find more posts tagged with

Accepted answers

All comments

robertcbrowning

any ideas?

cgregors

I've started down the APM documentation path in my spare time.

I'm working on building up the following sql query:

Note: I don't like joins.

select

nodes . caption 'NodeName' ,

APM_Application . Name 'AppName' ,

apm_component . name 'ComponentName' ,

APM_ComponentDefinition . Name 'ComponentType'

from

APM_Application ,

apm_component ,

APM_ComponentDefinition ,

Nodes

where

nodes . NodeID = apm_application . nodeid and

apm_component . ApplicationID = apm_application . ID and

APM_ComponentDefinition . ComponentType = apm_component . ComponentType

robertcbrowning

Wow.

This is very close to what I need. I've used your query to construct a report and my test environment runs to over 70 pages; I've yet to run it on the live system. No-wonder I felt like I was drowning in information.

It needs the rest of the properties, but is a great start & just ready to drop into an XLS. Thank you.

I'd be gratefull to see the next stages of the query.

cgregors

New variation:

select
    Nodes.Caption 'NODE NAME',
    APM_Application.Name 'APM NAME',
    APM_ComponentDetails.Name 'COMPONENT NAME',
    APM_ComponentDefinition.name 'COMPONENT TYPE',
    APM_Application.Created 'CREATION DATE',
    APM_Application.LastModified 'MODIFIED DATE',
    APM_ComponentDetails."Key" 'VARIABLE',
    APM_ComponentDetails."Value" 'VARIABLE VALUE'
from
    APM_ComponentDefinition,
    APM_ComponentDetails
    join APM_Application on APM_ComponentDetails.ApplicationID = APM_Application.ID
    join Nodes on APM_Application.NodeID = Nodes.NodeID
where
    APM_ComponentDefinition.ComponentType = APM_ComponentDetails.ComponentType and
    APM_ComponentDetails."Value" is not NULL and
    APM_ComponentDetails."Value" != ''
order by
    APM_ComponentDetails.Name,
    APM_Application.Name,
    Nodes.Caption,
    APM_ComponentDetails."Key"