adam.beedell · SRE/Machine Learning Student · ✭✭✭✭✭

No worries, that advise was with SWQL in mind anyway. Case statements work the same in both really

Had a test as it'd been a while since i've touched the proportional widget If you add the status description you lose the icons and auto-colour formatting You can put the colours and text in bit it's a right faff. Not sure how to do the icons offhand but it's basically another table to join Example colours: Select…

They wrong lol

I suppose you're referring to the "All alerts this object could trigger" resource? Got to start on the node level if so. Doesnt seem like there's a good value to use in the resource selector so there's some options that jump to mind * Custom SWQL alert, might need to JOIN, this may not display in the resource depending how…

Down is a status, reboot is an event. (-Has Gone Down/come up is also an event sometimes) Probably the combination of polling time + alert calculation time + smoothing time + Warning/Critical Status time (say if it responded to some pings over a cycle) > outage window. Increase those frequencies if you need a faster polled…

Use the latitude and "longitude (world map)" variables rather than a custom one to cut the complexity. Script with the SDK to read your source SQL, then loop a query for all devices that match whatever's stored in your DB, returning the SWID then loop through the SWIDs updating properties including lat and long.

Seen a message from MapQuest acknowledging the issue now

I'd say that formatter's not doing what it's supposed to. There's loads of ways around this, I'll throw "Join the Status table" into the mix But that's the point of the "Data format" "Orion Statuses" thing really.

"So it was just a case of adding the SolarWinds Node Variable (${N=SwisEntity;M=Node.NodeID}) to the end of the SQL statement?" Pretty much (though wasnt 100% sure that's what you wanted, and had to go check my environment for a custompoller to get the formatting right) Best thought about like: In order to give contextual…

The problem is that "downtime" in generated later on than it needs to be to facilitate the CASE. I'd probably go subquery as KMSIGMA mentioned. Alternately you can stick the logic that generates "downtime" in the case statement or just use CASE WHEN LastTimeUp IS NULL

$200 + tax

It's a cisco router that does IPSLA where you're reading IPSLA from it. It'll probably be a big cisco switch if you have one. A core or a internet switch.

There's a recurring schedule manager installed on the server, it's a faff and you should back it up as some upgrades can mess with it. It works though. Alternately you can set the alert logic with an OR Node.Caption = ThatThing AND Day = ThatDay, which might be easier in a custom SWQL than through the UI, havnt checked…

Maybe add a unique thing after "triggered" in the alert so you can find it (or use the trigger ID) then case-statement out the SQL You've got the object ID already so that should be dynamic enough right?

VPNX: ${N=SWQL;M=SELECT Status FROM Orion.NPM.CustomPollerStatusOnNode WHERE AssignmentName LIKE 'sdWANStatsvPathState%' AND E0.NodeID = '${N=SwisEntity;M=Node.NodeID}'} Does that work?

@"HerrDoktor" @"sadiqsul" So either Mapquest has changed some, is down for this feature specifically, or solarwinds HQ may need to renew this API key Had a little check on the mapquest dev forum and it's pretty dead. Didnt see a good contact number yet. Might need to make an account and have a play...

@"sadiqsul" if you open a page with a map on it, then press f12 and go to the network tab, then refresh. Can you see a failed call to www.mapquestapi.com/.../mq-map.js Curious about if we're all using the same mapquest API key or one per instance and if that's the broken call universally

I see a mapquest/SDK/leaflet api call in live too, so I think OpenStreetMap might be a red herring

Did you find anything so far? @sadiqsul's message above implies support are still referencing MapQuest too

These are all fine for me, issue persists though. How about you?

Macros really care about the 'home table' which is like whatever is in the drop down of what you're alerting on. So if you're alerting on "Node" you need one answer, and if you're alerting on "custom node poller" it's noticeably different, and the same for the "custom node poller current status". What're you alerting on?…

It's also worth mentioning this leaflet page wasnt visible before, it links to the site of a ukranian library host, who seems to have having war-related issues. Could be something that needs a patch

I've got this in two separate environments with internet access, something wide happening. Mapquest homepage map looks fine Any query to troubleshoot?

Hi Sara, We could use a pathway to renew certificates before they expire, this doesnt seem to be an option currently as far as I can tell.

I think there was a thing around credential handling around then. What's the error specifically? Do recommend support ticket and upgrade too.

Not really possible at the mo

Happy new year! I'm a bit thrown off by "host", it sounds like you either want NodeID or EngineID, but I suppose if these are virtual routers it could be a virtualhostID too. I'd expect each of those to be available with just a OOTB macro, but if not available the custom SWQL version would probably be in the format of like…

You probably want a support call for this one as it could be any number of performance or bug-type issues. There's useful logs and queries for what's bugging your sql server. Could also just be needing more resources. Start a call with support, create/upload a diagnostics file while you're on hold, and check the My…

Note: Good luck for new Microsoft stuff it's a nightmare.

Big question actually. I tend to do a google for "$thing Swagger" or "$thing api reference" Once you've found a document that lists the endpoints you'll have the answer to your question, but actually nothing will work, so then look through said document for "Auth" or "getting started" or simmilar. There will be a process…