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

If you dont want to dive into the SWQL, here's a couple options: 1) Use a filter over whereever your current availability metric is, to select only the stuff you care about 2) Add stuff to groups, use the availability numbers from the groups (doesnt backdate though)

Ooh I like the Bucketing here

If you have good visibility of the virtualization layer, and that accounts for everything, a nice report is VMs that do/dont have their detailsURL like '%N:%'

in SQL it's FOR XML PATH In SWQL this is a right pain, you can use a combination of JOIN, subqueries, and CONCAT. I call it the poor man's Transpose @"KMSigma.SWI" put some content together on this topic recently. You turn it from NodeIDName12345KB319998612345KB401341812345KB4049065 to (can kinda skip the joiner bit given…

Tried the reliable one across a wider range of stuff and I think it may actually be that you can vary the image format based on web player. Maybe. If the image format it's saved in matches what your macro is happy to accept it can work. Imagine format seems somewhat irregular though. It may be possible to match em up in a…

you'd use a SWQL macro that had a CASE statement that'd turn the status into some component of your banner If the banner is an image, you could have it be CASE WHEN x.Status = 2 then '/redbanner.jpg'.. WHEN x.Status = 3 then '/orangeebanner.jpg' If the banner is html formatting, then same deal but with a hex code for…

If you havnt already, got to make sure you simulate on a failed transaction as i've got a status = 2 in there. If you're getting a broken link even on a failed transaction maybe there's another image format change. Try the Thumbnail one first.

@"KMSigma.SWI" Yes, this is what I was thinking but not what I typed

HOUR(GETUTCDATE()) and it's friends MINUTE and DAY are what ya want

Somewhere I've got something that's halfway between those two. I think I broke down a bit when it still wasn't received right on the other side

Code that worked a year ago for almost no time at all and which I think may be environmentally dependant. The screenshot one below is better but they work on the same principle. Screenshot: <img src="data:image/png;baseq64, ${SQL: Select REPLACE((SELECT TOP 1 Screenshot FROM [dbo].[SEUM_StepResponseTime_Detail] where…

@"weston.hood" can I trade that for a PM about the chat with the Dev?

@"weston.hood" Right this one does the thumbnail. Trying to rememeber exactly where I got to with the full size one, it's a dramatic understatement to say I had problems with the full size one <img src="data:image/png;base64,${SQL:SelectREPLACE( REPLACE( ( SELECT TOP 1 thumbnail FROM [dbo].[SEUM_StepResponseTime_Detail]…

Got it working now but that's with quite a lot of asterisks. The last version I made stopped working randomly and it was to do with the image format changing without a known reason for the change (perhaps it could be like to do with image size or something) I'll fetch some code. Previous code from me is in this forum. It…

Oh good lordy this is harder than it used to be. It all comes down to security stuff and where it's being received I wrote some code for embedding it. That still gets declined by some things and can use up a lot of email space. Otherwise you can link to a location but if it's in SLW it's got to follow auth steps. So like…

In addition to the knowledge bomb @"KMSigma.SWI" just dropped, you may want to consider alerting on something like [errors+discards as a percentage of speed] for example. Doesnt have to be that specifically, but the idea being that you want to set a threshold that scales for different device types and any number in a…

Probably not the best forum to get this question answered This is something that you want 2 alerts looking for Probably want to talk to support Try a bulk poll-now, see if you get errors or successes Can reset collector and jobs services or the local collector jobs file other people's suggestions are correct here too.…

Stopped doing the properties as in "I've got a new method I prefer" or as in "Someone else looks after them"?

You could RIGHT JOIN to that using an ID from the subquery. But this also looks super inefficient as is, maybe cut it down with what the template is you're looking for or something first

So I re-register? I found this but it looks full paid

I've got 4 SCPs currently (so i guess i dont need to do the registration step again?) how do I sign up for the beta? Is it through PSI? I did look for a link, I didnt find, likely overlooking something obvious

Is it stil running? Never saw i the first time round

Totally doable, Bob's sent you down the right path

Hows the beta work?

Aaaaaaah ok, right, in that case scratch most of this and just leave the "sounds good"! The X-Email thing is a really neat solution I wouldnt have thought of A problem i've had in the past with related stuff, is when either a email-breaking character finds its way into macro, or when the macro fails to resolve (for more…

It may be too late in the day for me, but I read through and was like: Sounds good, sounds good, sounds good, Hidden ASCII?, sounds good, sounds good, Hidden ASCII?, sounds good... wait what was the question?

Just got to drop the first 2 lines (if you were trying to do something more complicated, you can JOIN after the forced section, though it's barely supported)

Swagger UI (solarwinds.github.io)

ADDHOUR(-24?

I dont understand what you're doing from the description, but you can 100% filter on two things at once