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

It's definitely possible, I've got a dashboard that does similar. If you get an error or your data isnt the right shape or something let us know what that problem is, because you've got some device-specific stuff it's hard to tell what you're having problems with

What problem are you getting with it? I usually use a hex code for the colours. You probably want to output status codes or "warning/critical/up" for icon Not sure why the count at the moment, I'd guess you'd want to output the temp somewhere though., just value perhaps. Usually count wants a GROUP BY under WHERE.

Probably worth sticking the api call in a try/catch with a specific error output into message.results and message.statistic, and an exit code in that bloxk and after the write-host lines

Try removing the doublequote (") and surrounding putting a single quote before both $'s and after eventmessage) SELECT top 1 SubString('${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage}', 0, length('${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage}')) as minus1 from orion.nodes n If the doublequote you've got on…

Tell me more about the flask route, I've not touched flask, I recognize all the components but no idea where you put em For the macro route, if there's an insert variable button in some solarwinds field somewhere, click custom swql, then place ${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage} where I've put "caption"…

The extra space is really suspect, because often if you add a variable, it comes with a space, so i'd guess first that "sylog": "${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage}" might be "sylog": "${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage} " in live, if not that's weird. Potentially you could wrap a that…

Worth mentioning that the variables selection screen has aweful performance times, in which case linking more stuff may not be ideal. Worth a big refresh

Write-host $error[0] Or whatever sotherthing/things you want to output (you're getting into something kinda deep here) Sometimes I find it useful to sake a generic output block - ( Write-host "Statistic: $statistic" Write-host "Message: $message" Exit 0 ) -and move it up and down the script to help debug. You dont need to…

I had a top 1 on there

@"Rachel.Davidson" SELECT top 1 d.Clusters.DataCenter.VCenter.DisplayName from orion.vim.Datastores d where d.DataStoreID = {put a datastore ID macro here}

If it's set to remote host and you're testing it locally on the polling engines that test doesnt sound right. the equivalent would be invoking psremoting on the remote server from the solarwinds server in a script block, if so you probably also want to pass in creds and potentially change the variable output around a bit

I did this once having failed to find the 64bit toggle, it's not worth it Use this block instead if (-not ([System.Management.Automation.PSTypeName]’ServerCertificateValidationCallback’).Type) { $certCallback = @" using System; using System.Net; using System.Net.Security; using…

2) Assign the recording to a player -Go to solarwinds, wpm settings, manage transactions -Assign to a player

These are such a pain to prove one way or the other I've moved to mostly referring to the vmware alarms if that helps at all. There's a model you can traverse for the hosts which can help explain but I dont remember it's name and it's a PITA

Got the impersonation and remote/local settings the same?

This is on the my todo but i'm probably not getting to it very fast. Done a couple azure integrations, they've been quite hard. Easier when you've got proper permissions or someone to ask who's worked with the azure apis before. Big recommendation for using a language model

Once you've got working api calls, the next thing you want to think about is what you want the integration to do Checks -> SAM, either API poller or script Alert output of some sort -> Https action, headers in the URL Something bigger -> scheduled task with SWQL probably, or could do a SSIS thing, whatever there's…

There's definitely stuff of this nature around, probably in success centre, but while I dont have these to hand 1) Record stuff -Log onto a solarwinds server or a server with the player installed -Log in with an account -Search WPM in the search bar, or should see a new or an old recorder. Use the new one unless you have…

I've done this in solarwinds in the past, but dont have a a boomi environment now. You want to start with talking to boomi folk really, then replicate that in solarwinds

NTA or Orion Maps? I think in both cases it's roughly "add the other interface on" but OM is a bit more fiddly about it.

swql in emails is fine, if it's not resolving the macro it probably errored or returned nothing, it needs to return something to be valid

There's a few dynamic URL places (perfstack, modern dashboard filters) but that's a tough ask. In theory you would build the URL and then assign that as a link. Or you make the links available in another way (say with a bunch of pre-built summary dashboards) and produce those links Or you make these as actual groups and…

You probably want a component monitor that checks the count of processes you care about, then just alert if that's down/critical (above the 10 threshold) Otherwise you'd have to do some weird RIGHT JOIN or INNER JOIN stuff

I stand corrected!

That would be a pretty unusual polling cycle. The Performance poll is the one that gathers most of the useful stuff, a good place to check is in the DB. 12 hours sounds more like a scheduled task of some sort, you can probably line up the auth log on the vcenter with the accounts in use

Stick your query in here, then append to the URL after the = www.url-encode-decode.com/

Sev 2 is definately critical in my env. Odd.

Did they say if my guesswork above was in the right ballpark? (or did any of your guesses get confirmed?)

Sev 3, code snippet below: CASE WHEN ao.AlertConfigurations.Severity = 1 then '<b><p style="color:Orange">Warning</p></b>' WHEN ao.AlertConfigurations.Severity = 2 then '<b><p style="color:red">Critical</p></b>' WHEN ao.AlertConfigurations.Severity = 3 then '<b><p style="color:orangered">Serious</p></b>' WHEN…