ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

SRM devicemodel table destory time is different than OneClick view


Article ID: 195558


Updated On:


CA Spectrum CA eHealth


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


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.