mesverrum · Observability Architect · ✭✭✭✭✭

Pretty easy, just go to the web based report writer and tell it you want to create a new table report on all interfaces (or filter them down to whatever you are interested in). Then when it takes you to the screen where you pick what columns of data you want to display I would be looking for full name and interface index.…

If you already have the monitors in place it's pretty simple to override the URL away from http://{$ip} or whatever you are using to just hardcoding in the exact url you want to test. If you don't want to muck around in the GUI you are going to have to do it in SQL as there is not yet any verb for the API to handle all…

If you are going to hack things up I absolutely wouldn't be doing it there in the api (I believe it won't even let you create objects on the tables you are looking at anyway). I've done what you are describing by hitting the SQL database directly because a LOT of whats in the API are derived values that the application…

I'm not sure if you want to monitor local certificates on the server or an https web certificate. The web certificate is pretty easy since there is a built in component monitor for those How to Monitor an SSL Certificate and Create an Alert in SolarWinds SAM When There Are X Days Before Expiration - SolarW… If you are…

Thanks for the quick confirmation, I'll let my clients know so we don't waste a lot of time trying to rig up any work arounds

Any alerts that are tagged as "out of the box" cannot be modified or deleted, you just have to disable them. If you do manage to delete them they get re-created the next time the configuration wizard runs

I've built schemes to automatically sort and assign templates before, there are many ways to approach it. For one, you just have a custom property that you set to tell Solarwinds manually that "this server has dhcp" I call mine "Applications" Then create a group with a dynamic query that just checks for nodes where…

I spoke to one of my colleagues and he told me how he had made this work before, and that basically it matches up with what you say here. I figure I will manually configure a few examples of the over rides I need so I can verify the correct variables for each column and once I get comfortable with those I'll just insert…

To add some context to d09h​'s comment. By default the system holds 7 days of detailed stats, then averages those details stats into hourly values that are held for 30 days, then averages the hourly stats into daily stats that it holds for 365 days. Tripling these values would have a proportional effect on the total size…

trevski​, 1500 ms is likely to be pretty painful, Solarwinds recommends keeping the latency under 500 ms between any APE and the database server

I built an integration like that for a client recently, as you said they end up being a good amount of work to correlate the various pieces of information, but we were able to get it knocked out within a week. It's not terribly hard, but there is a fair amount of back and forth with the testing.

In order to get the integrated single pane of glass effect Solarwinds offers you are definitely best off keeping all of the possible applications on a single database, you really do give up a lot by breaking them apart. If you want to minimize the impact of SAM on the performance of your NPM you can technically use SQL…

Your "New Server" image didnt load so I'm doing some guesswork, but when you say interface traffic statistics is missing you don't mean that it's not checked right, you mean that it doesnt show up as an option at all? Is this interface not a normal ethernet? The times where I have seen those options not show up are for odd…

This might help select ac.name as [Alert Name] , aa.categorytype , a.actiontypeid , ap.propertyname , ap.propertyvalue from orion.actionsassignments aa join orion.alertconfigurations ac on aa.parentid=ac.alertid join orion.actions a on a.actionid=aa.actionid join orion.actionsproperties ap on ap.actionid=a.actionid where…

You could also just add the website's dns name as an ICMP only node as well if all you are doing is testing for ping response. Anything more detailed than that requires SAM or WPM, or could be done with Pingdom if you prefer cloud tools.

This will show all the interfaces that are currently unplugged but not the ones that are all unpluggable. I'm almost certain there is just a true false value you can reference on that same list of interface properties though, it'd be like unpluggable = true to get the master list.

You can also apply that view to all devices with a particular machine type by going to All Settings > Views by device type

If not there then they might be on nodesettings

You could also build that as a swql query inside your orion dashboard, if you prefer to do it in the UI instead of scripting. I went ahead and cannibalized a query I have on my node details page that I embed with links to a few pre-defined prefstack charts for cpu/mem/response/loss to do this: With a searched value And if…

Agreed, I think this is a hard coded cautionary warning, not something that it detects. If you are running the latest versions of everything then the APE will get its installer files from the Primary poller which should help to keep things synced up. The common modules i see problems with are with IPAM, as it does not have…

Yes in fact in this case it is, i usually test scripts on APE's that way the impact is less if I blow something up

I've done models similar to that in the past as well where each alert ties back to specific playbook. The tighter you can integrate your monitoring with all the related tools the ops teams uses the better.

rschroeder​ I don't recall the specific example you are asking for, but typically what I see for provider info is people just building up a set up custom properties on their interfaces with that provider contact info. You could modify the method alexslv​ used on his aux db "sites" table to create yourself a table (probably…

To access the db in powerbi or similar you just would want to set up connection to the db, assuming you are using the internal postgres db you can follow these instructions https://support.solarwinds.com/SuccessCenter/s/article/Configure-access-to-an-embedded-PostreSQL-database-from-multiple-hosts If you are using an…

This definitely looks like something you should bring to support. Some of your vCenters must not be completing their polling consistently or the integration module isn't processing the data consistently. Do you see any performance collections failing on the VMAN appliance side? If the charts are all complete on that side…

As far as how to do it in Report Writer, don't. That part of the product is long since deprecated. You can take the query above and paste it into a "Custom Query" resource and be all set. If you need it to be in a scheduled report then you can take what I have there and use the web based report writer and hit Add Content,…

Out of the box this cannot be done.

If you guys are already that deep into it with scripting and automation, you can just set up scripts to check group memberships and assign the templates where they didn't get auto deployed as a fail safe/backup. Also, not sure if they told you during the call, but restarting services often gets them auto assigning again in…

This is the SWQL for the report I run to track when the templates aren't auto-assigning SELECT distinct cm.Container.Name as [Group], at.Name as [Template], cm.Name as [Nodes missing template], cm.MemberAncestorDetailsUrls as [_linkfor_Nodes missing template], n.Vendor, n.StatusDescription FROM…

The direct answer being, no, there are LOTS of things within Orion that have no built in mechanism for exporting/importing between systems. I had a conversation with some Solarwinds staff recently relating to this issue and they still didn't see a valid use case for a ton of the things I literally do every day to…