maciej.sandecki · IT Consultant · ✭✭✭✭✭

Please see this post: thwack.solarwinds.com/.../313593

From what I see Meraki MX devices with cellular currently do not expose cellular interface via SNMP, so Solarwinds is not able to link the WAN Uplink to an SNMP interface.

Would ignoring lines with only this word be ok? Try using ^switchport$ regex for this.

Could you share the sample output you are getting and tell what is missing? Does it truncate rows, columns or values displayed?

I think the reason is you are running this query in Database Manager or SQL Management Studio which use SQL, but the queries proposed use SWQL, so you need to run them using SWQL Studio available here: OrionSDK

Try this: SELECT [Actions].ActionTypeID AS ActionType, [Actions].Title AS ActionName, [Actions].Description AS Email, [Actions].Assignments.CategoryType AS Action, [Actions].Properties.PropertyValue FROM Orion.Actions AS [Actions] WHERE [Actions].ActionTypeID = 'Email' AND [Actions].Properties.PropertyName = 'SmtpServerID'…

Checking in Wireshark there is only a single ping sent every 120 seconds (the default polling interval). If that fails it enters fast polling as described in the article linked earlier (and more details are in a post linked in the article).

Please check if this is what you are looking for: How the Orion Platform polls for availability

This is how we configured it:

Please see if this gives you the results you expect: SELECT * FROM ( SELECT Nodes.STATUS ,Nodes.Caption ,StartTime.Message ,StartTime.DownEventTime ,( SELECT TOP 1 EventTime FROM Events AS EndTimeTable WHERE EndTimeTable.EventTime >= StartTime.DownEventTime AND EndTimeTable.EventType = 5 AND EndTimeTable.NetObjectType =…

I tried to leverage data in Orion.TopologyData entity. I wasn't able to test this extensively, but I think it works fine. Please see if this works for you. Change the trigger condition to SWQL and put this: LEFT JOIN Orion.TopologyData AS td ON ( (Interfaces.NodeID = td.SrcNodeID AND Interfaces.InterfaceID =…

What is your trigger condition for the Interface Down alert? In my environment I can see for nodes that are Unreachable that their interfaces are Unreachable too, not Down. If you are using the Out-of-the-box Interface Down alert, note that it's 'Condition must exist for more than' is not enabled, so the alert will action…

Unfortunately, based on feedback I received from Solarwinds only Meraki MXs and MRs are currently supported via API, MS switches are not supported at this moment (no option in List Resources for Meraki API poller). However, when the dashboard is added via API, Solarwinds pulls full list of Meraki devices…

Take a look at this one: documentation.solarwinds.com/.../npm-meraki-sd-wan.htm

Yes, you won't be able to get these details via SNMP only from Meraki.

@"vandu" I think you mixed MS SQL Server Management Studio and SWQL Studio. The error that you posted comes from MS SQL Server Management Studio (I tested and got the same result). SWQL Studio is part of Orion SDK. Also, it looks like the query works in your resource in NPM (at least syntactically, otherwise you would not…

Looks to me you are running this still in the Database Manager, not in SWQL Studio. SWQL Studio is available for downloading here: https://github.com/solarwinds/OrionSDK

Can you post a screenshot / content of the error you are getting for below query run in SWQL Studio?: SELECT OrchestratorNodeID, DeviceSerial, DeviceID, IPAddress, Name, Model, ProductType, SiteID, StatusDescription, Status FROM Orion.Orchestrators.Devices

I think I found a way to get this into a Custom Table resource. Uncheck 'Use current network object as Data Source' Then in 'Edit Datasource' choose SWQL selection method and use this query: SELECT od.OrchestratorNodeID, od.DeviceSerial, od.DeviceID, od.IPAddress, od.Name, od.Model, od.ProductType, od.SiteID,…

Please use SWQL Studio instead, the query is using SWQL, not SQL.

As far as I know, there is no option currently to get these details (serial number, device model) in the same widget (Hardware Health). Maybe it would be possible to built a custom resource based on SWQL query, but I don't have a working one at the moment.

Where do you get such error? In SWQL Studio? I think this entity was added somewhere in 2023 major version. Previously there was Orchestrator.Meraki.Devices - can you check this one? Also, can you check you are using the latest SWQL Studio?

I noticed in my environment that if we swap Cisco device with a Meraki device, and the Cisco device was previously monitored in Solarwinds, then some details will get refreshed (like Vendor, node name), but some are stuck on the old data (e.g. data in Hardware Health widget). What I need to do then is switch the node to…

No, this widget is for Hardware Health, which is used with SNMP (it works on newer Cisco, HPs). For Meraki you will not see the serial number currently in the web interface, except for the MXs in Warm Spare setup, like this: Can you check directly in the Orion.Orchestrators.Devices what you see? SELECT OrchestratorNodeID,…

You won't be able to get serial numbers from Meraki via SNMP, you need API and Dashboard added as node for this, and you need Solarwinds Platform 2022/2023 for this.

Do you have the Meraki Dashboard added via API as a node? For this to work you need both: a switch added by SNMP and Meraki Dashboard added via API.

Ok, I see it was added in v2022 or v2023 at interface level. Thanks!

Can you really see discards / errors on this interface? In one of my cases I can see this: Still this interface is Up, maybe because it has not passed the thresholds (1000/hour for Warning, 2500/hour for Critical). The setting you mention is at node level, not interface level. At interface level I don't see drop-down with…

Can you see if changing your queries like below helps?: SELECT TOP 1 ExecutedAt FROM Orion.NetPath.Tests WHERE EndpointServiceID = ${N=SwisEntity;M=EndpointServices.EndpointServiceID} ORDER BY ExecutedAt DESC

Can you see if there are any events recorded for that interface / node?