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

Not sure how you got in this state. Which installer did you use specifically?

Did you use the same DB as last time?

Simmilar to what Kevin said, there's some stuff in the containers table for maps, but it'd be hard to work with

On install it should prompt you to set a new admin password then to use that Once you're in you should have access to NPM and SAM pretty much automatically assuming you downloaded a version from the last year or so If you've not been able to get in at all, probably fastest to reinstall

Upgrade process was fairly smooth. We had an issue with database maintenance but not a major one

Yes, Not much, in that order as mesverrum said, it's technically doable but anyone's game

Edit map, select the node, hit delete

Guess 1: your service account got expired/ocked/whatever, though ysadmin suggests not this Guess 2: firewall change somewhere broke the port, presumably you'd mention it if this was the case Guess 3: Scheduler fault. Jobengine service died or collector service died or jobs db for corrupted Guess 4: ephemeral port…

I pulled this example from one of the top search results: SELECT TOP 10 Convert(varchar,TimeGeneratedUtc)+' '+Message FROM APM_WindowsEvent_Detail INNER JOIN (SELECT ID as CID FROM APM_Component WHERE ComponentOrder=1 and ApplicationID = 728) CID ON ComponentID = CID ORDER BY TimeGeneratedUtc DESC for xml path('') In this…

You can kinda do almost everything in solarwinds to some extent so it's hard to answer questions like this directly. You can spin up a monitor in SAM for basically anything in azure. Not to say it's always easy though. I dont think there's anything great to interact with it in NPM, but you could monitor stuff through it,…

Search in here for "FOR XML PATH", you can export a table in a SQL macro but it's not very straightforward. Something that tends to make things easier is to have a window of something like -1 day to +14 days (dial in based on your scenario) and report the worst in that window. (WHERE, TOP 1) That makes the output easier,…

Add em as external, then switch

Dynamic groups seems like a hard way to solve this problem. (and one that wont scale nicely as the number of hosts increase and auto vmotions occur) You want less emails when a host is down right? (I'd argue if they're all down you may just want the emails tbh, vmotion should solve that problem and if it doesnt you've…

As @xam mentioned, pulling a group in a macro is fine, but you will probably have multiple groups per device sometimes If you happen to just have one group per node you can do ${N=SWQL;M=select m.Container.Name from orion.ContainerMembers m where m.MemberPrimaryID = '${N=SwisEntity;M=NodeID}' and m.MemberEntityType =…

Select concat(c.[MediaType], ', ' , c.[Total], ', ' , c.[Atm Branches], ', ' , c.[on-ATM Branch]) as smushedtogether FROM ( previous query here ) as c

Give it a few days, it'll get emailed over. There's a certification email box for chases if need be, you shouldnt need it though

Thanks @"jm_sysadmin" for looking up the hard stuff, @"ec.bryantu" you can also stick that data into a solarwinds event log monitor and I can confirm it works fine without needing to write any code

I think that hits all 3 of the last suggestions actually

Possibly c: turning into c$ for remote machines Possibly that the system account wouldn't have access to remote machines Possibly worth putting some logic on the script so you can debug where the failure is What's the script?

A file-ey protocol would probably be easier than an SSH one, sessions are painful en masse

You can do it, but there's some gotchas. I dont have a script handy. There's a table that seems to function as a easier-to-display version that really looks like the thing you should update, the thing to actually update is the uglier, harder to find one. Otherwise Steve's method is great, and incombination with…

The easiest route is probably via an event log monitor against all 3 There's a SQL route but it's awkward if they dont agree with each other You can poll the AG for hostname too but awkward to do stuff quickly off that

I'm suspicious that it's the action that's placing escapes rather than the macro. It if were the macro you should see it in your first SS. If not you could hit it with a REPLACE If so, you could try placing a Post.exe doing curl or invoke-restmethod on the server that accepts arguments, then trigger it with a Execute an…

This is fairly simple if it's a single alert for a single extra metric (you make a custom macro for multicomponentstatistics where id 2 or whateever) This can be fairly painful for a generic alert that needs to operate with different objects and data structures

Probably best to design your own solution off Mark's template. Stuff like credentials and network structure can change how this stuff needs to work Based off your title you probably want there to be a script that accepts an IP or hostname as an argument, and potentially another one for credentials, then does a clean on the…

thwack.solarwinds.com/.../118017

Select top 10 n.detailsurl , n.caption from orion.nodes n or Select top x case when x then 'thing i want listed' when x+1 then 'thing i want listed two' else 'thing I want listed three' end as URLS , case when x then 'thing i want listed' when x+1 then 'thing i want listed two' else 'thing I want listed three' end as links…

Yeah as rows sure, or just make another column

Oh, didnt think that'd work for you, ok - Table widget, then you select a thing for text, and a thing for the link. Example of of a random link: Select top 1 'Click me' as lable , 'https://google.com' as url from orion.nodes Then that can go in as a column like so, where here i'm linking to a service called OME, i've set…

to confirm, maintenance being muted or unmanaged (or like vmware maintenance mode)(in your instance)?