Using variables in custom swql query

rinat.kirimov

Hi,

I'm thinking about adding "custom sql quiry" widget to every node with the following query:

SELECT ADDDATE('HOUR',-7,AlertHistory.[TimeStamp]) as "Time"        ,AlertObjects.TriggeredCount as "TimesTriggered"        ,AlertHistory.Message as "Message"    FROM [Orion].[AlertHistory]inner join [Orion].[AlertObjects] on AlertHistory.[AlertObjectID]=AlertObjects.[AlertObjectID]  WHERE AlertObjects.RelatedNodeCaption = '${N=SwisEntity;M=Caption}' ORDER BY TimeStamp DESC

I want to have it on each node's summary page. So far, it doesn't seem to be working. Any suggestions?

i_like_eggs

so very close, this should do the trick..

SELECT ADDDATE('HOUR',-7,AlertHistory.[TimeStamp]) as "Time" 
      ,AlertObjects.TriggeredCount as "TimesTriggered" 
      ,AlertHistory.Message as "Message" 
  FROM [Orion].[AlertHistory]inner join [Orion].[AlertObjects] on AlertHistory.[AlertObjectID]=AlertObjects.[AlertObjectID] 
WHERE AlertObjects.RelatedNodeID =  ${NodeID}
ORDER BY TimeStamp DESC