leonejames1 · SOC / NOC / Engineering · ✭✭✭✭✭

Congrats to all the new MVP's

Any updates on this???? We have the same request

We have been 'Trying' to get the Velocloud api polling to work since day one. I am STILL working with support and have yet to get it working. has ANYONE on here got it working ?? I'm not so certain that it actually works for anyone.

I am not.... We are on version 2023.3 and We still do not see those stats. Are there special instructions?

Thank you all. I had to fail over my sql cluster. This apparently is communication from Solarwinds to the backend DB. Problem resolved. Have a great day all!

Thank you

Yes, but that is not related to my topic. Using the Meraki API polling rather than SNMP, the visual is great. But once you have the orchestrator detail on-screen, you cannot drill down for additional detail. see example. There 

We have access to the vendor's portal, which allows for api access. The device registrations, status, signal strength etc are all in that portal. So static/dynamic would not matter if there is a way to pull that data for ingestion into Solarwinds. Right now I am attempting scrapes from prometheus to display the dat in…

LOL

Yes. I ended up running a query. You would think this would be something 'standard' If someone wants to create a dash, you would want all available resources listed to create something. They have this for some of their other products, but not NPM. I think it's ridiculous. You have to go through every single drop down and…

The original report query from the 1st image above is posted here below. Not sure how to pull in the interface detail for the up/down . select n.caption as [Device] , '/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Device] , n.DetailsUrl as [_linkfor_Device] , isnull(tostring(t2.[Down Event]),concat('Greater…

Ideally? similar to the first image... In this type of format and containing this information: I created an example layout

It's not as fancy and pretty as the reports, but I am close using a sql query. but now I need to add the up/down info as shown in the first snapshot report. Here is what I have so far with the query: WITH NodeData AS ( SELECT YEAR(ia.Timestamp) AS Year, DATENAME(MONTH, ia.Timestamp) AS Month, ncp.Parent_Account_Number,…

I DO have this report, but I need to add interfaces, the times associated with those being up/down, and a sum at the bottom for each site (total down) I can't figure out how to get that into my report.

Purpose of this report is to show monthly site availability for a customer. Grouped by location. That way it shows the nodes for that location, the interfaces, node up/down time and detail of interface up/down time. That way if a node has a backup line and there are two interfaces, we can show that the up/down of that node…

Thank you all.... I actually ended up creating a query that worked. Thank you for the lead SELECT TOP 300 RelatedNodeID AS NodeID, RelatedNodeCaption AS NodeName, MAX(TimeStamp) AS LastTriggeredDateTime, COUNT(*) AS Triggered, Message AS AlertAction, Name AS AlertType FROM AlertHistoryView WHERE TimeStamp >= DATEADD(day,…

Thank you all for your assistance. Have a safe and healthy Thanksgiving all

I get this error: Msg 195, Level 15, State 10, Line 1 'ToString' is not a recognized built-in function name.

yeah.... tried both ways. Seems to be lack of data to pull... now attempting the suggestion mesverrum had above. Trying to figure out how to accomplish his suggestion.

Yeah..... most of the time there are just blanks. Even for snmp devices. I can;t seem to find a good place to pull that data from

Here is the actual code...without the copy/paste error. Only the app key has been removed................................................................. { "app_key": "xxxxxxxxxxxxxxxxxxxx", "status": "${N=Alerting;M=Severity}", "managed": "${N=SwisEntity;M=CustomProperties.Managed}", "byob":…

I alos realized that when I copy and pasted, I paster one wrong.. "macid": "${SQL: SELECT TOP 1 MAC FROM NodeMACAddresses FROM APM_HardwareInfo WHERE nodeid=${NodeID}}", The way that I have it is actually below.... Sorry about that. was a copy/paste error in this thread. LOL "macid": "${SQL: SELECT TOP 1 MAC FROM…

95% of what we monitor are switches and routers. We realize we will only get data from snmp related devices, not icmp, but it seems even with managed snmp devices, we don't return much data from these tables. Hoping to find the proper location for where this data is stored in the database.

Interesting I have no collector.businesslayer logs 

regardless of product, the account and permissions should be somewhere in detail to extract. And there must be some entries in the DB. Suprised they don't offer an export feature or canned reports with detail

Does anyone know where the historical data for the pollers are kept? performance/cpu/ram etc?

great idea. Thank you. I will check this out for sure!

got it working... The only thing I can't seem to find is polling capacity... not sure if they have a filed that stores their calculation, or HOW they get that calculation.... otherwise, this gives me everything that I need. You pointed me in the right direction. Thank you so much! SELECT ND.NodeID AS ND_NodeID, ND.SysName,…

2023.1.0

I can't find a table named Orion.PollingUsage ??