KPI Widget for Single Node Availability

Prineel

Hi Thwackers, please help, looking to add a KPI widget based on a single node availability over the last 24 hours, how do I specify NodeName or Caption in the query below?

SELECT avg(Availability) as ava FROM Orion.ResponseTime
where datetime >= ADDHOUR(-24,getdate())

Able to return a value on NodeID but would like to specify

SELECT AVG(rt.Availability) AS AvailabilityPct FROM Orion.ResponseTime rt

WHERE rt.NodeID = 3

AND rt.DateTime >= ADDHOUR(-24, GETDATE())

Thanks

mesverrum

pretty sure you can change the where condition from 

WHERE rt.NodeID = 3

to 

WHERE rt.node.Caption = 'MyNodeCaption'