To delete the files from the DSM Database, do the following:
- Determine the "HostID" and "BIOS UUID" of the VM from which you wish to delete more than a 100 quarantined files.
- You can query the DSM SQL Database to determine "HostID" and "BIOS UUID".
select * from hosts where Hostname like '%YOUR_PC_NAME%'
- You can query the DSM SQL Database to determine "HostID" and "BIOS UUID".
- Open the DSM Console and go to Computer > VM console > Overview > VMware Virtual Machine Summary.
- Find the value of "Bios UUID" and take note of the UUID.
- You can query the DSM SQL Database to determine "HostID" and "BIOS UUID".
- Procced to manually delete the events and files from the DSM SQL Database (for example: the HostID is 89; UUID of the VM is:42149a0e-a867-2174-90de-814eb00a6b83)
- Use the command below to query the Anti-Malware Events for their existence first.
select * from antimalwarequarantinedfile where HostID = 89
- Use the command below to delete the Anti-Malware Events form the DSM SQL Database:
delete from antimalwarequarantinedfile where HostID = 89
- Use the command below to query the Anti-Malware Events for their existence first.
To delete the quarantined files from DSVA, do the steps below:
- Login to the DSVA, using SSH with Putty.
- Switch to the user "root" with the command "#~ sudo -bash" and enter your DSVA Password.
- Navigate to the location of the quarantined files within the DSVA.
"#~ cd /var/opt/ds_agent/guests/42149a0e-a867-2174-90de-814eb00a6b83/quarantined"
!! Note !! The UUID from Point [A] remsins for this task - Delete all Quarantined Files for this UUID.
"rm -rf *.qtn"