Seashore · Solutions Architect · ✭✭✭✭✭

Either you create a script, could be a powershell script, that calls the API to make such change. Or you can create an alert rule that triggers when the application is found but custom property is not set, then an alert action that updates the custom property. Easiest if you don't want to code.

I think it can be tricky, you want to monitor a service before knowing if the service exist. One way though could be to utilize the information gathered in Asset inventory. There you can see if the application is installed. If so, a group membership can be applied. (might need to add a custom property logic between these…

If you are talking about monitoring an AG cluster with DPA, it depends on how many AG's you got. If you only have one Availability Group on two servers, I should monitor only the AG-itself. Resulting in one license. If you have more AG's than servers, I would monitor the servers themself instead.

Read a bit more about String_Agg. Looks like it can take data from several ROWS and combine them, CONCAT can combine data from several COLUMNS. Don't think there is anything in SWQL that matches String_Agg.

Is it CONCAT() you are looking for? * Concat(a, b, c, ...) - Takes one or more arguments and returns a single string that is the concatenation of the values of the arguments. https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions 

Yes, SolarWinds will connect to the port the db-engine is listening on. Default TCP/1433 for MS SQL. So from the polling engine, to the monitored server, on the port the engine is listening on.

Whenever you are curious about the SQL behind the SWQL, add "WITH QUERYSTATS" in the end and you will get another tab with that info.

I can't see your code error either ;-) But below should give you nr of alerts per severity: SELECT Count(AA.AlertActiveID) AS QTY ,AA.AlertObjects.AlertConfigurations.Severity FROM Orion.AlertActive AS AA Group BY AA.AlertObjects.AlertConfigurations.Severity Want text instead of severity number? SELECT…

 @"lancasterb" That looks correct. Sometimes when an alert has triggered and you go in afterwards and change the alert rule trigger condition, an existing alert might not reset. Then you have to clear the alert. Can that be the case?

@"WindsOfNishat" If all of you wan interfaces has Wan in their name of some other way to search for them, they can all be changed at once in "manage nodes" page. You can also count the nr of times in the database that you have a higher value than your threshold, but it it's high for some time you will get several hits even…

Hi, thinking that every time thresholds are breached, an event log is created. Can you count the event posts? That would be easiest I think

An idea is to create a custom property for the IPAM networks called something like "NoAlerts" (true/false), set the value on the DHCP-scopes in mind to yes and adjust to alert rule to consider this new value also before triggering.

Hi @"swf.nfs" , try to remove some parts of the WHERE-clause. Might help displaying some data.

Suggest you take a look here: Need assistance creating an alerting modern dashboard

Do you want to display all system event messages for all nodes? By default SolarWinds does not collect that. What you can do is set up Windows event collection in LA. Then all even logs will be available. See here for more…

Hi Just converted your SQL code to SWQL and added some naming and formatting. SELECT N.Caption AS [Node Name], E.EventTime AS [Start of Downtime], (SELECT TOP 1 EventTime FROM Orion.Events AS EndEvent WHERE EndEvent.NetworkNode = E.NetworkNode AND EndEvent.EventTime > E.EventTime AND EndEvent.EventType = 5) AS [End of…

This could be an example for the first part: SELECT T2.Caption FROM Orion.AlertSuppression AS T1 Inner JOIN Orion.nodes as T2 ON T1.EntityUri=T2.Uri ORDER BY T2.Caption ASC and adding a version for the search box, it could look like this: SELECT T2.Caption FROM Orion.AlertSuppression AS T1 Inner JOIN Orion.nodes as T2 ON…

Hi @"Vanderdecken99" I made that integration a couple of times. The last time I used below powershell script to contact Fresh: param ( [Parameter(mandatory)] [String]$resource, [Parameter(mandatory)] [String]$metric_name, [Parameter(mandatory)] [String]$message, [Parameter(mandatory)] [String]$description,…

Go in and edit the application. There you have a test button and the possibility to change credentials as well as the port SQL is listening on. Could be that your SQL is not listening on the default port, 1433. Could be permission issue. But best to first start testing there. @"bmakhmutov" 

See SQL Error Log Messages on the Summary Dashboard

Hi @"bmakhmutov" , I don't think that is possible. I don't see that info in the tables. Sorry.

The real-time event log viewer shows the eventlog info when you open that function. It is not stored in the database so you can't create a widget showing that. What you can do is use as an event log component. Assign that one to the servers you are after, configuring it to save errors and warnings. Then you can create a…

Hi, with a Group BY you need to mention each column not in an aggregation function, like MAX, MIN, AVG etc. So your Group by row should look like this: GROUP by NodeId, CveId, Id, Severity, Description But I doubt that will give you what you are after so I created this: SELECT N.Caption AS [Node Name] ,Total.NrCVEs AS [Nr…

Hi, I see one way directly with two options. Both involves monitoring the SQL Instances with "AppInsight For SQL" that is a template within SAM. So apply that one first to the SQL instances you are interested in. Then there are two options. The first one though, only gives you event that are critical. It seems. The second…

If you go into edit application on the appinisight for SQL and press the test button, does that work? If not what info does it give you? Have you assigned the "AppInsightUser" credentials there? Do you have the correct port configured, the one SQL is listening to?

First, SQL Availability Group status is not shown with AppInsight for SQL. You have to add that manually with for example a SQL query component Second, to add the info gathered with above new monitoring, use a custom table or custom query to gather the info.

Hi You can just add the separate servers as monitored. I would also add AppInsight for SQL on them. Gives great info. BUT, AppInsight for SQL does not understand AAG's. If the database are "not readable" on the secondary AG node, they will be grey/unknown in SAM. To monitor if the AAG's are in sync you can use below SQL…

1. You can see that the node entered and exit maintenance mode in the audit log. You can also see on the node details page that the node is either scheduled for maintenance or in maintenance 2. If the node is mutes, that only affects the alert, not availability. When in unmanaged mode, the uptime percentage will not be…

Depends on what tool you are talking about here. If the tool from "Engineers toolset", they you have to enter IP and mac to wake the device. The tools is not meant for mass management. Other tools like "Patch manager" has wake on lan functionality, for waking the devices up before patching. There it's more designed for…

Hi, yes WPM can check several different URL's from a single WPM player. It's also possible to check a single url from different locations. Just install the player software were ever you want to make the check from. Can also be a server in AWS for example. Take a look here for more info:…