Article Original Creation Date: 2013-04-08
Overview
Environment
- Solaris 10, Oracle 10, JBoss 4.0.4
- ServiceGateway (SG) 4.2.2
Information
The devices are saved in the database table SPRT_EC_DEVICE
To delete the devices directly from the database, execute the queries listed below:
-
To delete one device:
DELETE FROM sprt_ec_device WHERE ID=<device_id>;
Replace <device_id> with the id of the device to be deleted.
-
To delete multiple devices:
DELETE FROM sprt_ec_device WHERE ID IN (<device_id1,device_id2,device_id3...device_idn>);
Replace <device_id1,device_id2,device_id3...device_idn> with a comma seperated list of Device Ids to be deleted.