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

book

Article ID: 195558

calendar_today

Updated On:

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.