custom query for fetching active alerts

 I am trying to query the below parameters (Active Alarms , relevant Node details , its Severity and Region etc.) ...From the documentation active alerts can be fetched from this details 

[Orion.AlertActive ] 

in the above table , i am not able to query relevant node details , severity ,, can some one help me which this creating custom query fetch these properties [Active alerts , respective node id , alert severity , and region ]

Parents Reply
  • This is the seperate query gives node region , 

    SELECT TOP 1000 NodeID, Building, City, Comments, Department, Device_Severity, Device_Type, GPS, HW_EOL_DATE, Network_Segment, OS, OS_VERSION, PRODUCT_ID, RACK_Location, Region, Site_Type, Technology_Group FROM Orion.NodesCustomProperties 
    how do we incorporate and make it in single query ..with active alerts , node region also fetches ?