Remove Devices and Applications

Problem

There are two stored procedures in the iQSonar-Data(2.9+) database that are used to remove individual Devices or Applications. They require the Deviceid or ApplicationID of the entry that is to be deletes. These commands will remove all information about the Device or Application including entries in the FoundDevice and FoundApplication tables. This cannot be reversed and restoring a backup of the database is the only recovery method once the commands have been issued for a Device or Application.

Solution

The SQL below can be used to establish a founddeviceid, deviceid, foundapplicationid or applicationid:

Find ID for Delete Routines

SELECT Founddeviceid FROM[FoundDevice]WHERE Hostname LIKE ‘%servername%’

SELECT Deviceid FROM[Device] Hostname LIKE ‘%servername%’

SELECT Foundapplicationid FROM[FoundApplication] WHERE Hostname LIKE ‘%servername%’

SELECT ApplicationID FROM [ApplicationDatabase] WHERE Hostname LIKE ‘%servername%’

Remove Scanned Device

EXEC DeviceEX_de 22

EXEC ApplicationEX_de 22

Remove Found Device

To remove a target that has not been scanned, the records must be deleted manually in the following tables or orders where the founddevice' to be removed is 44

DELETE FROM FoundDevice WHERE FoundDeviceID=44

DELETEF ROM FoundDeviceScanHistory WHERE FoundDeviceID=44

DELETE FROM FoundDeviceCredentialHistory WHERE FoundDeviceID=44

DELETE FROM FoundDevicePort WHERE FoundDeviceID=44

Remove Found Applicaton

To remove a found application that has not been scanned, delete from the following tables:

DELETE FROM FoundApplication WHERE FoundApplicationid=33

DELETE FROM FoundApplicationCredentialHistory WHERE FoundApplicationid=33

DELETE FROM FoundApplicationScanHistory WHERE FoundApplicationid=33