Generating Node Availability Reports via Orion Web Console and Based on Business Hours Only

Try this out:

SELECT
CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),101) AS SummaryMonth,
Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability

FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

WHERE
(
  DATEPART(dw, DateTime) between 2 and 6
  AND
  (
  DateTime BETWEEN
  CAST(Convert(Char(10), DateTime, 101) as smalldatetime) + ' 08:00'
  AND
  CAST(Convert(Char(10), DateTime, 101) as smalldatetime) + ' 18:00'
  )
)

GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.NodeID, Nodes.Caption

ORDER BY SummaryMonth, Caption

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Hi Guys,

I still want to find out the possibility of generating report based on node availability under business hours using the WEB CONSOLE.

I know how to do it with the Report Writer.

Please enlighten me.

Regards,