Keeping track of decommissioned equipment

We use an alert to save deleted nodes info to a .csv file on a shared drive. In addition, we run a report nightly that writes a .csv file out to the same shared drive that has our complete inventory including all custom properties. Because both files are there we can go back a retrieve all the information about a node even if it has been deleted. This has been extremely helpful on several occasions.

Those are great ideas... love it

did you got the solution for this?

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
,networknode,message
FROM [dbo].[Events]
Where eventtype='8' and eventtime >= DATEADD (day, -30, getdate()) order by eventtime desc