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

bump?

Roughly the format you're looking for is a SQL/SWQL macro using the traps variable and performing something with CHARINDEX/SUBSTRING etc CHARINDEX of the quote at the end of ""label":"" minus CHARINDEX of the end of the hostname. Substring that out. You'll have to figure out what the end character is. The Following quote…

To get a trial you need to run the regular installer, and its under the scalability options

[quote userid="270253" url="~/product-forums/solarwinds-service-desk-swsd/f/forum/94963/how-long-or-how-many-up-votes-before-a-feature-request-is-implemented/300107#300107"]thwack.solarwinds.com/.../wwwo [/quote]May need to fill in that ellipsis there

Is the slash after the hostname always present?

I started writing the answer to this as if you wanted an alert only if both the primary and secondary were down, on reread I think you just want an alert for the primary? If the primaries have a name format, or perhaps a lower IP of the two, or something like that i'd just add a custom property (perhaps even auto-populate…

CUSTOM PROPERTIES - Yeah no worries Non-custom attributes - Eerr probably a better day to do it. Hostname is a polled field I think so would reset, Caption isn't but can lead to confusion. If you're replacing IPs in caption with something useful no problem at all, if there's already a valid DNS thing and you're adding a…

Hi Matt, I agree this is an oversight not being OOTB. Got a monitor or two for this sort of thing: $server = $args[0] ##$server = "x" ###Block For: If primary then proceed, else unknown $SQLPRIMARY= invoke-command -Computer $server -Scriptblock { [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") |…

Just +1 to "I've used NPM like this before" NPM (in conjunction with SAM and maybe VMAN) is pretty good for servers tbh. I've always split out the alerting for network (cisco etc) stuff vs server (windows/linux/etc) stuff though, as the approaches to fixing it tend to be very different Could well be worth splitting off a…

I dont/didnt think you couldnt evalute macros like that in an alert definition. This'd be better placed in the NPM or LEM or platform forums really, not much connection to SAM The SQL macro is just trying to evaluate SQL, so removing the macro formatting would work fine, you'd have to join or subquery to the…

In UI this sort of thing is what you're after

Recommend making sure it works as a script first (ie remote to a good test server, get the powershell working) then getting it running in a scriptblock from the solarwinds server if it runs in a scriptblock you're probably good, if it doesnt you can probably troubleshoot the errors easier. Worst-case you can also just set…

Hi @"marcrobinson", I had a 2.6.x and a 2.5x in my env (the higher of the two stopped connecting so I'd not updated for a while) Fair dues! Confirmed working post-update

I'm struggling to get my head around what this is at the moment, that said couple possible directions to go: 1) [quote userid="274280" url="~/product-forums/the-orion-platform/f/alert-lab/94234/escaping-in-email-alerts-to-do-a-swql-replace---i-can-do-this-in-swql-explorer-but-not-email-alerts"]using that ${IP} doesn't…

There's a column in the Neighbors table called "IsDeleted". Know if your alerts looks at that? If no, and adding "AND IsDeleted = 0" or something like that clears it, that may be what you're looking for

possibly these bits in "update device template". If not these then probably something back or forward one page from here.

Send a report or SAML + 2FA login as a starting point

Oh no worries didnt think you were saying that. I'm hoping I can convince you to put a line up on github for AS/aliasing though, as it's got an impact to intellisense, and how the most-correct, most-sqley way isnt how it's presented from orion itself, I dont think the average user would land on the correct solution. The…

If you want a specific number from the UNDP rather than a status (some percentage utilization perhaps?), as a workaround you can set an API poller to run a SWQL query against your web server and monitor the returned number, then that number can be placed on dashboards

;)

Possibly something in the windows nic configuration settings? I've ran netpaths through vpns in the past, should be possible.

Followup question - In my SWQL studio if i use "AS" rather than aliasing or using lowercase "as" i lose the autocomplete dialog vs This is odd, and kinda discourages doing it the proper way. Or i've got a bug, not sure. Thoughts? (Note: "AS nodes" etc being the default format for the top line for SWQL alerts makes this…

Should be able to mostly just paste in the code above without edits 

Cool chart idea, might implement that myself. What problem are you having with it? I've got some non-stacked elements a bit like this. There's a cool calendar-type one on thwack using a customhtml element, and you can also add a SAM Perfmon counter against your solarwinds box to track alerts over time. Could do it as an…

This is a PHP question not a data question really, you've got the stuff out. Stackexchange or something would be a better place to ask. That said there'll be a JSON handling function you want to use here on $info to split it into an addressable array If you're just pulling a node ID you could probably parse the data by…

Might be worth sitting on this thread for another couple days, see if anyone's got a better solution. Personally i've had much trouble with the site-to-site VPNs in my environment, so i'm maybe not the best placed person to solve this for you. https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions…

In Orion Maps I cant see an option for vpn-site-to-site connections, however you can write a query that calls the status and assign that to an API poller tied to the ASA but actually polling the solarwdinds IP. That can be represented on an orion map and would solve the problem here at least. Which is to say: "Possible…

First write a script to deposit the payload you're looking to put in the DB Second add an alert action to run your script (External Program) when the event occurs Pass data into the script using arguments on the action. And in the script referring to the argument variables. There are obviously some complicated bits here,…

Hi @"Vaishna", this does essentially what you're asking for, however it's not quite perfect and it's a bit more generic Left Join NCM.Nodes ncm on nodes.nodeid = ncm.corenodeID WHERE ncm.LoginStatus not like 'Login Ok' and ncm.LoginStatus not like 'Unable to login to device : Timeout' i've got a separate alert looking for…

ADDHOUR(5,( SELECT TOP 1 EndTime.EventTime FROM Orion.Events AS Endtime WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5 AND EndTime.NetObjectType = 'N' AND EndTime.NetworkNode = StartTime.NetworkNode ORDER BY EndTime.EventTime )) AS UpTime,