Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Need help repairing a Custom SQL alert trigger

I had a neat little alert/report combo going that is now broken. I think it is due to the fact that the LastSystemUptimePollUtc variable has apparently been moved from the NodesData table to the NodesStatistics table in the 2019.4 database schema.

If so, I do not know how to construct a JOIN of those two tables.

Basically, what I am trying to do is have an alert that will change the value of a node custom property to "Yes" when a node has been down for a certain period of time. The report then simply lists the nodes that meet the criteria. I would also like to do something similar for interfaces that have not passed traffic for some period of time.

Anyone care to help? Much appreciated.

Find more posts tagged with

Accepted answers

TerryHarding

SELECT n.NodeID ,n.Caption FROM Nodes n

JOIN NodesStatistics s on n.NodeID = s.NodeID

WHERE s.LastSystemUpTimePollUTC <DATEADD(DAY,-10,GetDate())

AND n.ToBeDeleted<>'1'

All comments

TerryHarding

SELECT whatever fields from the NodesData table ,s.LastSystemUptimePollUtc FROM NodesData d

JOIN NodesStatistics s ON d.NodeID = s.NodeID

patriot

That produced errors. Maybe it would help if I posted a picture of the custom SQl trigger that used to work:

As i said, the Last SystemUpTimePollUtc data is now in the NodesStatistics table, but I cannot decide what the modified query should be, OR if I can even use it in the alert trigger. any further thoughts?

TerryHarding

SELECT n.NodeID ,n.Caption FROM Nodes n

JOIN NodesStatistics s on n.NodeID = s.NodeID

WHERE s.LastSystemUpTimePollUTC <DATEADD(DAY,-10,GetDate())

AND n.ToBeDeleted<>'1'

patriot

Great. Thanks for the help. It worked fine. Now, how would I do a similar thing for interfaces that have not passed traffic in a certain number of days? I think I will use In_TotalBytes and Out_TotalBytes, but what would the date/time stamp part of the query look like?

patriot

Another option would obviously be to do this as a report. However, I can;t seem to find the variable that would allow me to set the time frame. Do you know what Category and Variable I need?