Seashore · Solutions Architect · ✭✭✭✭✭

You can create an alert, looking something like this:

No, not possible with built in email action. 

You can use a SAM SQL monitor to query the SQL instance if there are any AG's that is failing. Use below query: select g.name INTO #AGStatus from sys.dm_hadr_availability_group_states S inner join sys.availability_groups G on s.group_id=G.group_id Where synchronization_health<2 AND s.primary_recovery_health=1 IF (Select…

Wonder if that is used when using OAuth 2.0 as credential type. That calls back to the requester (SolarWinds platform) to verify the connection. But not sure. Start trying without those ports!

Hi, the tcp port changed from 17778 to 17774. Changed in 2024.2 documentation.solarwinds.com/.../solarwinds_platform_2024-2_release_notes.htm

Hi You need some sort of WHERE-part, so you only get the value for the volume you are alerting about. In below example I have added that, taking in the variable for the volumeID that the alert is about. Also, you don't need to do an "INNER JOIN" with SWQL as it already know how those two tables are to be joined. Just…

Hi, I run the SQL component script I posted on the link you referred to on each node. Then it will show if ANY availability group is in bad health on that server.

By the query it looks like you want to alert if a Windows Service is down. Then you can just do like this: All the node data and application custom properties are not relevant here as they are not anywhere in the where part. They can be inserted later in the alert action if that info should be included.

Hi, I think you can do something like this: The full query, including the mandatory part is: SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes INNER JOIN ( SELECT N.Uri FROM Orion.Nodes AS N JOIN Orion.NPM.CustomPollerStatus AS PollerStatus ON N.NodeID = PollerStatus.NodeID JOIN Orion.NPM.CustomPollers AS…

Hi If you want all nodes, you can't start by querying the table Cirrus.Nodes, start with the table that includes all nodes: Orion.nodes. Also, you just state "JOIN", not what type of join you want. With only "Join" it will probably be an inner join and that only includes where both tables match. If you also want the…

Network devices typically talk SNMP and SolarWinds by default picks up many metrics. If one metric is not picked up by default you can create monitoring for that with "Universal Device Poller". With that tool (included in NPM and HCO), you can monitor ANY snmp metric. If you go via an API, you might want to use SAM, or…

Hi, glad you found my article at SWQL Custom Query – Status Icons easy Groups are called Containers behind the GUI. So a working query looks like this: SELECT G.StatusDescription AS Status, G.Name AS Name, G.DetailsUrl AS [_LinkFor_Name], G.CustomProperties.Group_test_CP…

Seen that at another customer as well. Restart of SolarWinds services fixed the issue then. After upgrade to the latest versions I haven't seen this anymore.

How are you updating the categories? Through edit node? Is it not saved then?

I guess the answer should be the same as we tell our kids when they study for a test in school ; it's the knowledge you gain by studying for the test that is the ultimate goal. If that test boosts your career depends on what you do with it. If you search for a job that requires this knowledge it's a good proof. If you work…

You can use it also for the "anomaly based alerts", and probably more AI stuff going forward. You don't need a paid version of SWO for that, just an eval. So there are some use cases for setting up the connection even though you will not actively use SWO.

Don't think there is a way to adjust the columns. If you have the SolarWinds platform as well, and have DPA integrated with SolarWinds, you can create a custom table there with the DPA info you like. Look here: How to get DPA "overview table" in Orion 

Hi @"JustinD" Yes, same thing can happen with volumes. Either you create a scheduled report that tells you what devices needs attention. Or, you set up discovery jobs that finds any new interfaces or volumes you have. Then, in settings, you can choose to automatically remove stale interfaces and volumes after a certain…

That SHOULD give you the same amount of devices

No credentials needed

Script parts are disabled by default. See documentation.solarwinds.com/.../core-custom-html-resource.htm

Hi I don't think [description] exist. Do you see it in the GUI? Took part of the query and added "with QUERYSTATS" to the end. Then you get the actual SQL query: SELECT TOP 1000 DashboardID, DisplayName, Description FROM Orion.Dashboards.Instances with QUERYSTATS Resulted in the SQL code: SET DATEFIRST 7; SET TRANSACTION…

All SAM templates has to be assigned to a node. In the case of a saas application, just add an "external node", a dummy node that is not gathered any data from. Just so you can assign you template to is.

Logins are logged in the Windows event log, security log, right. Can a normal "SAM Event log Montior" do the trick for you?

Tested this one today. Works very strange.... But here is a query that works: SELECT N.caption as EntityName ,N.vendor ,CASE WHEN n.Status=1 THEN 'up' WHEN n.Status=2 THEN 'critical' WHEN n.Status=9 THEN 'unmanaged' ELSE 'unknown' END as EntityStatus ,n.detailsurl as EntityLink ,'server' as EntityIcon FROM Orion.Nodes as N…

The tricky part when monitoring a backup link is to know it's really working. The interface might be up but is it ok past the next routing hop? One thing to do can be to alert if you have zero traffic on a backup WAN interface. There should always be some background noise (routing protocol and so). If no traffic at all,…

Nice one! Great walkthrough. Created something similar to test TCP connection from a remote windows server to another TCP destination. Using remote powershell to execute a "Test-NetConnection". Added it here: thwack.solarwinds.com/.../4250

Hi, it's possible but not easy. Done almost similar before. Then we did it with SQL query. One query to calculate the average value, another to compare current value with average. Combine with a CTE that you join in with the required part of the SQL query. So, how should the average be calculated? Last x hours? Last x…

If you want the component names you just add A.component.name as [ComponentName] to your query. You also might want to add some more fields like status and url, but that is just in the same way as you did with the application part. The group-part, I don't understand what you want. Are all these applications member of one…

Hi, add "F=Bandwidth" to the end and it will format it better. Choosing Mbps where applicable: ${N=SwisEntity;M=Inbps;F=Bandwidth}