Keeping track of decommissioned equipment

Is there a way to either see what nodes have been removed from the Solarwinds Database from week to week....or....a way to compare the Node List report from week to week to see what has changed?

Parents Reply Children
  • Below is the query for the node caption, you can add minute as per zone time as the time recorded in the table was in UTC. Below query is as per IST.

    SELECT eventtime, dateadd(minute,330,eventtime) as Deletion_date_IST
    FROM [dbo].[Events]
    Where eventtype='8' and eventtime >= DATEADD (day, -30, getdate()) order by eventtime desc