Lofstrand · Solutions Architect · ✭✭✭✭✭

See (+) App server communication to DB server - Forum - Server & Application Monitor (SAM) - THWACK

Hi @"raiden100" Two ways directly comes to mind. The first easy way should be to see if the application itself is storing this info in some log file or as a windows event . Can you monitor such a log for that kind of info? The other way is to have a powershell-script-monitor do a "test-netconnection [SQLServerName] -Port…

The logs for diag are stored at ${ProgramData}\Solarwinds\Logs\Orion\Diagnostics\swDiagnostics.log, might show something

No I don't believe there is a way to display all attributes an entity has. When it comes to finding all "Windows Servers", in your example. The attribute to look for can vary depending on how the server got into SWO. For example, if it's an APM server, then you can use apm.osType:windows If it's from an integration to…

Hi @"robert777" , if I remember correct there is a bug in that version for just the issue you are describing. Some SQL instances miss some data, for example top fragmentation indexes. Think it was fixed in 2025.1.1

Should work. Have a look at this page also: (+) How to Migrate Orion to a New Server With Zero Downtime - Product Blog - Resources - THWACK Also, make sure firewalls etc supports your new addresses. If you use NTA or LA, make sure your devices send their data to the new HA hostname

Just to clarify, that looks like a SQL query and not a SWQL query. Below as SWQL to the same info: SELECT C.ComponentName, C.ComponentType, C.status, C.StatusDescription, C.Application.Name AS AppName, C.Application.node.DisplayName AS NodeName FROM Orion.APM.Component AS C WHERE C.status NOT IN (3, 9, 11) -- Exclude…

If you have Observability or SAM your can do basic vmware monitoring. Host hardware health should be included in that.

Ha - it does not accept "-" I couldn't add your account either, but changed "-" to a "_" and that was accepted!!

Don't think so. I just added a fake account to the account list and it was accepted (even though the actual gMSA account will not work to monitor stuff with)

Just save the .txt-file as .swql, then upload

Are we talking about vmware servers, azure server? For Vmware I have created such reports several times, as SolarWinds knows about all VM's and if they are monitored. Same with Azure, SolarWinds can see all compute entities. I guess we can create a similar report but I don't currently have access to a system with cloud…

Hi, you can read about the required permissions here: Required permissions for VMware, Hyper-V, and Nutanix credentials in VMAN

Hi, I added an account in this format: gmsa_svc01$@domain.net This is also verified in the documentation: https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-use-gmsa-account-for-windows.htm?cshid=orioncoregmsa gMSA credentials in form <username>$@<domain> or <domain>\<username>$, The domain…

In the concept of "MS SQL Always-on", both "Windows Failover Cluster" (WFC) and "Availability Groups" (AG) are included. So what you have is not a "cluster" but Availability Groups (even though AG rely on WFC underneath). In a WFC, SQL instance is not available at all on the secondary and on the primary it's available…

As JM_sysadmin says, check the log files. They can be found here: C:\ProgramData\SolarWinds\Logs\Orion You can look in "ActionExecution.log", "ActionExecutionAlert.log" and "Alerting.Service.V2.log.". Hopefully one of them can guide you on what's happening.

Hi, the recommendation is to NOT monitor the DPA Repository instance with DPA. Not monitor itself. SQL Sentry on the other hand is better on that. See this page for example, DPA 2025.2 system requirements

Hi, you can also check the log-file for the report action: C:\ProgramData\SolarWinds\Logs\Orion\ActionsExecutionReport.log

Hi @"tpfannes" , yes you always have to have all three databases: Main, Flow and Logs. Even if you don't use those features. Everything is installed and the features you license will be made available to you. You can't choose to only install some components. If you are migrating and will reuse the old databases, you should…

I guess you wanted a SQL query that combines "Display name" and "Description" field, if they are not already combined. Have not created that yet but here is a SWQL that you can use for a "Custom Query widget" to display this info and search for the networks. SELECT DISTINCT G.FriendlyName AS IPNetName ,G.Comments AS…

Hi, depending on your need and reason for exporting you can either schedule a report with the details you want. Or a normal SQL database backup, that I assume you do, holds all IPAM info.

Nice one @"jm_sysadmin" I have extended the query some. This one assumes you want the IPAM network field "location" to go to Node custom property "City". I first check that location field is not null or blank, then I check if the two fields are the same or not. Only updating the nodes that need updating. SELECT n.NodeID,…

Hi Todd Looks like the old web page is not even on the webservers drive. So I guess there is no way of restoring it (If you can't find the file, copy it in there and get it to work....) If you hoover over a network you will see the description: If you use the "advanced search" it will search all subnets:

I strongly suggest that you use SQL authentication here instead of windows/integrated authentication. As the servers are not domain joined. And as @"maciej.sandecki" says, without domain you can't use Kerberos and thus SPN is of no interest. Run the config wizard again, make sure that you use SQL authentication and that…

Hi, I see "N/A" on some "DefragmentIndex" operations. Defrag typically only happens on indexes that are more fragmented than a threshold and larger than another threshold. (don't know the numbers). When I look at a few of the indexes from SQL management studio, that has N/A on them, they are not very fragmentet and small…

Hi, You can use the same account. Combining what the two products require. One advantage of using separate account can be that it's easier to see what each application is doing. But using one account is less accounts to administer. So it's up to you.

One thing to consider when thinking about using an online SMS provider is: How are you going to send an SMS alert that the network is down, when you can't reach the SMS provider due to the network is down? My suggestion is to purchase a hardware device for sending SMS, placing is as close to the SolarWinds server as…

Try using the variable ${N=SwisEntity;M=NodeID} instead of ${Nodeid} I found that this made a difference.

Microsoft now recommend disabling STS on "..Servers that use time as part of data processing..." Secure Time Seeding Recommendations for Windows Server - Windows Server | Microsoft Learn

Hi, no you don't need to assign a resource pool just because you are using memory optimized tables. You CAN if you want to but there is no recommendation to do so. Resource Governor and related Resource Pool features are available in Enterprise (and Developers) Edition only!