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

This is the way

I whacked up a test or two that looked ok but didnt do the math, so yeah you might be right There's a lot of classic graph-type things, and I think many are considered a bit depreciated, but there is a table somewhere (I posted on thwack about it, but long, long ago and I'm not sure i'd find it again) listing off the…

Feels like a SAM powershell one. Find a query that lists this specific cert, then find the property on the result that contains the expiration. Format a short string on the cert details you care about, that's the message Format the days remaining as an int, that's the statistic Output the message stastic pair in a set of…

this thing? learn.microsoft.com/.../0ff3a848-e0a1-43ba-905b-e1895d941191

Surprised by the result, are you sure that selects all routers with EIGRP? But yeah seems doable, but on the fringe of what's allowed in the product A) is a WHERE or a CASE B) is a WHERE C) probably involves joining a subquery, but maybe there's a pure WHERE for it D) should be coverage in the alert logic, but you'd want…

I think you're trying to have solarwinds poll itself for stuff, I use this method. 405 sounds like you're hitting your target. Works in one version back and I'm completely confident it would continue to work on your version

I think on a perfstack chart, the "linear" transform does what you want On classic dashes I think something in SAM with trackdifference enables acts like that but I dont know how you get there from where you are

@"Chris-S" whats this do for you? select distinct(n.caption) from orion.nodes N left join (SELECT n.nodeid FROM Orion.Routing.Neighbors rn JOIN Orion.Nodes n ON n.NodeID = rn.NodeID WHERE rn.ProtocolName = 'Cisco EIGRP') e on e.nodeid =n.NodeID where e.nodeid is null and n.vendor like 'cisco' That aint it, but like,…

This is a fun one We want some right joins I think Do you have an example from the routing.neighbors table of a live issue?

I think what you're thinking of, other people might use the phrase PKI as a convenient search term Hard to tell though There's a few certificate monitoring things knocking around on here. In pratice it's rarely straightforward, there's always more certificates than you think and a large percentage of them dont matter What…

This is probably hard to answer in forum posts, needs eyes in your environment really, would start with support and dig in with some testing while that starts to play out, maybe discuss some more specific aspects. The sort of stuff you'd want to see shouldnt be pasted on the forum really. You might need to look into the…

Your question or someone else's? bit marketing-ey. how does one ever tackle complexities other than by doing stuff in that space really?

I dont think those commas are valid

Aah I was hoping something like that concat would do it in the same cell. I'm not sure I'll have a chance to play with this for a while, but if I do I'll post back some findings We are probably in good-feature-request territory I think icon on it's own column does work fine though

Or if you want the group name swap in the group name property instead of n.caption

Something like this SELECT DISTINCT(n.caption) FROM orion.containermembers cm LEFT JOIN Orion.nodes n on n.NodeID = cm.MemberPrimaryID WHERE cm.MemberEntityType like '%Node%'

It's possible to script up a remake-this-for-x-sites action, not super straightforward, but doable if you've got 1000s of these to do

Got a filter on the page or on each element? I'd assume on the page If the hardware stuff is available, but not visible, probably got to add to the filter If the hardware stuff isn't available, usually a List Resources, if it's not there and it's not actually a VM etc (as in, doesn't have hardware in the first place) those…

I've thought about writing something up and never quite got there. The best distilled bit of advice I have is that Macros are Positional- As in, they say "Start here, look for property X" or "Start here, go up/down one, look for property Y" As such if you move a macro between different layers in the DB, it's directions can…

I think you can only really infer it to some extent unless the firewalls help out If you netpath between a startpoint and and endpoint, with 2 firewalls inbetween, and the data stops at position X you can guess that the traffic is dropped at X+1, but it could be that firewall at X+1 doesnt allow some telemetry but does…

In some other tools this would be closer to like SELECT STATUS FROM THINGS, in solarwinds this is more complicated, just a tradeoff. It depends what you care about really. If there's like UDT in your environment in a big way you'd want to add some port stuff. Maybe Compliance or somethat that isnt really a status. In a…

You want the count of Elements not components (see settings -> polling engines or something like that) This would be a really big query, it'd probably be like SELECT COUNT STATUS FROM X GROUP BY STATUS UNION ALL repeat for every table you care about Maybe run it like once a day overnight or something unless you need to do…

This is a remarkably simple workflow for something that's been a total headscratcher before Hopefully a fair summary is something like "Make a perfstack, locate the ID, find/replace with an ID macro"

And it has data? Could you screenshot?

Got a direct answer to a direct question on this a little before 2024.2 released, which was that documentation is coming, but they werent satisfied with it as a feature yet so it's only really half-released, and docs would follow when it's a bit more ready Please post what you've got so far though

Very much same, one day we'll reach the fully auto promixed land haha

Can potentially set those via alerts too ;)

Agreed! (and kinda hinted at in my other comment)

Also, there is a custom SQL widget, but it's not the one screenshot

You can do a SWQL->SQL conversion in SWQL studio by appending "WITH QUERYSTATS" (or PLAN), but there isnt a straightforward SQL -> SWQL converter partly as that changes version to version