Generated on 2026.1.1 version
Generate a report showing SAM/APM component-related events from the last 7 days, sorted with the newest event first. This query will map each event to its component, application, and node so you can see the full context of where the event happened.
SELECT
E.EventTime AS TriggerTime,
N.Caption AS NodeName,
APP.Name AS ApplicationName,
C.Name AS ComponentName,
E.Message AS EventMessage,
'APM: Component' AS AlertCategory
FROM Events E
INNER JOIN APM_Component C
ON E.NetObjectID = C.ID
INNER JOIN APM_Application APP
ON C.ApplicationID = APP.ID
INNER JOIN Nodes N
ON APP.NodeID = N.NodeID
WHERE APP.Name IS NOT NULL
AND E.EventTime >= DATEADD(DAY, -7, GETDATE())
ORDER BY E.EventTime DESC
Output:
