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

2 initial responses - 1) Everything below line 16 is a bit sus, where possible try and stick to one-liners 2) Are you testing in the Edit Script section? You need to test there on creation so that it generates a "socket" for the other test button which i see in the other screenshots posted

Come to think of it, in additon to what I said, if you've got a api call which logs in, then that as a component works well. The browser may use that stuff to login behind the UI anyway

In addition to what jklundy says, you can also have a powershell etc script which can perform a bit more browser interaction, or you can also use SWO/Pingdom etc

I dont believe you can maintenance a group, you'd need to maintenance mode all the children

Good correction ty

I also suggest dependencies ;)

Certainly possible. Usually NCM statuses would be like Job statsus, Compliance, etc. the Platform Core/Node status is probably what you want SELECT whateverYouWant, n.caption, n.status From Orion.nodes N Where N.status in (2,3) Or similar using the graphical editor There's almost certainly a OOTB report along these lines…

The endpoints are all listed in the swagger. There's no difference really between /query with SELECT etc From Orion.AssetInventory and /assetInventory

You CAN do this via automation, it'd be probably a triggered script in an alert action that feeds in the siteID to a script ready to receive that HOWEVER, i think you're trying to setup dependencies from scratch, dependencies are probably what you want, you'd set each site up as a group, and put your uplink router as the…

Should be fundamentally the same, I dont see another "NodeName" column in your query, I think you want Name or Displayname on line 8, and your underscores are in the wrong place on line 9

the GET /query one is what you want, after that it's a SWQL query use SWQL studio if you dont have it already to explore SWQL, you can search for "AssetInventory" etc

I think the limit tends to be on logs per second, which is like 1k + bursts above

Not as of yet, but I'm looking to start using ansible shortly. Dont have much network kit i could operate on though.

I'm sans solarwinds for a few days but this is the sort of thing i do a lot, if you're still struggling later in the week/early next week we could have a chat if you like

Hi Boricua, This is doable, and ultimately will include one of two things: A custom macro using FOR XML PATH to grab all the components. (There is a feature in the works for STRING_AGG in SWQL but it's a way off) The OOTB components-with-issues macro You should use the 2nd until you get the first working. The 2nd is fine,…

My guess would be other features took priority, I don't think there's a fix from our side, but it could be an interesting thing to work on replacing

I'm on holiday at the moment, if you havnt got it working by next week ping me You can join on anything that matches, Bob's suggestion should work, but you could have a value on one part of the join pulled out of the event text or whatever using a subquery

I can't check right now, but I guess there's no event currently? (Could join to it with vol id around min(vssize) possibly)

I don't believe you can use CAST but otherwise that looks OK at a glance

It's super easy, takes 2 mins in the UI, don't worry :)

This is a place the product really needs a patch There is an article on here somewhere describing adding extra limitations in via the DB Last I checked you needed to do one limitation per "Core table", so you could select some of your nodes and their children, some of the arrays, and another thing, and then the UI caps you…

Built a few custom ones in the past to answer the 2nd half of the question

Not sure if there's a way to add color in a sql query box, it'd need to be like [_ColorFor_x] or something You can do it in a custom table element, by using CASE with HTML formatting and enabling HTML on the column it results in I don't see the 'DELAYED_TARIH' column in your table, I'm sure it's a language thing i'm not…

@"jameslindsay" thats the checkbox i was referring to in our chain, thanks bob

I wont be able to test for a couple weeks, but when i can, if i remember, I'll post back here Still got an active problem or problem solved for you now?

No, when you're in an alerting trigger action or similar, on the variable picker there's a checkbox for custom swql/sql You can do most stuff with that (albeit with difficulty)

I'm going to ignore the varbinds method for the moment because I cant refer to it Make a custom SWQL Macro, something like SELECT TOP 1 SUBSTRING('${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage}', 15, CHARINDEX(' ', '${N=OLM.AlertingMacros;M=OLMAlertMessage.EventMessage}',15)-15 ) FROM Orion.nodes N Freehanded that,…

Got some sanitized example text you want to pull out of some other sanitized example text? Usually i'd jump in SWQl studio but i'm without it for a few days at the mo

I've done this, i think macros in Body would be very useful I'm sure i've had macros working in headers before, so that's odd to me, maybe i'm wrong. you can place a header in the URL bar so if that doesnt work at the moment fixing it shouldnt be a functional change

You can wrap that macro in other macros if you want to snip stuff from it, see string functions on here: github.com/.../SWQL-Functions You can also use varbind macros to pull specifics out, i think it's like ${VARBIND1} etc