Hello Everyone,
I am trying to generate downtime report for nodes with Down status only , but issue is that report shows me Warning, Critical and other status also which I don't want. Secondly I couldn't find option to generate report for a specific time period like (report for specific Month , Week or Day)
This is solarwind web based report and I had used dynamic query builder to filter status field to show me only down status
There was a similar report in the legacy Report Writer. You could edit the query below to include the time you are interested in.
This was the Node Availability - Last Month chart
SELECT TOP 10000 CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
Nodes.NodeID AS NodeID,
Nodes.VendorIcon AS Vendor_Icon,
Nodes.Caption AS NodeName,
Nodes.IP_Address AS IP_Address,
AVG(DailyNodeAvailability.Availability) AS AVERAGE_of_Availability
FROM
Nodes INNER JOIN DailyNodeAvailability ON (Nodes.NodeID = DailyNodeAvailability.NodeID)
WHERE
( DateTime BETWEEN 43798 AND 43828.9999884259 )
GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.NodeID, Nodes.VendorIcon, Nodes.Caption, Nodes.IP_Address
ORDER BY SummaryMonth ASC, 4 ASC
@bobmarely thanks a ton for your help
Actually I just want to see down status on node in my above mention report but it is showing me Warning, Critical and other status which I don't want to see. I just want to see Down status in my above report.
If you put this into SWSQL into a report. It will show you all of the currently down nodes and the time they went down.
SELECT
NodeName AS [Node Name],
'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],
DetailsUrl AS [_LinkFor_Node Name],
MAX(DOWNEVENT.EVENTTIME) AS [DOWN TIME]
FROM ORION.NODES NODES
INNER JOIN ORION.EVENTS DOWNEVENT
ON NODES.NODEID = DOWNEVENT.NETWORKNODE
WHERE STATUS = 2
GROUP BY NodeName, StatusIcon, DetailsUrl, Nodes.CustomProperties._Group
ORDER BY NodeName
bobmarley Again thank you so much! but when I used above query into SWSQL report it is giving me error *Query is not valid
Sorry, pull this off the above query - Nodes.CustomProperties._Group
I have a Custom Property defined in my environment called _Group.
The one below should work and look like this.
SELECT
NodeName AS [Node Name],
'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],
DetailsUrl AS [_LinkFor_Node Name],
MAX(DOWNEVENT.EVENTTIME) AS [DOWN TIME]
FROM ORION.NODES NODES
INNER JOIN ORION.EVENTS DOWNEVENT
ON NODES.NODEID = DOWNEVENT.NETWORKNODE
WHERE STATUS = 2
GROUP BY NodeName, StatusIcon, DetailsUrl
ORDER BY NodeName
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.