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

To expand on your questions a bit There's a rest API, if you use it you'll end up using SWQL sooner or later for querying something. There are API calls with no SWQL though. 1/2 on sufficiency, on a technical level you need time and such as in my SS, or on non-technical level depends on your org i suppose. I think release…

https://solarwinds.github.io/OrionSDK/swagger-ui/#/ + SWQL studio from the SDK from the github is what you want Something like that looks like it from SWQL Not using ansible or ipam much at the mo

Glad to be helpful! You if you find the variable picker ain't quite enough, the "positional" macro thing should help ya if you do need to guess at syntax or write custom stuff, it'll probably come up sooner or later

There's a value called nextpoll in the nodes table, when it ends up in the past somehow its a sign scheduling has got messed up. This usually causes grey's from the nodes table down

Not offhand sorry

if you're talking about placing a graph on your email, it's easy in low-security environments, and very hard in high security environments

Did you get a cause? Feels nextpollinthepast-ey to me Would guess that, then corrupt jobsdb, then maybe that setting for legacy powershell if it were all powershell, looks node-layer though.

I believe these would be the calls to invoke, probably schedule then getlist/importselected

Nah you can do that full-auto-no-code optional 0) add some discovery with auto-additions of nodes 1) create group 2) populate group with dynamic queries so it auto-updates 3) assign template/s to that group You could add a couple extra steps if you wanted to

In tool this is via groups usually in api you can do stuff in this space, it can be a bit hard, i've got examples of prior work and a todo item

Oooh this is cool, we've speculated about someone doing this but never gave it a try personally

You can and that does mean you can skip a bunch of steps if it's running against an agent device (if you've got a mix of agent/wmi keep this in mind) Next thing you've got to figure out is if you're wanting to store the script on the remote servers, or pass it over from the SLW box, c$ for remote and c: for local etc.…

You want the elements per poller closer to 10-12k really, could get a APE CPU cores should probably be closer to 12, could upgrade the box Could go much higher in theory but I dont recommend it. You could call support if it's spiked and nothing's changed Could be virtualization issues If everything works fine and it's not…

Somewhat posting to track the conversation, as I'll probably need to do this in future The settings that seem missing is Agent-initiated or server-initiated, and if agent then the poller IP, which is probably 2. in the screenshot above

Yes, there's another maps widget, search "Map"

Security makes this a real pain to answer - If it works in one env for security reasons it may not work in another. Bob's response is a good format for a thing that works generally, but I find remotePS is shutdown or partially shutdown as default so maybe you need agents or something and it all changes the answer.

You can add charts and icons for sure I believe you can colour text but I dont think you can colour backgrounds. Might need to be fact-checked on that though

dupe of thwack.solarwinds.com/.../collector-service-consume-excessive-cpu

20k elements is HIGH The collector service is the one that does stuff, if that's consuming 4 cores for 20000 things it's probably doing a pretty efficient job

Can confirm, I needed to talk to their support, some of the api endpoints approach billable status depending on rate

I've got some stuff that imports data from a cisco api into SLW, but no idea about the EoL stuff. If you've not got internet access but you're comfortable with the other half, the solarwinds swagger or powershell module with set-swisobject is probably where you end up @"maliron" 

I did this the other day and I do recommend! What Bob's suggesting gives you a count in SWQL for NOW, so the problem is committing that to the DB over time You want SAM for that really, not sure if you could do it with just npm without getting really hacky. What you want is an account with minimum permissions, and to use…

Might be able to tweak it in the DB outside of what the UI lets you set, but an admin could then give themselves whatever rights they want so it doesnt change much really. Once you've set an agent running though you dont need the account again, so that could be fine (from the chain with Stuart)

That route works for more complicated stuff but I was trying to also give you a nudge in the direction of the macro picker as you can find it in there without having to write anything custom. That said it's good to understand why stuff breaks when moved between alerts on different objects too, took me a while to figure it…

There's classic and modern dashboards, in either there's a orion map widget, and in classic there's also an NTA maps widget ie. Classic - Old maps - new maps Modern - new maps

Looks like we're trying to generate a modern dashboard link with a filter based on a triple condition The first subquery feels like it could just be in the CASE statement using orion.nodes instead with a bit less complexity. The '%'+ X line is really weird, it works but it feels wrong. '%'+n.caption works for example…

Cool query Could you go over this bit again in a bit more detail? " I want it to check the status and the campus ( are down ) BUT not to not show the campus as down - if the comments equal comments1 or team responsible equal teamA or if the alerting node room is none alerting noderoom "

Arrived 10 days late, struggled to follow you a bit, but it's literally just powershell with a wrapper so the differences will be in presentation and environment not execution if that makes sense. The Write-host lines tend to be the important ones, I dont recommend splitting up the statistic and message parts, they're a…

You can get location filled in from AD to windows servers to the location attribute OR you can make a custom one AND there's a lat and long attribute that you can upload to

Can always in theory add any random api call to an api poller/sam template if you really need to