shuth · SolarWinds Consultant · ✭✭✭✭✭

I haven't tried the 2020.2 upgrade on a Windows 2012 server but your scenario is why SolarWinds re-introduced support for 2012 back into the product suite. Here is a blog article on it: https://thwack.solarwinds.com/t5/Geek-Speak-Blogs/Upgrade-Empathy/ba-p/598453

The response time is in milliseconds.

You will need to check your database in SQL. Deleting data from the database will leave white space in the database. You will need to shrink the database in SQL to reduce the database file size. E.g. (rough numbers) * Database size: 70 GB * You delete 30 GB of syslog messages * Database size: 70 GB (with 30 GB of white…

@"jblankjblank" I have various clients using UnDPs to poll metrics from UPS's, generators, radio systems, etc. These values are then shown on a Network Atlas "map" with the status and value.

Installing an eval on a temporary server is the least impactful method. The only other way I know is to delete that specific view from the database table and rerun the Configuration Wizard (selecting the Database option). It will run a repair and replace any missing views. This does mean taking the system offline while the…

The Orion.Nodes table holds details on the nodes that the system is monitoring (i.e. has been added as a node and can be seen in Manage Nodes). The ~900 results would be the `900 nodes in your system. The IPAM.IPNode table shows all the IPAM IP address information. If you don't see the hostnames in IPAM, they won't appear…

Normally I would say check connectivity between the application and database server but the Config Wizard shouldn't let you get that far without testing that (you have to input the SQL server and select the databases/accounts before your screenshots). I have seen this before when the application server has overzealous…

In the ALERTS & ACTIVITY menu, click Message Center. Uncheck the boxes except for Audit Events and select a time period. In the Action type dropdown, you can select Alert enabled or Alert disabled. Audit events are kept for 365 days by default.

If you create a new integer custom property for the groups, e.g. DownThreshold, you can use the following alert SWQL condition. This will provide the group ID where the number of down nodes is greater than or equal to your custom property value. WHERE Groups.ContainerID IN ( SELECT g.ContainerID FROM Orion.Groups g WHERE…

It's a bug in the new version and SolarWinds is aware of it. I'll see if I can get some more information.

The maintenance runs nightly at 2:15am by default (configurable under your Polling Settings). If you don't want to wait, you can manually run the Database Maintenance tool on the SolarWinds server. During maintenance, any syslog data older than the retention period (30 days) will be deleted from the database. This will…

If you have Switch Stack monitoring enabled against the switch, you should be able to see the Switch Stack sub-view on the Node Details view. This view will give you a list of the switches in the stack (model, serial, master, etc) as well as a visual of the the stack data and power rings. If a stack cable is unplugged or a…

If you want a list of the nodes that are not a member of any group, this is a simple query that can be used in a Custom Query resource, or in a report with a Custom SWQL data source. SELECT Nodes.NodeID, Nodes.Caption, Nodes.IP_Address FROM Orion.Nodes LEFT JOIN Orion.ContainerMembers ON…

I recommend opening a case with support. They will be able to assist in investigating the root cause.

I haven't seen a system with a physical GSM device connected to it for many years. Most SMS notification implementations I see now use Email to SMS where the alert actions send an email to an address like 04xxxxxxxx@smsprovider.com I have an upcoming client who are going to use PagerDuty for this. It looks like their plans…

I don't think you can override the view limitation on a widget but you might be able to get around the view limitation by adding a custom query or report with a SWQL query that shows the same information (will be a table instead of a pie chart). Edit: had a thought that the view limitation would override the custom query -…

The DNS entry is updated via rediscovery using the DNS servers configured on the SolarWinds server. You mentioned the SolarWinds server is still in the old domain - if those DNS servers still return the entry SERVERNAME.ABC.COM, then that is what SolarWinds will show. System name = what the device thinks it is DNS name =…

You should be able to define the URL for the server in Settings > Web Console Settings.

As far as I know, there is no way to limit users to only being able to run predefined/saved scripts. If you enable the Approval system and assign those users the Uploader role, they can request configuration changes but you will need an Engineer or Administrator to approve it.…

To my knowledge, IPAM won't automatically place subnets into groups from a discovery. The groups are used to organise the subnets into a more readable structure, e.g. Sites and breaking it down further into categories like Wireless networks, DMZs, Servers, etc. If you know your various subnets you could use the Import…

You can use SWQL queries in the alert message (or custom query) to extract the varbinds. It's a bit messy but it is discussed in this thread: https://thwack.solarwinds.com/t5/LA-Discussions/Editing-Alert-Message-using-SQL-Using-SUBSTRING/td-p/588778

Best guess is the query is timing out because of the way the data is being joined. I did a quick test on my lab system using your query without the AVG/MAX calculations to see the raw data and it returned 95,004 rows of data. However, my lab only has a few devices and a couple of interfaces - InterfaceTraffic view only has…

As these types of components can return multiple values, they are stored in a different location to other component stats. There are two database views that might help: * APM_MultiValueAlertsData - I think this is the most recent poll data * APM_ChartEvidence2 - contains historical data with timestamps If you use SWQL you…

As far as I know, there is no alert variable for this. In previous cases where I have monitored the same process with multiple instances on one server and used a command line filter (i.e. Java), I have put the name of the app in the Component Name, e.g. * Java - /dev/whateverapp * Java - /blah/somethingelse * Java -…

When adding the DHCP server into IPAM, you could use an account that is only a member of the DHCP Users group on your DHCP servers. Any user in that group should have read-only access to DHCP.

A few of us have talked about this in the following thread: https://thwack.solarwinds.com/t5/LA-Discussions/Editing-Alert-Message-using-SQL-Using-SUBSTRING/td-p/588778 My post in the thread talks about a specific example:…

I've used this SQL query before to find "top talkers" for sending traps/syslog. SELECT lems.Caption AS [Node Name], lems.IPAddress AS [IP Address], lems.Vendor, lems.MachineType AS [Machine Type], COUNT(le.logentrymessagesourceid) AS [Message Count] FROM [SolarWindsOrionLog].[dbo].[OrionLog_LogEntryMessageSource] lems…

You can reference the Orion.CustomProperty table in SWQL. The following query will give you all the Interface and Volume properties. You can add Description to get the custom property description. SELECT Field AS [Custom Property Name], CASE WHEN TargetEntity = 'Orion.NPM.InterfacesCustomProperties' THEN 'Interface' WHEN…

Another thing to note with dependencies is that ALL parents of a child node have to be down. If there is a second auto-dependency or user dependency for the child node and that parent is still up when the child goes down, the child will not be marked as unreachable. For those child nodes going down, check if they have…

@"mark.johnson-TEN" - Adding maps is currently NOT supported but SolarWinds have noted it as a feature request for future versions.