Remove Devices and Applications

Owned by Glen Epperson (Unlicensed)
Last updated: Nov 03, 2017 by Conor McCann

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

 

Filter by label

There are no items with the selected labels at this time.