hi guys,
I am trying to perform some sql raports over our nodes that show how much time a node stays in a breakdown position.For this purpose I apply this sql codes to query.But in this codes,I can not convert OutagedurationinMunites from string to Integer.If anyone knows how to convert string to integer,please response this message.
best regards.....
SQL codes are below:
SELECT
StartTime.EventTime,
Nodes.Caption,
Nodes.Location,
StartTime.Message,
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 OutageDurationInMinutes
FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') AND
eventtime between dateadd(month, -6, getdate()) and getdate() AND Nodes.NODETIPI = 1 AND 'OutageDurationInMinutes'>='180'
ORDER BY Nodes.Caption ASC
