CREATE VIEW CurrentNonAvailView AS
SELECT server_addr, probe_addr, ifIndex,rsrcType, rsrcOtherIndex,
    IntervalDateTime=start_down_time,start_down_time,
    end_down_time = CASE
        WHEN end_down_time IS NULL THEN end_time
        ELSE end_down_time
        END,
    downDuration= CASE
        WHEN end_down_time IS NULL THEN datediff(second, start_down_time, end_time)
        ELSE datediff(second, start_down_time, end_down_time)
        END
    FROM NonAvail na, SessionLength s
    WHERE na.sessionNumber=s.sessionNumber
    AND end_down_time IS NULL
    AND s.sessionNumber=(SELECT MAX(sessionNumber) FROM SessionLength)
GO
GRANT SELECT ON  [dbo].[CurrentNonAvailView] TO [uniadmin]
GO