I have documented the whole solution here:
=============================================================
Hi All,
This is pretty basic question but I could not find the answer. I need to be able to output in SWQL MESSAGE and STATISTIC values for the component. Can anyone help to modify below SWQL query to do so?
Desirable Output:
| NAME | STATUS | STATISTIC | MESSAGE |
SELECT
ComponentName AS NAME,
StatusDescription AS STATUS
FROM
Orion.APM.Component
WHERE
ApplicationID IN ('995','996') AND
StatusDescription IN ('Warning','Critical')
Thank You,
Alex