SRM devicemodel table destory time is different than OneClick view

Products

• CA Spectrum
• CA eHealth

Issue/Introduction

We are querying SRM database for custom reporting, and we notice in "devicemodel" table the Destroy time is not the same as what we see in OneClick - what is the cause? 

Cause

Tte device was destroyed and then remodeled. The model_handle has changed, therefore to SRM it is a "different" device even if the same remains the same, since events are tied to Model_handles.

Environment

Release : 10.x

Component : Spectrum Core / SpectroSERVER

Resolution

Check model handles of the device being queries in SRM versus the model handle in OneClick to confirm they are different - this would be why they may have different destory times.