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?
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
Release : 10.x
Component : Spectrum Core / SpectroSERVER
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.