Looking to run a SWQL query to get the "monitoring status" of the "disabled" components within assigned templates.
The following query is returning components as "unknown" for components disabled in assigned templates. I would like to return the "monitoring status" as shown in the screenshot of editing an assigned template
SELECT a.Node.Caption,a.node.ObjectSubType,a.Node.StatusLED as nodestatus,a.StatusDescription as appstatus,a.node.Vendor,a.Name as aname,a.Components.Name as cnname,a.Components.StatusDescription as componentStatus,a.Components.ComponentID
,a.Node.CustomProperties.Environment
FROM Orion.APM.Application a
where
a.Components.StatusDescription <> 'Disabled' and a.Components.StatusDescription <> 'up'
and a.Node.Caption='XXXX'
