Create a report for router availability

What about this report and then just filtering it for your specific device type?

Thank you for this - how do i get it just to pick up the correct device type ?

That depends on your environment.  However you define what a "router" is, you just add that as a filter to the report.  For me it used to be by model name: Cisco 2821, Cisco 3945, etc., but each environment is different.

this is what i need to add but not sure where / how Meraki MX67C, Meraki MX450, Cisco 887VaWEK9 , Cisco 881-K9 - thanks

Just add them as an additional filter all the way at the end of the data source...

Click Edit on the data source

And at the bottom add:

  AND [Nodes].Description IN ('List', 'Your', 'Device', 'Models', 'Here')

Right ok getting somewhere - still seeing other devices on the report other than routers - how do i get rid of these :- 

OracleServer

NetBotz 455 Wall

windows 2019 server 

winddows 2016 server 

Ubuntu

this is what i have so far - SELECT [Nodes].Caption
, [Nodes].DetailsUrl
, [Nodes].VendorInfo.Icon
, [ResponseTime].Day
, [ResponseTime].Availability
, [Downtime].MinutesDown
, [Downtime].CalcAvailability
, [Events].RebootCount
-- To add Node Custom Properties use:
-- , [Node].CustomProperties.<Custom Property Name>
FROM Orion.Nodes AS [Nodes]
INNER JOIN (
SELECT [RT].NodeID
, DateTrunc('day', [RT].DateTime) AS [Day]
, AVG([RT].Availability * 1.0) AS Availability
FROM Orion.ResponseTime AS [RT]
GROUP BY DateTrunc('day', [RT].DateTime)
, [RT].NodeID
) AS [ResponseTime]
ON [Nodes].NodeID = [ResponseTime].NodeID
INNER JOIN (
SELECT [DT].NodeId
, DateTrunc('day', [DT].DateTimeUntil) AS [Day]
, SUM([DT].TotalDurationMin) AS [MinutesDown]
, ( ( 1.0 - ( SUM([DT].TotalDurationMin) / 1440.0 ) ) * 100.0 ) AS [CalcAvailability]
FROM Orion.NetObjectDowntime AS [DT]
INNER JOIN Orion.StatusInfo AS [SI]
ON [DT].State = [SI].StatusId
AND [SI].StatusName = 'Down' -- Where the status is 'Down' (not 'Critical', 'Warning', etc.)
WHERE [DT].EntityType = 'Orion.Nodes' -- Only show me nodes
AND [DT].DateTimeUntil IS NOT NULL --Indicates that it's no longer down
GROUP BY DateTrunc('day', [DT].DateTimeUntil)
, [DT].NodeId
) AS [Downtime]
ON [ResponseTime].NodeId = [Downtime].NodeID
AND [ResponseTime].Day = [Downtime].Day
RIGHT JOIN (
SELECT [E].Nodes.NodeID
, COUNT([E].EventID) AS [RebootCount]
, DATETRUNC('day', [E].EventTime) AS [Day]
FROM Orion.Events AS [E]
WHERE [E].EventTypeProperties.Name = 'Node rebooted'
-- AND [E].Nodes.CustomProperties.<Custom Property Name> = <Custom Property Value>
GROUP BY DATETRUNC('day', [E].EventTime)
, [E].Nodes.NodeID
) AS [Events]
ON [ResponseTime].NodeID = [Events].NodeID
AND [ResponseTime].Day = [Events].Day
WHERE [Nodes].ObjectSubType <> 'ICMP'
-- Required for Orion Reports
AND [ResponseTime].Day BETWEEN ${FromTime} AND ${ToTime}
-- To filter on Node Custom Properties add
-- AND [Node].Description IN ('Meraki MX67C', 'Meraki MX67C',' Cisco 887VaWEK9', 'Cisco 887VaWEK9')

Remove the double-dash from the beginning.  That means that line is a comment.

Right need report to pick up all polling methods how do i amend thanks - this is what i get if i try to run report with icmp double dash (to ingore basically) 

Right need report to pick up all polling methods how do i amend thanks - this is what i get if i try to run report with icmp double dash (to ingore basically) 

I dont think the report is working correctly - i have made the amendments as per above but stuff that was appearing for cisco switches is no longer appearing !

Reverted back to original report and stuff is appearing again i.e more routers appear but still getting windows server on the report how can i get rid of none router devices thanks 

It's a full query language.  You can't just ignore things.  And the only things I'm ignoring are ICMP (ping-only).  So SNMP, WMI, and Agent are all reported.

Still not seeing all cisco related notes if i use 

  AND [Nodes].Description IN ('List', 'Your', 'Device', 'Models', 'Here')

if i dont use the above i get cisco nodes appearing along with other vendor type (windows etc)

[Nodes].Description is Model name (Cisco 2821)

[Nodes].Vendor is Vendor name (Cisco)

how would it look in the swql ?

If you want all Cisco devices, then the filter would be:

[Nodes].Vendor = 'Cisco'

If you wanted Cisco and Meraki, then it would be:

[Nodes].Vendor IN ('Cisco', 'Meraki')

If you wanted Cisco devices and Meraki XR models, then it would be

[Nodes].Vendor = 'Cisco' OR [Nodes].Description LIKE 'Meraki XR%'

We can help guide you on this, but we would need to know exactly what you wanted in your filters.

that works a treat thank you, is there way through of the report to pick up any other downtime other than just due to a reboot, i olny ask i have a node down that is not showing on the report node been down for a while and is a router device, also can the report be setup to give the actual time the device went offline and back online - thanks 

need to include the following device types Meraki MX67C', 'Meraki MX67C',' Cisco 887VaWEK9', 'Cisco 887VaWEK9, have tried the following but no results are being shown even though a device of that type is down  AND [Nodes].Description LIKE 'Meraki MX67C '

the issue i have is the report is just not picking up anything meraki related which is strange help!!!!, this is what i get from the report when using just 'meraki'  - AND [Nodes]. Vendor IN ('Meraki')