Lofstrand · Solutions Architect · ✭✭✭✭✭

Hi I suggest you create a report using the built in reporting tool, with the information you would like. Then you can schedule that report so be sent to you in CSV format. Either by email or stored on a file share. Can that work?

Hi @"HenrikFFM" Does not sound like how it should behave :-) Suggest you open a support ticket about that so they can take a look.

You could dig around in DPA to find out what query is blocking your insert query, then it's that one that needs updating. If nothing if blocking your insert query, then it's the query itself that is slow.

I would check if you have blockings on that insert query stat makes the insert take long time. Can also check "lock wait time". All the indexes you have must be updated on every insert. So having more indexes SLOWS all inserts. They are "only" good for read operations. So having more indexes than you need will slow things…

I did a rewrite of above query without the union parts. All in one Select statement. Should give you about the same info. SELECT N.Caption AS [Node], CASE WHEN N.UnManaged=1 THEN DATETRUNC('minute', ToLocal(N.UnManageFrom)) WHEN ASup.EntityUri IS NOT NULL THEN DATETRUNC('minute', ToLocal(ASup.SuppressFrom)) END AS…

Hi, below gives you a little more than that but use the parts you want. Includes both muted and unmanaged nodes, who made it and when: Code is made for a "custom query widget", but can be used for reports also. Some columns can then be removed. --Unmanaged SELECT N.Caption AS [Node], DATETRUNC('minute', N.UnManageFrom) AS…

Hi Should be doable without any custom SWQL. Here is a report of just two example interfaces. Both graph and table. If that looks ok to you, these are a couple of key settings: Having the "from" value to the wanted timespan. 24h in my case Set the time periods for sample intervall on the graph to "every hour": And on the…

Hi, looks like that is not possible. The best option I was able to find is below with a table widget: SELECT CASE WHEN G.Status=1 THEN 0 -- OK WHEN G.Status=3 THEN 2 -- Warning WHEN G.status=14 THEN 3 -- Crtitical WHEN G.status=2 THEN 4 -- Down ELSE 1 -- Blue END AS GroupStatus ,G.StatusDescription FROM Orion.Groups AS G…

You could also use "Application dependency with connection quality polling": https://documentation.solarwinds.com/en/success_center/sam/content/sam-adm-configure-app-dependencies.htm?cshid=OrionSamADMEnableAppDependencyPolling It will give you latency and packetloss between your application and db. Not timeouts but close.

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.