Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 Find ID for Delete Routines

Image Modified  

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


Image Modified

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


Image Modified  

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


Image Modified

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

 

Remove Scanned Device

Image Modified

EXEC DeviceEX_de  22


Image Modified

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

Image Modified  

DELETE FROM FoundDevice WHERE FoundDeviceID=44


Image Modified

DELETEF ROM FoundDeviceScanHistory WHERE FoundDeviceID=44


Image Modified

DELETE FROM FoundDeviceCredentialHistory WHERE FoundDeviceID=44


Image Modified

DELETE FROM FoundDevicePort WHERE FoundDeviceID=44

 

Remove Found Applicaton

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

Image Modified

DELETE FROM FoundApplication WHERE FoundApplicationid=33


Image Modified

DELETE FROM FoundApplicationCredentialHistory WHERE FoundApplicationid=33


Image Modified

DELETE FROM FoundApplicationScanHistory WHERE FoundApplicationid=33

 

Filter by label (Content by label)
showLabelsfalse
max5
spaces~Glen.Epperson
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-troubleshooting-article" and type = "page" and space = "~Glen.Epperson"
labelskb-troubleshooting-article

...