When you want to delete devices in bulk
The following stored procedure will add the DeviceID 3, 4, 5, 6, 7, 8, 20, 35, 23
Example: exec model.sendDeviceToDeletionQueue 3 exec model.sendDeviceToDeletionQueue 4 exec model.sendDeviceToDeletionQueue 5 exec model.sendDeviceToDeletionQueue 6 exec model.sendDeviceToDeletionQueue 7 exec model.sendDeviceToDeletionQueue 8 exec model.sendDeviceToDeletionQueue 20 exec model.sendDeviceToDeletionQueue 35 exec model.sendDeviceToDeletionQueue 23
You can check the status of the delete device status using the following SQL Statement:
select * from Model.DeviceDeletionQueue
Related articles