Hi,
Please help me with my doubt.
Is there any way to insert a component status icon in the sql query below ?
Select n.caption, ccs.errormessage FROM APM_CurrentComponentStatus ccs WITH (NOLOCK)
INNER JOIN APM_Application a WITH (NOLOCK) ON ccs.ApplicationID = a.ID
INNER JOIN Nodes n WITH (NOLOCK) ON a.NodeID = n.NodeID
where ccs.ErrorMessage LIKE '%cisco_router%'