Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

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

You can also 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.


Delete Device from UI



  • No labels