Need to create a report for components with type of components which are currently enabled for monitoring

Need to create a report for components with type of components which are currently enabled for monitoring( example like windows event id, windows service monitor)

Find more posts tagged with

Accepted answers

All comments

naveensingh43

Try the below SWQL Query

SELECT

A.ComponentName,

A.ComponentType,

A.ComponentStatus,

B.ApplicationName,

C.NodeName

FROM

APM_Component A

JOIN

APM_Application B ON A.ApplicationID = B.ID

JOIN

Nodes C ON B.NodeID = C.NodeID

WHERE

A.ComponentStatus NOT IN (3, 9, 11) -- Exclude Unmanaged, Not Running, Offline

Lofstrand

Just to clarify, that looks like a SQL query and not a SWQL query.

Below as SWQL to the same info:

SELECT
    C.ComponentName,
    C.ComponentType,
    C.status,
    C.StatusDescription,
    C.Application.Name AS AppName,
    C.Application.node.DisplayName AS NodeName
FROM Orion.APM.Component AS C
WHERE
    C.status NOT IN (3, 9, 11) -- Exclude Unmanaged, Not Running, Offline