Trying to Dashboard devices with a SAM monitor Multi-Statistic Monitor

SilentMuse

I have a monitor that queries devices by way of a powershell script that returns multiple statistics for the component. I need to Dashboard this to show only a few specific statistics from the monitor for all devices that contain the monitor. I'll be darned if I can find a way to do this. It looks like my only way to do it is via a Custom Table using SWQL, which is fine, except that I can't figure out the needed relationships to get from the node → component → Multi-Statistic Monitor → individual statistic data. Any ideas?

Lofstrand

Try to use this in a custom query table widget.

SELECT 

    C.Application.Node.Caption AS [Node Name]

    ,C.Name AS [Component Name]

    ,C.DetailsUrl AS [_LinkFor_Component Name]

    ,C.MultipleStatisticData.Label

    ,C.MultipleStatisticData.StringData

    ,C.MultipleStatisticData.NumericData

FROM Orion.APM.Component AS C

WHERE 

    C.Name='SSL Cert Monitor, Powershell Style'  -- Choose your component name to filter on

    AND C.MultipleStatisticData.Label='Expiration' -- Choose the data label to filter on

    AND C.Disabled = FALSE

Change the filters on line 10 and 11 to match your need.