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:

1. 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.

2. 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.