Create a report for router availability

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')