mesverrum · Observability Architect · ✭✭✭✭✭

I've worked with clients who were using the embedded SQL express in the past. With a small number of objects like you describe it has been acceptable. These clients weren't bothered by slower load times and it wasn't terrible when I used their systems. I've not tried to test the limits of an express install though, so I…

it is fairly common for people to not have AS information as it only applies if you are exporting BGP data info from a router. See this article to check if it would apply, and an example of how to enable it. Monitor Border Gateway Protocol and Autonomous Systems with NTA - SolarWinds Worldwide, LLC. Help and Support

So it's a bit confusing but the appinsights can definitely be added to groups. They just don't fall under the "application" object type. There's explicit object types for each of them that you can add, I'm not on my system right now but IIRC an SQL instance is called something like appinsight for sql instance and once you…

I believe I looked into this issue once like a year ago, normally transactions don't have their thresholds set , just the steps. Transaction inherits the worst status of any step, but doesn't have an overall duration threshold that can be accessed via the gui. Switch your alert object to the steps and you would be able to…

N central is a completely different product line, they have their own forum here Solarwinds N-central community in the Resource Center

I'm assuming their SWQL resource doesn't have all the fun javascript expanding menus unless they completely rolled their own resource. Basically it would be something like Select Name, count(name) as [Count] from orion.containers group by name Thats off the top of my head though, it could be orion.container if you get an…

i series can be added the same as any other snmp device, as long as you set up snmp on the i series itself. In most cases you find that the built in OIDs for i series are pretty bare bones but there are a few vendors who sell expanded snmp services that you can install that will allow more detailed metrics. This is one:…

There is also an option to enable User Specific credentials, so instead of changes from NCM being run under the saved creds globally they would run under whatever credential that user enters for their actions. Set NCM user level login credentials

@Dcaamano I think that ultimately you are going down the wrong road by setting up an alert thats keyed into the group membership. You don't want to use groups in the way you are trying to do at all because it is just going to make your life harder in the end. Just create a custom property on the nodes themselves not on the…

Just set Maximo up with a login directly to the Orion database. The only hard part is usually that you will need to find the data that you are looking for inside the orion database and give your tool all the queries to get that data, if you or someone on this project is strong in SQL then it's easy. Otherwise you are about…

In current vman there's nothing out of the box that specifically looks for vdi desktops, but they are essentially the same as any other vm in Orion. I find most companies put most their vdi together in a specific cluster or have a naming convention you could filter against to have a dashboard showing all vms in such and…

I've done many installs on other distros but not Ubuntu so maybe there is something peculiar about the net-snmp they included. It usually finds the stats and disks and such same as you would see on a windows server or switch, nothing special normally needs to be done. Hopefully someone with Ubunto specific experience can…

Are you using this logic to trigger an alert with an email or for something like a dashboard? If you wanted to get that information as part of a report just add this to the select line ,E0.Node.Caption as [Node] If you are using this query in the alert builder then you don't need to add anything, it already knows how to…

That box is for summarizing data, just switch it back to the default value of show every data point. Thats going to conflict with your show only the top 6 setting though, as it will pick the first node and only show you 6 data points

It's been a while but if i recall correctly there was a way in the past where you could set up a UNDP on a node using SNMP, then cut the node over to WMI and the UNDP would still be able to collect SNMP data for you. This might be a workaround for your situation where you can use WMI for the bulk of the polling and still…

If you want to get that information in a SWQL based resource this should probably get you part of the way select n.caption , n.ip , n.IOSImage , n.IOSVersion , n.TotalMemory , n.MemoryUsed , n.PercentMemoryUsed , ncm.CiscoFlash.FlashSize , file.flashsize as [Flash Used] ,…

Sounds like you want to set up what they call NOC view SolarWinds Orion Platform Training: Creating a NOC View - YouTube

I would say the reason for forcing an update to those percentages is that the default interval is only to scan the subnets once every 4 hours, so if you don't include a forced update then any data on the charts could easily be several hours out of date and inaccurate. I haven't personally experimented with those changes…

What exactly is the logic you would want to use to define a flapping interface, should be pretty easy to whip up a report from the event history table of any interface with more than x numer of status changes within y minutes. Or even simpler, if you don't have a particularly noisy environment just list off every interface…

Try this as a custom query resource on a dashboard, it gets a list of all nodes that currently have software asset inventory on them, then if you click the link it will take you to the software inventory screen for that node. Pretty painless. select distinct n.Caption, n.Vendor, n.MachineType ,…

Orion based VMAN is not at 100% feature parity with the standalone VMAN appliance. For the last couple years Orion and standalone VMAN have just kept parallel copies of most stats where the objects existed as both a VMAN object and an Orion object, so you may have much of the same information, but things like the time…

I've always done this directly in SQL, there is a pretty elegant solution to this and a number of related problems in a series of posts by user alexslv​ The Magic Of SQL Scripts: Do What Counts, Don't Count What You Do In short you create an additional table where you list all of the sites and the properties that would be…

You can't retroactively change the status of the group overall in the db. You would have to recalculate all of the historical availabilities for each group member and program in logic to mark the group availability based on the new behavior.

I know if you use ${ip_address} it resolves to the ip address of the node the application/component is on, so I would expect that it should work the same was for ${nodeid} or ${caption}

You will absolutely have better luck counting the difference between the trigger and reset times of alerts for something like this instead of retroactively trawling through all the historical tables performing math against all the values. Almost everything you need should be available on orion.alerthistory, alertobjects,…

Just add the Orion server to the list of IP's that the hosts send logs to, same as any other syslog/trap collector.

I have a query that breaks down stats on the pollers, you can modify the logic from it to exclude pollers who havent updated in a certain time (10 minutes?) SELECT ServerName, IP, ServerType, Elements, Nodes, Interfaces, Volumes, PollingCompletion, MinutesSinceKeepAlive, CASE WHEN PollingCompletion < 98 THEN…

SAM and NPM both share the same core orion features when it comes to your example of monitoring disks for size and space and alerting at 75% full. In environments with SAM and NPM licenses they basically stack anywhere there is an overlap in their licenses. So, for example, an NPM100 would allow monitoring up to 100 nodes…

To the question on path 1, there is not a migration method. They essentially just expect you to cut over. At this point the only cause I see for keeping STM separate is when clients have one of the few array types that never got added to the Orion SRM. At this point all of those array models that I can remember are getting…

This should give you somewhere to start, use it in the custom query resource, given your description I would probably add in some case logic to highlight any alerts that have exceeded the SLA. --report on alerts triggered select ac.Name ,ah.Message…