What are the calculations that Solar Winds goes through in determining an alert no longer meets the trigger requirements? Also, what are the mathematical calculations SW uses to determine that an alert should be sent?
A1. Alerts have a trigger condition (that makes them active) and a reset condition (that makes them inactive or 'reset'). It's not a calculation but an SQL query. If the reset condition was 'Node Status is equal to Up' and 'Node Name is equal to Barney' then the where clause for the query would be: where node.caption = 'barney' and node.status = 'up'. By default the reset condition would be checked every minute. You can change that frequency in the alert definition's first tab.
A2. Same answer as question 1 but checking for a node 'down' status on the alert's trigger condition.