Help with SQL Statement - pull error message and node name from APM_CurrentComponentStatus

bobquinlan2001

I am trying to build a report that will display the node and errormessage from the component if the error includes the keyword "auto".

The command I am using does not give me the node name. Can you help join the node name into the following:

SELECT* FROM APM_CurrentComponentStatus where errormessage LIKE 'Auto%'

Thanks

Bob Quinlan

HarperCollins Publishers

sql.png

Petr.Vilem

You need to join another tables to get information about node:

SELECT ccs.*, n.NodeID, n.Caption, n.IP_Address 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 'Auto%'

NOLOCKs should prevent this query from obstructing updates from polling.

LIKE 'Auto%' = starts with "Auto"

LIKE '%Auto%' = contains "Auto"