Seashore · Solutions Architect · ✭✭✭✭✭

Hi, based on your query you just add one row: " AND N.UnManaged=FALSE" SELECT 100 * SUM (CASE WHEN Status = 1 THEN 1 ELSE 0 END) / COUNT(nodeid) AS Available_Percentage FROM Orion.Nodes n WHERE n.CustomProperties.Region IN ('Central - Network', 'East Coast - Network', 'Southern - Network', 'Northern - Network') AND…

My guess is that it can't find the orion server. Try adding the domain to the hostname or use the IP-address instead. See if you can actually run that URL from the MID-server manually.

You are not the first and probably not the last to ask that question. The answer is that SolarWinds does not work that way. Alerts are not "assigned" to any nodes, but to all that they apply for at a particular moment. There are widgets showing what alerts apply to a node but they don't cover all alerts in my experience.…

The data in "list resources" are not long term stored in the database. So no, the data you are after is not in the database. If you do a discovery of your servers, that result though is stored in the database.

I agree with @"jm_sysadmin" . In my experiance, DPA and AppInisght for SQL are well tuned not to impact the SQL very much. But with your own custom SAM templates, it's up to you to know what you are doing. Just as bad user queries can heavily impact SQL, so can your queries that you let SAM run on SQL. Database corruption,…

I have seen that warning several times. If https is working fine on your SolarWinds website I would ignore that warning. 

Default poll interval for interface statistics is every 9 minutes. Meaning SolarWinds does not have the info you request unless you have adjusted the polling interval. But say you have, or can be ok with high usage over default 9 min, I'm not sure how to create such a report. One way could be to say that the interface will…

How about the metric called "Peak Transmit bps"/"Peak Receive bps", can that work? There are some other "peak metrics" as well. 

I also had issues with TFTP service when upgrading from 2020.2.6 to 2023.3.1. It said the same thing as above, "failed to start, verify you have permission" etc.. Tried to reinstall several times but it just failed to start. Then realized that it had failed to UNINSTALL the OLD version of TFTP. So I then manually…

Hi, a bit hard to follow your query. Think you have created a bit to much code. But if you add to your last where clause "WHERE N.NodeID=1234", if your netscalers nodeid is 1234, then you will get the data for only that netscaler. If you want to use this in a widget on your "netscaler node view" you can use a variable,…

The audit log in the SolarWinds platform, same as in just the SAM module, is not meant to be deleted. So no account can do that. With admin privileges though, you can adjust the retention interval. (But if you really want to, you can probably do it via the SQL database).

When troubleshooting large queries I try to take it part by part and see where we have issues. In this case I took only the muted nodes part to start with. In my installation it seems that [suppressUntil] was null on all rows as they had no enddate on the supression. That gives that the part "where -- Added to remove…

I have used it a few times. Then I have always downloaded the oracle client driver, from Oracle website, and installed it on the polling engines. Then it has worked just fine.

Haha, you are perfectly correct Fabian.S, I didn't look at what forum this was in.

Normally when you assign a "SQL Server User Experiance monitor" to a node, the query is run from the polling engine against the SQL server. BUT, I wounder if you have an agent on the monitored SQL server, if its run from the agent, locally, to the SQL Engine. Not sure but might be a solution. If the db in azure is a "Azure…

In your solarwinds install folder, under folder Orion, you have a file called SWNetPerMon.db. There you have the SQL connection string. (Default path: C:\Program Files (x86)\SolarWinds\Orion\SWNetPerfMon.DB) You probably get access denied trying to read that file. If you have permission, copy the file to another place and…

EDIT: this is for SolarWinds/Orion -plattform, not DPA. My misstake On every alert action you have a part called "Execution settings". There you can configure the action to repeat every x minutes or hours. Check both boxes to have the repetition stop when the alert is acknowledged:

Try the whole query, including the mandatory part, in SWQL studio first. Or rather, first try the part within the () in the inne join. Make that work. Then the whole query with the mandatory part.

I haven't tested below query but I think it should work. At least this is the theory on how the query should look like: SELECT component.uri, component.DisplayName FROM Orion.Apm.Component AS Component -- Mandatory Query part above INNER JOIN ( Select Count(CA.ApplicationID) AS CountProcess ,MAX(CA.Uri) AS uri From…

You have to create a query that includes the first part, as the alert process needs that to continue. URI is an internal identifier of the object. But I think you need to change your base query a bit. You can't ask for "count(ca.application)..." as that will not return an application with issues and that is what your…

Hmm, I see I have Orion.alerts in ver 2023.1 but not in 2023.3. So it's probably removed in later versions. 

If you assign the template to some node, you can enable "debug" on the assigned template. Then you get more detailed logs in this folder on that polling engin: C:\ProgramData\SolarWinds\Logs\APM\ApplicationLogs Solves my issues many times.

I'd say it's normal. I don't have orion.alerts either. Looking at the page you refer to, it's for 2020.2 version and "Alerts created in Basic Alert Manager". Basic alert manager was removed many years ago. What is it you want to see? There is probably another place to find it. If you use SWQL Studio you can browse your…

Hi, I have seen this question before and the answer is the same - don't think it's possible. Why? Alerts are not associated to alerts! Can be alert rules that are created for individual nodes but most of the times they are not. The trigger condition are within some xml-code in the database so it's not easy to create a…

Not from the group itself. Bu you can use the group membership to create a script that parses through all members of a group and mute's them. I would use a custom property instead of group for this, but you can do it in either way.

Hi, what port are you trying to access DPA on? Default https port is :8124. Do you need to open a firewall for that also? Maybe windows firewall. 

FYI: I know that some devices state the time for the snmp-daemon restart as the time for the device restart. Might help in your troubleshooting.

Is it that you want to display the Groups the node is a member of, when alerting that a node is down? What if that node is a member of several groups? To get the first group the node is a member of, try this: ${N=SWQL;M=SELECT CM.Container.DisplayName AS T FROM Orion.ContainerMembers AS CM WHERE CM.MemberUri LIKE…

Hi, if you want a report to show data from a specific time range, edit the report and choose the time range in the drop box shown below: If there are no matching predefined time range choose "custom..." and choose the dates you want the report to display data for. 

Hi, the easiest way is to use a normal http/https-component (either one of them). In there add the text you want to search for and set to "fail if found=no".