I have documented the whole solution here:
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?
| NAME | STATUS | STATISTIC | MESSAGE |
ComponentName AS NAME,
StatusDescription AS STATUS
ApplicationID IN ('995','996') AND
StatusDescription IN ('Warning','Critical')