Need help repairing a Custom SQL alert trigger

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

JOIN NodesStatistics s ON d.NodeID = s.NodeID

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?

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'

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?

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?

I think the report is the best option. Not sure how you can use an alert for this.

If you use a Custom SWQL resource, something like the following:

SELECT n.Caption as Node ,i.Caption as Interface, InTotalBytes, OutTotalBytes

FROM Orion.NPM.InterfaceTraffic t

JOIN Orion.Nodes n ON t.NodeID = n.NodeID

JOIN Orion.NPM.Interfaces i ON t.InterfaceID = i.InterfaceID

WHERE DateTime <ADDDATE('Day',-30,GetDate())

AND InTotalBytes = '0'

AND OutTotalBytes = '0'