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 to queue to delete the device.
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
To check the status of the devices that are currently queued.
SQL Statement:
select * from Model.DeviceDeletionQueue
The Delete can still be used in the UI as the same stored procedure runs when you confirm the deletion from the UI.
Related articles