bobmarley ✭✭✭✭✭

Try this and see if it is better SELECT DISTINCT [ActiveAlerts].TriggeredMessage AS [Alert] ,CASE [ActiveAlerts].AlertObjects.AlertConfigurations.Severity WHEN 0 THEN '/Orion/images/ActiveAlerts/InformationalAlert.png' WHEN 1 THEN '/Orion/images/ActiveAlerts/Warning.png' WHEN 2 THEN…

The only thing I can see is possibly SQL should be SWQL ? It looks like you are using SWQL in some of the other selects.

Assuming you are using SAM and created a SAM Component that has the name Azure Pipeline Agent in it. When you set the alert use Component Name and Contains as shown below. You will need to add some additional conditions such as the ones shown below 

Give the Unmanage Scheduling Utility a try. RDP to your Main Polling Engine and look for it under SolarWinds Platform 

Please share your existing query and someone on the forum may assist with joining the tables for you. 

I did the same and the DB maintenance is now running fine on 2023.3

I think it would depend on how you set your SAM template and alerts up. We typically try to set our SAM templates to poll at the same frequency as the node gets polled, so pick a number there, 3 minutes, 5 minutes, whatever. Then when you set the alert up you can tell it to check the alert every X minutes on the first…

I was able to get the issue resolved but the words I received back from Support sounds like there is a bug in the system that needs to be resolved. I'm working in an air gapped/no internet environment so need to manually generate the license files. As part of the process I need to obtain my unique machine ID. Being in an…

The syntax woudl look similar to this Where ComponentName LIKE 'SSL Certificate Expiration Date Monitor' AND Caption LIKE '%YOURSERVERNAME%'

Have you considered sending a text message instead? You can text directly to a persons cell phone. 

Good catch!

Here is a good starting point. You may need to adjust the component name to match your component. SELECT Caption, ErrorMessage, NodeID, ComponentName, ComponentType, ComponentAvailability, ComponentPortNumber, ComponentStatisticData FROM Orion.APM.CurrentStatistics cp INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID…

That being the case there are a few options you could use. Run and External program and send the email via your own script is one option. Another option is to set up an 'advanced alert' and use a custom SQL query to look at the Syslog DB. Below is a similar situation where I set up one to look for SNMP Traps, setting this…

Nodes.CustomProperties.No_Backup LIKE 'NO'

Possibly check the nodes individually and see if they all are using the WMI account that you expect since you are using 'Inherit account from node' it could be possible you have a node with an account did not expect?

The Nodes table is already being joined so you only need to select the additional tables. I didn't take time to look into the Icon table but this runs in SWQL Studio. SELECT DISTINCT AlertObjects.EntityDetailsURL, Nodes.Caption AS NodeName, Nodes.Status as NodeStatus, Nodes.DetailsURL,…

I skip the 'Advanced' options now and just use the old method when rotating passwords. 

Interesting, we are using Zabbix as well. 

When I tested if you omit the domain\ then most other tables would show but the NCM tables were blank. 

Your latitude and longitude numbers appear odd, they should look like this format 30.2672, 97.7431

I was able to replicate it. Try either domain/ in from of your username or using a different method to authenticate. API not returning NCM data - Forum - The Orion Platform - THWACK (solarwinds.com) This worked in my environment. If I set it to other options the query fails. Also once you get the queries working the query…

If you are trying to match a region to a single long/lat and you have a region custom property you could also do that using an alert with logic such as if region= a and custom property region is blank... then the alert action would fill in the Long/Lat with the appropriate data. You could leave the alert running…

If you are trying to import data into the database from a spreadsheet you can directly import it in Custom Properties. Just use IP field as the match and import the long/lat into the appropriate WorldMap long/lat columns. Below is the Classic view 

Are you able to see the server/database on the left panel after you connect? You should be able to expand that selection and see the tables in the database. I usually use V3 AD for my connection, then it uses my logged in credentials. In addition what ever user you are logged into your computer as also needs the…

Just a note, the data in the database gets averaged up over time depending on your settings. So the first week of the report may be samples every poll, but after a time period it rounds it up to average per hour, day, week etc. If you want to keep the most detailed info, consider running your reports more frequently and…

There is a custom property that has World Map after it. Those are the ones you need to put the coordinates in. I'm using 'Classic View' for custom properties but these are the ones you want to populate for the map to work In the 'Classic View' Column Selector they appear here Also in the database they are not in the custom…

Try looking here. There is an NCM.Nodes table to get you started (further down than my screen capture)

SELECT TOP 10 NodeID FROM Orion.Nodes

I have a split instance and A and B can not see each other's nodes or alerts. Not sure if that covers everything across all products but it has worked for my needs.

You can use your own names, I don't use the default ones. During the installation you will be asked if you want to create a new database or connect to an existing one, choose connect to existing. Then you can type in the database name and chose authentication method and put in the password.