mesverrum · Observability Architect · ✭✭✭✭✭

Do you have an SSL cert that also matches that dns name?

Not entirely sure if you are referring to the free tool version of it, or the one that comes included with NCM. The free tools generally speaking, get little to no real documentation as they don't directly generate revenue and are pretty much presented as-is. If you are referring specifically to the service that gets…

I'll want to jump in and mention that those integers are specific to your environment based on the order of modules you installed and how long your system has been around, any time you want to report on them and have it work in another environment you need to join the table with the actual name strings and search against…

You can add this to a custom query resource to get a similar result for applications SELECT s.Application.node.Caption as [Node], s.Application.Name as [Application] , (sum(case when s.Availability=1 then 1 else 0 end)*100)/(count(s.ApplicationID)) as [Up %] , (sum(case when s.Availability=3 then 1 else 0…

And there is an import/export function. Granted, it has some deficiencies since it doesn't preserve groups schemes, but it definitely can import massive numbers of subnets and the info for each address in those subnets. I used it to migrate over almost a thousand subnets of info earlier this Summer.

tdanner​ This raises a point I never noticed, none of the examples for the $CorePluginConfiguration that can find include whatever the syntax needs to be to check the box for rediscovering agents. I've got examples for bulklist and subnets, but also no references for how you guys would need a request to look for AD groups,…

Because making the numbers progress the same as the UI would be too simple , try this * ,CASE * WHEN o.AlertConfigurations.Severity = 2 then'Critical' * WHEN o.AlertConfigurations.Severity = 3 then'Serious' * WHEN o.AlertConfigurations.Severity = 1 then'Warning' * WHEN o.AlertConfigurations.Severity = 0 then'Informational'…

There is no simple way to figure it out that i have ever seen posted. Since Orion doesn't associate alerts specifically with objects there is not some master table of nodes that match each alert. The closest thing to an easy answer to this is the "all alerts this object can trigger" resource, but I've not seen a way to…

I ran into that with one client, in my lab and his lab running a discovery would update the nodes, but on his prod system it would only skip them. Never did get a resolution about why his system had the unusual behavior. You can try this sql query in the database manager and see if it gives you what you need, you can…

Yep, snmpv3 is all treated the same way they do windows passwords where they encrypt everything in the db and I've never seen a method of recovering things back out of the credentials table.

Yeah, in classic air gapped network fashion you would need to get that template export file onto whatever kind of sneakernet you are using to bring new data in, or do it the hard way and just open the template on a computer with internet and build your own by looking at it and manually re-creating it inside your network.

Orion.credential has the credentialid and the user selected name that was given to the credential, so you shouldn't need to go any deeper since the snmpv3 nodes only require the credentialid in their configuration. The username and passwords on credentialproperty are encrypted anyway for all current releases so you can't…

I know a few people I was talking to brought it up to some of the SW PM's I was speaking with a few months ago and they seemed surprised, felt like some product teams thought it would work one way and the other team thought the reverse. We definitely leaned on them that it was very important for the product to do this…

But if you don't mind butchering the database a bit it can be done directly in there, I've done it a few times. As far as your alerting on rate of change question, that's also doable with pure sql. When I'm home I'll dig up some code examples I have for both.

To be honest I have never once tried to use an AD account as the application account, from what I'm seeing in the documentation I'm pretty sure there is no option to use a windows account for that part of the application.

Still struggling with this, built a sweet collection of perfstacks for a client and then when they wanted to show them off we got completely stuck on this issue. Can't send the report out if half the text is backward

Since you already have both of the relevant bits then what you should be able to do is first, go into the UNDP tool on your Orion server and make sure that the label is set to that ZAPName OID. Assuming that is correct then on your email alert you will want to his the insert variable button and search for a variable that I…

Try the same query in the "all interfaces by traffic" widget and see if you get hits there.

in swql you could do a where n.vendor='windows' or something like that as a simple filter.

The out of the box resources cannot have additional information added to them. You can make a custom report with a table and use icons and such to indicate the utilization rates, but if it HAS to be a bar then you are going to be getting into the realm of rolling your own. This is SWQL the report I use in a custom query…

Ive migrated many people, never moved certs except the occasional IIS wildcard, never had an issue.

I also think you could also get away with the subselects if you filtered them within the subselect and didn't reuse the same table aliases but I didn't test this in the lab, and it is likely to have problems wherever there is a cbu that doesn't contain windows nodes As a general rule I tend to skip subselects where…

The kb for the JMX monitor also mentions that there are some extra steps for agent based monitoring JMX monitor Confirm those steps have been taken, I would also try polling the sam monitor without the agent by going to the advanced options at the top of the template and changing the preferred polling method to see if you…

^ I've done this method before and it worked well, just add the custom query widget to a view and whatever node or custom property or whatever the person searches for gets pulled up using the search box on the widget. Print to PDF if you like from there. Otherwise there is just no native functionality for "on the fly"…

To the best of my knowledge you can reference variables from the node and its custom properties tables as part of your scripts but I've never seen a method to take the results of a show command and reference then later in the script. Doesn't seem like the ncm syntax allows for parsing the results of the commands you…

There is a table called something like nodeipaddresses that has the list of all the ips that SW knows about for the node that can be joined to interfaces on the ifindex. I don't remember if the subnet masks show up anywhere in NPM. alternatively if you run ncm inventory on the devices there is another table with IP info…

As far as the "teach a man to fish" part, I'm not shy to point out my signature and mention that we offer a pretty solid 4 day advanced reporting class (the 301), along with on-site or remote private engagements https://loop1.com/training/solarwinds-public-training/​​ For those who are more interested self learning then…

Without UDT it is within the realm of possibility to use universal device pollers and custom swql resources to correlate mac addresses to interfaces and ip addresses but you would essentially be building your own rigged up version of UDT.

Not sure what you mean by another license, but assuming you have a vcenter then orion can poll that with any NPM or SAM license and it just counts as a single node same as any other IP. VMAN is separate and gets you additional details, but nearly anything you see by polling the hosts directly is available in the built in…

So you are just looking for interfaces with rx/tx errors above 2500 and trying to exclude a ton of interfaces. Don't know how big your environment is but I would suggest that maybe instead of having 20 conditions you just create a custom property on interfaces and tag the ones you care about. Call it Critical_Interfaces or…