polled details data are stored in APM_WindowsEvent_Detail table. Values used in alerts can be found in APM_ComponentAlertVariable table.
1 of 1 people found this helpful
Awesome! That let me query out exactly what I wanted. Using join with Component, Application and Node tables I was able to drop exactly what the client was looking for into a report.
Thanks for the assist!
Would you mind sharing your SQL?
It's been awhile, but I believe this is the code that I was discussing above. We run a simply log monitor to pull out details of SQL job failures - and we needed to drop them into a report for the client.
This worked well for me, adjust the filter as needed to display the application monitors you're trying to pull from:
select Comments,Caption, C.Name,TimeGeneratedUtc, b.name as Component_Monitor,SourceName,Message as Alert_Message from APM_WindowsEvent_Detail a
JOIN APM_Component b on a.ComponentID=b.ID
JOIN APM_Application c on b.ApplicationID=c.ID
JOIN Nodes d on c.NodeID=d.NodeID
Where C.Name LIKE '%SQL Job%'
ORDER by TimeGeneratedUtc DESC