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

Alert counts per Alert+Object pair > Per node Estate size growth per time is nice Best metric I ever established was "P1s avoided", though i've never been able to get that working again with my current employer

Try SELECT top 10 [Nodes].[Caption] ,AVG([Nodes].[ResponseTimeHistory].[Availability]) AS [AverageAvailability] FROM Orion.Nodes AS [Nodes] WHERE 1=1 -- so I can comment out individual AND lines below and not break SWQL AND [Nodes].[NodeName] LIKE '%SOLARWINDS%' -- removed 'SC' to match my node name AND…

(In general you want to use SWQL over SQL so that when the schema changes during patching your dashboards and alerts dont break)

I believe the answer is No, though if anyone figures out as way it'd be cool Doesnt mean you cant use the data anywhere though, but it rules you out of Modern Dashboards and some other stuff

FROM Orion.NodesThresholds I believe, but could be wronglook for WarningPolls, WarningPollsInterval, CriticalPolls, CriticalPollsInterval, WarningEnabled, CriticalEnabled, by ID

TOP 1 Order by time DESC (Maybe Group by thing.ID) On the node layer you can do stuff like this: Select n.LastSystemUpTimePollUtc from orion.nodes n It gets a bit more fiddily when there's more layers with different polling cycles being polled. Worst case though there should be a timestamp for anything you can graph, and…

Excellent response ty

Take an alert query you like, then JOIN to a subquery with this count in it, then order by 2ndtable.count You may run into problems when you have alerts which are further from the nodes table, worth thinking about

Ping from X =/= Ping from Y should be discussable with the team in question

Aaaaah no worries. I had somethign simmilar the other day - Removed the property and readded, cleared up the problem. There's one scenario that doesnt fit into the "reset something you had a weird bug" and that's if the CP name is an illegal one, I think SW tells you if you would create those now, but stuff like "function"…

Sounds more like an NPM thing than a DPA thing, or is this definitely DPA?

I'd probably get some small use out of a feature like that, would upvote if you raised it. Not super surprised the JS lead to some downstream stuff, I have such a hard time getting through email security for anything fancy. Are you doing the checksum comparison in the JS? Usually i'd try and bake that sort of thing into…

@"chad.every" Anything in the works to make this sort of thing more of a OOTB feature? (Or to help store historic text etc in the same fashion?)

Can confirm that works - Be careful though, use a specific read-only account

Without looking it up, either there's often a statusLED or something simmilar column that can be used, or you can JOIN on status to the orion.statusinfo table. I think statusdescription can have a little extra verbiage on there which doesnt allign to the filename. If that doesnt get you there message back (or someone else…

All metrics are possible [Fortunately|Unfortunately]

(Please ask away, i've not got a guide but i've given demos, hard to tell where people will get stuck)

If it's a number, you can use either an API Poller, or a SAM component, or something similar to commit it to the DB. I think this is a pretty uncommon action across the userbase but I'd bet it'd be used much more if it was straightforward For an API poller, you can search "Solarwinds Swagger" and you'll get the api…

You're looking for Groups, stick your key metrics for each app in a group called ~ AppKeyMetrics, it generates a status and history and whatnot automatically

That "reload the page after simulate" thing also applies to HTML, probably anything else shared with the website rendering it - There's probably a clean-code version that works every time but it's beyond me Could you share some of what you worked on?

Yeah, did you click this button? If yes and that doesnt work - Bug or broken link If no, that button, else you'd need a feaure request for a different onclick behaviour (i'd agree), or to build/use a different widget

Step 1: Make the thing it links to Step 2: Place the URL here

Not completely sure what you're after, but it's probably a combination of a few of these: - Generating Links, and applying those to the formatter - Generating Links which have filters or other dynamic things applied to them - Wait a patch or two for the drilldown widget, else there's a couple good writeups on here for the…

If it's not a count you want, but like a colour to colourize a modern dash element, you return 'FFFFFF' or whatever in your case statement END AS COLOR

Feels like you want a COUNT on there, but I'm not really sure what the intended result looks like

You can access with a Cert too, but not sure i'd reccomend that for this

"custom property name here" in the error - Feels like maybe there was some doubleclick-type interaction or something. Try again, should work ok, the feature itself isnt broke globally or anything. Would be curious to see how this issue gets generated

I dont think you count as new anymore if you've already got that together! Something like the below, I've switched to SWQL over SQL as that tends to be better long term Because we're using names not UIDs I've added a separate match for the hostname in case there's multiple vms with the same name ${N=SWQL;M=SELECT top 1…

Ah, you've stumbled across a reasonably hard one. Could you put some Sanitized events in the chain of the sort you'd like to link to their owner? Could you confirm that the custom properties are definitely against virtual machines not nodes?

Glad that's sorted One small note for why I left in one set of E0's: ( SELECT E0.VolumeSize FROM Orion.Volumes as E0 WHERE E0.Node.Caption = 'Node2' AND E0.Caption = 'VolumeName' ) In the subquery, E0 is actually defined in the underlined bit - I was trying to show that Aliases are still accepted, but that you do need to…