jasonf1971 ✭✭

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…

how would it look in the swql ?

Still not seeing all cisco related notes if i use AND [Nodes].Description IN ('List', 'Your', 'Device', 'Models', 'Here') </code></p><p><code>if i dont use the above i get cisco nodes appearing along with other vendor type (windows etc)

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 

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 !

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) 

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…

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 need to add but not sure where / how Meraki MX67C, Meraki MX450, Cisco 887VaWEK9 , Cisco 881-K9 - thanks

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

Any ideas - thanks

i have sorted it 

Right all - need to amend the swql to ignore test routers - any ideas how the amendment would look thanks

yes - solarwinds > jira thanks

Thank you - now working with the amendments

Need to make a slight amendment have found out some UK have a prefix of 4 rather than 3 how do i combined the swql to include 3 & 4 thanks 

Perfect - works great thank you 

the first character 3 - UK 5 - Roi 7 - NL 9 - BE

for example node named 9007 - can the swql be amended so it only picks up the first number currently swql is picking up all numbers and so is alerting for NL & BE 

how would the swql look for country custom property ?

Is there a way the SWQL could be amended to only pick up the first number only in the node name in theory anything with 3, 5,7 & 9 would be be displayed 

OK thanks, that is something i have no knowledge of, thank you for your help - appreciated 

Looks like there is no common format for naming of devices 

Hi - location name is normally the city the node is located rather that the Country 

hi - im not sure of your question 

This is the swql i am using for UK & NL and it works fine SELECT Count(N.nodeid) as [NL] FROM Orion.Nodes N WHERE N.Caption like '%7%' and Status=2 AND (n.customproperties.AssetTag like 'Store Router') SELECT Count(N.nodeid) as [UK] FROM Orion.Nodes N WHERE N.Caption like '%3%' and Status=2 AND (n.customproperties.AssetTag…

I Have tried the above but its picking up nodes that are down even though they are not mainly for ROI & BE 

if i wanted to include 3 countries in one widget how would the swql look ?

Yes that works a treat thank you, is there a way that this can be output to the kpi widget for each country ?

this is the error i am getting -