Filtering in SQL

i think i got the NODE piece but i'm still working on the Duration. the percent part is wildcard of course. remove it and use your exact node name.

i'm not a SQL person but i'll give anything a try...

SELECT
    StartTime.EventTime,
   
    Nodes.Caption,
    DATEDIFF(Mi, StartTime.EventTime,
    (SELECT TOP 1
        EventTime
        FROM Events AS Endtime
        WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5
            AND EndTime.NetObjectType = 'N'
            AND EndTime.NetworkNode = StartTime.NetworkNode
        ORDER BY EndTime.EventTime)) AS DurationInMinutes


FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N')

AND Nodes.Caption LIKE 'MyNodesNamed%'
ORDER BY StartTime.EventTime DESC

Thanks for the response. We will appreciate if you can give us the script for this problem. Really need it.

seems to avoid the NULL if you use it this way.

change your AND EndTime.EventType = 5

to this

AND NodeID > 1