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

The 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.

The model handle will be reported as a binary number within MySQL and needs to be converted to Hex to locate within OneClick

Example:

SRM = One Click

model_h: 558182394 = 21452FFA

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.