Lofstrand · Solutions Architect · ✭✭✭✭✭

That table is a remain from many moons ago.... SolarWinds Platform keeps the syslog data in a dedicated SQL database which is different from the Orion core database, its default name is "SolarWindsOrionLog", but it can be renamed during installation process. (+) Where does Syslog write its log file to? - Forum - Network…

Hi @"gadbekr" If you want to search for a node named something like "MyServer" you can just add below line to the WHERE-part of the query: AND N.Caption LIKE '%MyServer%'The end will look like this then:

Perfect, then we learned something today as well

Ok, two things here: * Have you configured this in both 32 and 64-bit? There is two different config applications. * Not sure that this .net application cares about what is configured in there. I don't think those configs are used. If 32/64 bit config is not working. Try just add the hostname to the host-file, see if all…

So, from the SolarWinds server you are trying to connect to the SQL server with the DNS alias "SolarWindsOrionTest". That seems to work from your PS script but not from Config Wizard. Correct? I always try with the simplest things first. Test if the server can reach the TCP port. Using the PS command "TNC…

If you assign the template to a node, let it poll at least once, then you have a log file under "C:\ProgramData\SolarWinds\Logs\APM\ApplicationLogs\AppidXX" (where XX is the ApplicationID) on the polling engine. That log is normally very good.

Hi, almost correct. "TCP Dynamic Ports" should be blank if you want that instance to listen on 1433. Like this example where I have the instance listening on port 50001: You can also check what port SQL is listening on. This webpage gives a few examples on how: Identify SQL Server TCP IP port being used

What port is your SQL instance listening on? When you set up a named instance, <ServerName>\<InstanceName>, the instance by default listen on a random tcp port. Whan an application tries to connect to a named instance, the application asks the SQL Browser service on port UDP/1434, what port that instance is listening to.…

I have seen issues on the SQL side before after upgrade/migrations. A restart of SQL helped then. (if you can't figure out what thread that created the issues.)

Yes! In the wizard for adding operations to monitor choose "Monitor existing operations" instead. It will then scan a node for existing IPSLA operations, giving you a list of found operations where you can choose which once to start monitor.

Just tried on 2025.2.1 and it seems to work just fine. Tried to "Export all", not just the structure, and you get a zip file with one excel/csv with the structure and a folder with an excel/csv per subnet with all individual IP's.

Hi Because the check is not done from Node-1, it's done from the SolarWinds server. When a node is classified as down, it means that solarwinds can't reach it with ICMP Ping, that doesn't mean it can't be reached by other protocols, like https. So SolarWinds does not stop trying to poll all application monitors just…

Hi, the easiest way is to use a "custom table" widget, in the datasource for that choose the groups you want (or all groups) and configure the columns like below. Then you will have last 30 days availability for the group and it's members. No need for a SWQL query.

In my experience, if a Windows server is not domain joined WMI doesn't work unless you do as below: To enable remote WMI access on a workgroup server, you'll need to modify the registry to disable User Account Control (UAC) filtering for remote access. This is done by creating a LocalAccountTokenFilterPolicy registry…

The SolarWinds Database maintenance task does several things. Like aggregating data, cleaning up old things. So it must be ran, but only from one polling engine, PE. Index defragmentation is also done by the SW DB Mnt Task, but that's optional. (And if you ran that from several places it doesn't hurt but will probably…

Hi As there is only one database for all polling engines, only one of the should need to be running database maintenance and that should be the MPE. If you try to run the job from several PE's at the same time, the would probably "collide" and not create a faster/better job. Why did it run better after DBMaintenance from…

There is no easy way of getting those queries but you can try this rather advanced option. Try out this query JUST after you ran the report.... SELECT TOP 1000 Host, Login, ApplicationTag, CommandText, StartTime, ElapsedMs, Status, TooplesCount, RowsCount FROM System.ActiveQuery WHERE ApplicationTag like…

Created below, hope that works for you. I don't have your custom property so I added "city" instead. Just change that to environment if you want that instead. SELECT n.CustomProperties.city ,n.Caption ,n.Description ,n.DetailsUrl ,n.DisplayName ,n.IP_Address , CASE (TH_CPU.ThresholdType) WHEN 0 THEN 'Default' WHEN 1 THEN…

Hi Most alerts don't work that way. You can't list all alerts that might trigger on a node. For some alerts it might be straight forward but you will not see all. 

I'm thinking it could look like this in the database: I must admit, I don't know exactly how this will behave after a failover. I don't expect the values to change then.

No, so you keep the two records you have and add a third line. The first two should be "additional" and the third, manual row, should be "primary"

Sorry, I don't think that is possible.

Hi @"Poirot" I think it works like this: As SolarWinds Observability self hosted is installed on a Windows server that is a member of the AD, and we use .net code, it's using the computers account to read the domain. For example in DPA that is a java-application, it has to have a domain account to be able to read the…

This is as far as I got on this one. Don't give you the month name but the number of the month, and year. SELECT SA.Node.Caption AS [Server] ,SA.Node.DetailsUrl as [_linkfor_Server] ,SA.InstanceName AS [SQL Instance] ,SA.Databases.DisplayName AS [Database] ,SA.Databases.StatusDescription AS [Status] ,B.Availability AS [AVG…

What you can try is a bit like the third option there. But, you ADD your own record there and put it as primary. So, add one extra line with your HA details and set that as primary. I have done that a couple of times for other reasons.

Hi @"wobobobo" And you have followed the instructions on this page? Configure website URL for Alerts and Reports in Orion

Thanks @"zachary.lemoine" I have added that to our internal bug tracking. @"mkarak" , FYI

Ok, understand. Try this out: The first part is just the foundation, a SWQL that tries to display all interfaces where the percentage of issues is over 5% (just took a number, change as you wish). Also, I summarized the values from last hour, to get an average and not alert right away. Adjust if you want. SELECT I.Uri --…

Perfect!

Huh, ok. A space there as well solved it. Strange. I see there is a space before SELECT also... Great you solved it!! There have been some tightening up on the SQL variable parts, for security reasons, in later versions. Probably something there.