Have modified this query which gives the last traffic received time in IST hour zone.
SELECT Nodes.DisplayName,Nodes.IP_address,addminute(-690,NT.LastTimeFlow) as LastTimeFlow_IST FROM Orion.Nodes AS Nodes
join Orion.Netflow.Source as NT on Nodes.NodeID=NT.nodeid
JOIN (
SELECT DISTINCT NodeID FROM Orion.Netflow.Source
WHERE LastTimeFlow < AddMinute(-20, GETUTCDATE())
AND Enabled=True
AND (
EngineID IS NULL OR
EngineID NOT IN
(
SELECT EngineID FROM Orion.Netflow.FlowEngines
WHERE FlowCollectorKeepAlive < AddSecond(-90, GETUTCDATE()) OR
AddMinute(7, FlowCollectorStartTime) > GETUTCDATE()
)
)
AND NodeID IN (LIST OF NODES SEPERATED BY COMMA)
AND NodeID NOT IN (SELECT NodeID FROM Orion.Netflow.Source WHERE LastTime > AddMinute(-20, GETUTCDATE()))
) as Source
ON Source.NodeID = Nodes.NodeID
WHERE Nodes.NodeID NOT IN (
SELECT EntityID FROM Orion.NetObjectDownTime
WHERE EntityType = 'Orion.Nodes'
AND DateTimeUntilNow > AddMinute(-20, GETUTCDATE())
AND State = 9
AND EntityID IN (LIST OF NODES SEPERATED BY COMMA)
)
