I recently updated the FlexNet Inventory settings to exclude collecting file evidence from the recycle bin. Unfortunately we have over 20,000 file evidence records from the recycle bin across our organization and the max rows you can display and select in the WebUI for discovered evidence is 100 records.
Does anyone in the community have a SQL script for bulk removing the file evidence from the compliance and inventory database they can share?
Our issue is that we are seeing false installation counts from files that are in the recycle bin and I want to completely clean up any remnants of this discovered evidence from the system.
TIA!
Dan
