We had an issue with our SQL Database Backups, slowing the read-writes to our database. Items were not being updated and therefore our status and alerts were not current or correct. We created an custom SQL Alert to let us know when nodes are not being updated within the correct polling interval in the database, excluding unmanaged resources.
Select Caption, LastSync, Status,EngineID
Where Status not like '9' and LastSync <= dateadd(minute, -5, getdate())
Order By LastSync
When then created this report for our team and our NOC to allow us to quickly identify how far behind the database is, if it is isolated to one of our three pollers and/or isolated to a group of nodes..