Duplicate Devices (4281952)

In order to delete a particular Device record in ADM you would need to do it from BT_Device table. However before attempting to delete the record from BT_Device table you need to delete any record for this device  in ADM_DeviceProperty table and ADM_DeviceJOb table first via DeviceID. In other words: 

1.             Look up deviceID for the Device within BT_Device table first.  Do the command below and then execute  with will show you the deviceids in the table

Select * from BT_Device Where Name = 'Device name'

2.             Delete any records from ADM_DeviceJOb & ADM_DeviceProperty table   

Delete from ADM_DeviceProperty Where DeviceID = deviceid number

Delete  from ADM_DeviceJob where DeviceID = devicdeid number

3.             Now delete the device from BT_Device.