jajao555 ✭✭✭✭✭

No we are on 2024.1.1 now. I ended up just converting them to SQL. I just tried my original SWQL query again and it's working now so no idea what happened.

You would join the table back on itself to move rows to a different column if that makes sense. Here's an example of something similar we have but is the same idea. Also look in Orion.NPM.CustomPollerAssignmentOnNode there's alot of pre joined tables you could use from there. SELECT N.NodeID, N.IPAddress, CPON.CurrentValue…

Yep we setup custom pollers for the things we wanted monitored then setup modules like these to display the info and then also setup alerting for the various failure values the OIDs return. Its a bit of effort but doable. We had this with Ciena devices which also have no built in support.

That isn't how you use the SQL alert you have to select it from the dropdown. You should see options for SQL and SWQL alerts. Then you'll get a screen like this depending on the type of UNDP poller you setup if its a table or whatever type you have setup. You just have to work off the SELECT statement that isn't editable…

Something like this? Replace LATA with your custom property. SELECT N.CustomProperties.LATA, N.ResponseTime, N.ResponseTimeHistory.PercentDown, N.ResponseTimeHistory.Availability, round(AVG(N.ResponseTimeHistory.Availability),2) AS AverageAvailability FROM Orion.Nodes N WHERE (N.CustomProperties.LATA LIKE '%West%') --…

Maybe you need to setup you UNDP poller as a GET or GETNEXT for the specific .1.3.6.1.4.1.850.1.3.4.1.1.3.1.7. It looks like its showing a table for your .1.3.6.1.4.1.850.1.3.4.1.1.3 example. You just need to do a specific get for the next 1.7 of the hierarchy maybe?

I figured out my issue. I needed to use the same Orion.NPM.CustomPollerStatusOnNodeTabular table as the alert was setup on then the variables started working. ------------- PeerIP: ${N=SWQL;M=SELECT TOP 1 Status AS PeerIP FROM Orion.NPM.CustomPollerStatusOnNodeTabular A WHERE CustomPollerID =…

I don't think you'd be able to do that without being able to tie the neighbor IP to a node IP. Are these eBGP or iBGP peers? I was able to tie an interface to our eBGP peers using ARP tables with the query below maybe it will help depending on how you peers are setup? SELECT TOP 1000 --R.NodeID, --A.Node.CoreNodeID,…

I ended up resolving this by using the format drop down in the UnDP creation and changing it to MAC address. It then just outputs the HEX in the snmpwalk which is just the IPv6 address.

Thanks @"KMSigma.SWI" that helped. I see your point but having a percentage would allow you look at for example all interfaces with more then 1% traffic discarded or whatever your policy is. This is usually only an issue when we have customers that don't setup shaping on the other side. I did end up seeing weird…

I'm not sure I can I haven't figured out how to use PerfStack for a custom poller and also make it display stats for an individual Interface Details page. In the example query I just used an InterfaceID to test but I would want the graph to show up on any interface details page and show results for that page. So I would…

I think you would just use the check box under the query.

Thanks all but nothing has worked so far. -Tried creating brand new report and setting it up the same way. Even tried creating a new schedule. -Verified the account was a local reporting account we use. Same one used for the working report. This is a screen shot for more info. We get one report that has the .pdf so it…

Nice thanks I'll look into that then.

Bump? Anyone ever had to do this?

I'm not sure how long it actually takes. We still have the default 2 min timeout in SWQL studio. Are there any risks to increasing the timeout? Maybe I could just run a report instead of having the widget as a work around?

I ended up figuring this out. I wasn't grouping correctly. For anyone that might find this here's the query for last 2 hours as an example SELECT TOP 10 N.NodeName AS Node, I.Node.DetailsUrl AS [_Linkfor_Node], '/NetPerfmon/images/Vendors/' + I.Node.VendorInfo.Icon AS [_Iconfor_Node], I.Caption AS Interface, I.DetailsUrl…

I ended up figuring out how to do this with swql. Example for anyone else that might have trouble. Not sure if its the best way but I ended up naming poller in such a way to be able to group them and use the InterfaceID variable so it just displays the related stats for that interface on it's page SELECT DateTime,…

Thanks I'll try this!

bump?

bump?

You should be able to select a RowID field like this in the alert

Yea that helps. So creating a group for the interface and node and then setting it to show worst would achieve the goal. If either the node or interface goes down the child nodes would be suppressed and only the interface or node would actually show down correct?