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

Possibly too many dots between "Message/Statistic" and ":" Maybe replace with a hyphen or something.

Lotta comments on this already, but seems like the main error is "vm" as in "vm.folder.name" is an alias that's not defined in the FROM statement, so it's invalid Usually engineers will do stuff like "Select x from orion.virtualmachines vm" at which point you can use vm.x to talk to stuff in the virtualmachines table.…

They used to ignore mutes, not sure offhand if they still do I've not found them to ignore an unmanaged status

If the list exists in SWQL/SQL (pref to the former) you can JOIN to it. Like: Update stuff alert: Select i.name, i.uri from Orion.interfaces i right join orion.list l on i.uri = l.uri where X Note in that example you cant make a custom table swql accessible so that's assuming you've got data somewhere. You can do this…

I once spoke to a solarwinds HQ person who mentioned a feature of this sort somewhere in the works internally, that said it was ages back and i've not heard anything on the topic since. You can somewhat take this further with scripted stuff of one sort or another, but it's not often very easy or a neat fit. Particularly as…

This is sage advice and I set the same eyes on unknown counts

I'm a big fan of the SQL user experience monitor. If you've got a couple metrics you actually care about you can assign just that and it's super lightweight and easy to read by comparison

It might depend how your're counting - If it's for license reasons that should read 50, if it's reported right out of the components table, ie how much data, then yeah that'll scale with the amount of DBs for sure

2023.2 very bad for this sort of thing .3.1's pretty solid Havnt tested .4 yet

It'll be a total reinstall at the front end, so potentially stuff to consider there around customizations. In SAM there's a "Legacy" setting that'll break some powershell stuff if you have it The script approval thing comes in If you have a bad certificate on website launch everything slows to a crawl "Platform" stuff…

Something sounds very off about this, but I'm not sure what. You should be able to get loads of appinsight out of a poller, and they should cap out at 50 components against licensing and what not each.

Reccomend using these But if you dont want to use those, the comparison should be the same really.

2023.4 looks to be imminent, otherwise yeah go ahead

https://solarwinds.github.io/OrionSDK/swagger-ui/#/ github.com/.../

Solarwinds alerts or Service Now alerts? SLW alerts arent in a JSON format, so you'd have to decide what you wanted that to look like and write an XML -> JSON. Can export to XML though.

Along with the something to pull the correct data down, you may want to wrap your query in a case statement or add a UNION such that if it finds no data it returns something valid, that'll stop the macro text from appearing on route to your receiving system

(SWIS itself doesnt allow Select * from, which would normally be the method)

In SWQL studio, this is open the table, or double click it. Way easier than every other method.

Why a floating point?? I guess you could do this in SWQL, in the drop down arrow in your screenshot you can export the current SWQL and add in the reference to your custom property but.. At the moment you're comparing a percent value, like 0-100, anything over 11% probably isnt going to trigger against a float, unless it's…

I'd structure this as 2 case statements: CASE WHEN DisplayName LIKE '%branch%' then 1 ELSE 0... , CASE WHEN SysName LIKE '%branch%' then 1 ELSE 0... Then Sum the results As a 3rd alternative you could add the case statement in additon to whatever information you wanted to pull CASE WHEN DisplayName LIKE '%branch%' then…

I'm not seeing an obvious syntax error, I guess it's just pulling blanks? Can you see the data you want to pull in these tables with/without the where condition in SWQL studio/SSMS (not sure you need actual SQL for this one)

Workaround 1 - You can usually swap a header into the URL Workaround 2 - Generate the equivalent in a SAM script monitor (or maybe a https monitor), there's a few templates around for this I'd be really surprised if it wasnt being transferred in the first place, feels more like there's a JSON contenttype coming in as…

Should be fine in the headers section. There's a few other workarounds available if needed

Any problem remaining? 

So in both of those the outer macro hasnt resolved fully, if I pull the code out it looks alright in SWQL studio though. In "mine" (top) it's not showing the "{SWQL"-type formatting i'd expect it to look like this in the end ${N=SWQL;M=SELECT top 1 SubString('2053846 RP/0/RSP0/CPU0:Oct 18 17:54:58.272 EDT: envmon[212]:…

If you're referring to checking if a TCP port is up, can do that with no creds so should be fine, quick rebuild if you needed to

Got a certificate error in the URL bar? That seems to translate to massive slowness

You'll be missing adding a poller for ICMP or similar I dont understand adding nodes via the API well, but mostly because I get confused and bounce off this stage I believe the Idea is to add a node, then add a list of stuff to do against it. Not sure how scans and stuff get integrated personally but there's examples…

Lets you tell the difference between "I found no problems because there were no problems" and "I found no problems because I didn't complete the check" Or visa versa, not sure if the count of Done in your case is a good or bad thing. Could do it with an if/then/else or whatever too ofc

I think you actually want something like SELECT top 1 CASE WHEN Value< 17 THEN 'Host Temp Cold' WHEN Value> 27 THEN 'Host temp HOT' ELSE 'Host temp is is Normal ' END as Icon, CASE WHEN value < 17 THEN 'BLUE' WHEN value < 27 THEN 'RED' ELSE 'GREEN' END AS color FROM Orion.HardwareHealth.HardwareItem hi WHERE (…