jm_sysadmin · Sr System Engineer · ✭✭✭✭✭

I missed the word interface, thought it was the same, sorry SELECT AH.AlertObjects.AlertConfigurations.DisplayName, Count( AH.AlertHistoryID) as [Alerts Triggered] FROM Orion.AlertHistory AH Where (AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down' or…

SELECT AH.AlertObjects.AlertConfigurations.DisplayName, Count( AH.AlertHistoryID) as [Alerts Triggered] FROM Orion.AlertHistory AH Where (AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down' or AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)' ) and…

If you want the count, then try: SELECT Count( AH.AlertHistoryID) as [Alerts Triggered] FROM Orion.AlertHistory AH Where (AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down' or AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)' ) and HOURDIFF(AH.TimeStamp , GetDate())…

I had to edit it, bad copy/paste

What Information do you need in the report? Here's something that I think is close, its SWQL. SELECT AH.AlertObjects.AlertConfigurations.DisplayName as [Alert Name], AH.AlertHistoryID, AH.EventType, AH.Message, AH.TimeStamp, AH.AlertObjects.EntityCaption, AH.AlertObjects.EntityDetailsUrl,…

Let's hope the newer version has it fixed, 2022.4 is out now and I hope it's there. 

What version are you on? I was hoping this would be addressed in a newer release than I am running (2020.2.6) I had hoped the 2022.x version would be fixed. In March I did open a ticket with support, Case # 01025186 and they said that they would log a bug log. If they did, I don't think I have that number. It's annoying…

Does this article help? Configure SAM to monitor Oracle database servers (solarwinds.com) You won't install on the DB server; you will set up drivers on the polling engine to query the database server. 

I am not having issues with the same setup, so you might review the articles below and see if anything there helps. * PowerShell security considerations * PowerShell requirements * Enable remote access for PowerShell with WinRM

There are logs, and you can up the logging level from info to debug for more information, but I truthfully would open a ticket with support. How to set SolarWinds Agent logs to debug if the Web transaction gets stuck

Excellent Write up @"mdriskell"

In short, administrator, but the details are in the link below. SolarWinds Platform agent requirements

If you want just availability, try: File Existence Monitor (solarwinds.com) 

You will want to assign the credentials in the template if you don't want to assign it when applied to the node. But if you have access to WMI, move to either WMI or Agent polling and let the templates inherit. 

It should not

You are looking at a SQL Script most likely, maybe this helps: SQL SERVER - Useful Queries - Why Huge Transaction Log (LDF) File? Fix Low Disk Free Space on the Drive Used by LDF Files - SQL Authority with Pinal Dave

I used to use the DirectLink account, I no longer use it. First, if you have the pass through authentication set up, they won't need to do any login. Configure automatic login in the SolarWinds Platform I suggest setting up groups for access (or leverage existing ones) for the roles as you see it, and add that so its easy…

How are you authenticating? I assume that you are using something like this to auth: $Creds = Get-Credential $Swis = Connect-Swis $SwisServer -Credential $Creds If you are pulling in the password via text, did you convert it to a secure string? $Swis = Connect-Swis $SwisServer -certificate will work if you run the commands…

The HTTP monitor in SAM shows up when the status code is 200 by default and follow the standard http response codes for success/failure. 

Have you tried to find the status with SNMP? Gateway-SBC SNMP Reference Guide Version 7.4 (audiocodes.com) I prefer to avoid SNMP traps (though it looks like that is an option), and they have alerts as a table even if the SIP trunk itself isn't there. It looks like what you need is there. There are a number of ways to pull…

Things in Orion changed, have you updated your SDK lately? I have a few older installs that have this issue, and the ones on the current version are fine. 

From my discussions SRM is still an additional license

First check permissions AppInsight for SQL requirements and permissions (solarwinds.com) Then check the debug logs: Turn on application debugging for SAM (solarwinds.com)

I spent a few minutes, and I don't like writing queries for group members. My gut says you can do it, but I can't spend more time poking it. Is the group manually populated? Generally I recommend custom properties on nodes and dynamic groups. If I were to do this, I'd skip the group, and query nodes that are your firewall,…

If this is a modern dash you should be able to get an icon using a status format with the status value. Generally status 0 is unknown, 1 is up and 2 is down. Since the APs go unknown, if you want to force it to look down, make a case statement that when status is 0 then return 2. If this is a classic dashboard, you will…

Try SWQL Like: SELECT SRM_V.StorageArray.Caption AS [StorageArray], SRM_V.Pools.Caption AS Pool, SRM_V.Caption AS [StorageVolume], SRM_V.CapacityAllocated AS [VSpace], SRM_V.CapacityFreePercentage, SRM_V.CapacityRunoutDate as[Projected Runout Date], MONTHDIFF(GETUTCDATE(), SRM_V.CapacityRunoutDate) as [Months to runout]…

So SWIS is the information service itself. SWQL is how you query it, which is a subset of SQL with some SolarWinds specific features. You want to look at: solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java. (github.com) Even if you…

I would start with opening a ticket with support, they will be able to dig in and assist. Generally, I see this when server resources are running out, the database can't handle the work, etc. 

There is a widget in this dashbaord that I use: (+) SolarWinds Orion Platform Status Overview - Modern Dashboards - The Orion Platform - THWACK And I have had some luck updating the the credentials store via the SDK: solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in…

I have been there too, glad it worked