This article explains in detail how to remove the entries from the 'Software Vulnerability Manager Agent scan queue' to clear up disk space and for other reasons you might want that.
The SVM On-Prem solution uses a queue for handling incoming agent scans. Scans end up in this table before they are actually submitted to other tables in the database and thereby made visible in the SVM web interface. This database location can get congested and problems may result out of that.
In the SVM edition for Red Hat Enterprise 7, there is a service named scandaemon which will remove the entries when the entry status is 4, indicating that the scan result has been submitted successfully. It is sometimes necessary to delete old entries from this "queue" due to e.g. lack of disk space.
You can use the below queries to delete the information in the "queue" or identify an ID of an entry (row) from a time frame and delete the entries older than the specified time frame.
NOTE: In the below information where nsi_results/nsi_queue is mentioned the appropriate table name must be selected according to OS version, e.g. nsi_results or nsi_queue.
First, find the relevant ca_xxxxx database (where xxxx is your customer ID)
show databases; use ca_xxxx;
To delete all entries (rows) in the queue:
#On RHEL 6 and RHEL 7 these may differ, use the right one for your setup