Identify down nodes by last system Poll

Version 1

    I created a report querying all nodes in a down, unmanaged,
    or shutdown state.  The report displays the data by the last system poll
    ascending.  This report will help us eliminate nodes from SolarWinds where
    the device was missed from proper decommission process.

     

    select

    a.caption,
    a.ip_address,
    a.status,
    b.systemuptime,
    b.lastsystemuptimepollutc

    from nodesdata as a (nolock)
    join nodesstatistics as b (nolock) on (b.nodeid = a.nodeid)

    where (a.status = 2 OR a.status = 4 OR a.status = 9)

    order by lastsystemuptimepollutc asc