cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

recovering reporting details for a device that was swapped out using same IP

Morning all, question for you.  I think I already know the answer, however I wanted to make sure.  Last week we had a major issue with a 3750 stack at one of our locations, the device was in place for the better part of a year or so, and we do have data retention / reporting. 

We had to swap the device with a more robust 4510 chassis, and we kept the same IP / discovery as the OLD one.  So my normal SOP is to remove the old node via NPM, which blasts the device from my inventory and also from NCM, then I rediscover. 

Today, someone asked me to pull the CPU stats from the device BEFORE it was swapped.  Is there a way to get the reporting details besides having to do a restore just to get one stinking report?  I think the answer is no, once it is removed, it's details are infact purged.  Just wanted to verify it before they tell me to open a ticket, I'd rather have the details going into the discussion.

thx!

3 Replies
Level 18

To my knowledge, the device stats (CPU, RAM, etc) are purged the night after the delete. Meaning:

When you delete the node, the records from the nodes table (and possibly the "holy trinity" tables - nodes, volumes, interfaces - are moved to a temporary "deleted" table (relatively easy to find if you dig using SQL Management studio or similar toolset).

Then during the nightly maintenance routines, there is a scan for orphan records in each table, and the stats are really and truly deleted.

To circumvent this, we have a routine that pulls the daily detailed stats out to a separate SQL database that has massive storage. Yes, it's a big bad boy. But we only use it for long term data retention, reporting, forensics, etc. The point was to be able to keep Solarwinds nimble but also have the details you are talking about.

Leon Adato | Head Geek
------
"Measure what is measurable,
and make measurable what is not so." - Gallileo

0 Kudos

adatole wrote:

To my knowledge, the device stats (CPU, RAM, etc) are purged the night after the delete. Meaning:

When you delete the node, the records from the nodes table (and possibly the "holy trinity" tables - nodes, volumes, interfaces - are moved to a temporary "deleted" table (relatively easy to find if you dig using SQL Management studio or similar toolset).

Then during the nightly maintenance routines, there is a scan for orphan records in each table, and the stats are really and truly deleted.

To circumvent this, we have a routine that pulls the daily detailed stats out to a separate SQL database that has massive storage. Yes, it's a big bad boy. But we only use it for long term data retention, reporting, forensics, etc. The point was to be able to keep Solarwinds nimble but also have the details you are talking about.

Wow that's keen! I'd just say no to anyone wanting old info that wasn't obtainable easily enough . However, I do unmanage devices for about 1 month when they are decommissioned (not really the same thing as what OP has done) just in case they are put back into production.

But when I replace a device, I will usually just update its details and let it rediscover itself so old data is still available.

0 Kudos
Level 9

Bump?  Anyone ever remove a device and wonder this??

0 Kudos