AlertStatus only contain ~10 alerts.
After they are clean from AlertStatus, do they go into another table ?
I ask because I have to make a SQL / report that show error for node, volume and application with more than those label (show on https://orion.rtss.qc.ca/Orion/NetPerfMon/Alerts.aspx): TIME OF ALERT, ALERT NAME, ALERT TYPE, NETWORK OBJECT, ACKNOWLEDGED BY, ACKNOWLEDGED TIME.
Also, any way to join table AlertStatus and Nodes ? They have no common ID....
ActiveObject and ObjectType are what you should join on
Somethng like this:
Select Top 1000 *
From AlertStatus A
left outer join Nodes N
on N.nodeid=A.ActiveObject and A.ObjectType='Node'
left outer join Interfaces I
on I.InterfaceID=A.ActiveObject and A.ObjectType='Interface'
left outer join NPM_NV_WL_APS W
on W.ID=A.ActiveObject and A.ObjectType='Wireless Access Point'
(there maye be other tables that you need to join, for example if you have UDT alerts, IPAM alerts, SAM alerts, etc....)