mesverrum · Observability Architect · ✭✭✭✭✭

Considering that the agent relies on info from wmi then it's not going to get around the root issue there if your wmi isn't working in the first place. Sounds like a serious struggle

When I am building alert integrations I normally build out several templates depending on the type of object I'm triggering my alert on and the fields that the receiving end needs me to send. Generally I do like to include all the Node information on my app messages, but you don't necessarily have to, it just depends on…

I just learned to do it through blunt trauma of smashing my head against the desk many times while doing these over the years. In this case you just needed to group up the Or conditions into their own block

Also the wiki for the SDK has some pretty decent starting examples. Home · solarwinds/OrionSDK Wiki · GitHub

The caption field never changes itself, that prevents it from removing changes you may have manually entered in. But there are sys name and dns fields that would update whenever discovery runs (30 min by default). Sometimes I run a report to see all the nodes where caption is not the same as sys name or dns to see if I…

I will say that ncm is not going to have the full range of capabilities that you would be able to leverage from something like hand crafted scripts and ansible playbooks. Like you mentioned, you primarily have to work with the existing saved configs so you can't just pick a series of if statements and run different cli…

In a few cases I have seen the synchronization between the the orion.nodes tables and the orion.vim.virtual machines get screwed up, and cause effects like this. The obvious clue would usually be when the nodeid column is null for the vm, so the IVIM side of orion says this vm has no related nodeid in the db, we should…

In swql the nodes custom properties don't live on the same view as the nodes themselves replace all n.customer with n.customproperties.customer and that should work

You have nailed the struggle. There is not really an accurate way to predict how many components an app insight template will create. You can ball park, for example I think each table in a SQL instance is about 30 components, on top of the global components for the whole server. So a db with 40 databases on it might…

select n.caption as [Node] ,n.detailsurl as [_linkfor_Node] ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node] ,n.ip_address as [IP Address] ,n.detailsurl as [_linkfor_IP Address] ,n.Vendor ,n.statusdescription as [Status Description] ,n.objectsubtype as [Collection Type] ,e.servername ,n.statcollection…

I'm not aware of anyone who does that level of customization to the back end of solarwinds.

Strange, you must have a different version than I do, but since it is complaining with that error I suspect this should get past it select count(t2.interfaceid) as Interfaces, t2.date from (SELECT distinct datetrunc('day',DateTime) as Date, interfaceid FROM Orion.NPM.InterfaceAvailability ia where datetime >…

I would still suggest doing an snmp walk or just adding that interface to solarwinds to see what it shows up as so you can get a clue where to look in your router configs to try and stop them. Looking at the screenshot it appears that over 7% of the flow data hitting your server was from unmonitored interfaces so I…

I'm still hoping that Solarwinds would just convert NTM and Atlas into plugins for Visio. That way all the basic stencil and drawing program side is already handled so they don't have to reinvent the wheel on that kind of UX stuff and they would just focus on how to tie objects back to your orion database. Visio already…

oh yeah, it slipped my mind that you have to add them to the 'group by' lines as well, but the suggested SWQL queries above are pretty solid as well if you want to give the a go.

I apologize for my SQL illiteracy but hopefully someone can translate this into a specific command for you to run against the database. In SQL you'd be able to select all Interfaces.adminstatus=0 and then within that selection I believe you change Interfaces.Unmanaged=0 Definitely want to have someone more familiar with…

This is how I would modify my standard disk volume dashboard to show 5 specific drives, just replace my 5 examples with your volumes' fullnames/ SELECT n.caption as [Node] , v.Caption as [Volume] , round(v.VolumePercentUsed,1) as [Space Used] ,round(v.volumespaceavailable/1073741824,1) as [Free GB] ,case when…

And thinking about it, you probably want to do an or condition regarding the errors, since you would very rarely have inbound and outbound errors going nuts at the same time

So the first part, the select, is picking which columns we want to see, so if you want more info just add it to the selection. In cases where there might be two columns with the same name you have to specify which table you want it from. Because i'm lazy about typing I put an alias on the tables to make them shorter, i…

That would also work too.

With O365 I have had many client who had an on prem mail relay server that just punts things from their internal system out to the cloud, such a thing may be in place at your org.

Check out this powershell example OrionSDK/CRUD.AddNode.ps1 at master · solarwinds/OrionSDK · GitHub

Not exactly, but you can save them and share them out to others, which basically makes them their own chart based dashboard

So SWQL is an abstraction layer away from the actual database, it partially matches up to some tables and views but has a lot of things that you wouldn't see by looking directly at the database. I found that the easiest way to get familiar with it was to install the SWQL studio from here Releases · solarwinds/OrionSDK ·…

Given the error that access to orion.nodes is denied it makes me wonder, are the credentials you are passing for your script full admin or at least do they have manage nodes? Is there any kind of account limitation at play?

If the passthrough is working correctly (usually it depends on your browser) you don't get a login prompt, it just automatically logs into solarwinds.

I generally use the custom query resource for these, that's the only place that the iconfor and linkfor functions work.

Well I don't believe sql has any existing counter for numbers of errors found or repaired in DBCC processes, so therefor Solarwinds can't pull the value of that counter directly, so yeah you are going to have to script it one way or another. If I was going to do this I would probably use a combination of posh and sql…

I always suggest anyone disable the ootb alerts, they are just recommendations for a starting point, not best practices.

Yeah, you basically are correct, you have to pick apart the MIB and set up a poller for each individual OID you want to poll. I looked at the MIB for that 22420. section and there are a frustratingly large number of values in there, that's going to be a real pain to set up if you actually need all of those values checked.…