Hi,
I am working on a view which will be populated based on the below query. I need to add the Component Status to this view. I see StatusOrErrorDescription which is in the ComponentAlert Table, however the data is not in the format I want. I need to display this Column as UP, Warning or Critical. Please advise.
SELECT B.Name, C.Caption, A.TimeStamp, A.ComponentStatisticData, A.ErrorMessage, A.ComponentID
FROM [APM_CurrentStatistics] A, APM_Application B, NodesData C
join NodesCustomProperties D on D.NodeID= C.NodeID
WHERE
A.ApplicationID=B.ID AND
A.NodeID=C.NodeID AND
B.Name IN ('ApplicationName')
Thanks,
Arnab
