I have an issue where the Inventory service is not purging records during it's nightly maintenance.
Currently running 9.5 SP3.
50K nodes managed
Inventory service is running and has been restarted.
Set Days to Keep inventory scans to 60 days. Restarted service.
Old inventory was not purged after 5 days and multiple Inv. Service restarts.
Maintenance occurs nightly at 9PM.
I have a query focusing on Last Updated by Inventory Server with column set to show last date updated.
I currently have 8953 devices that should have been purged.
Any ideas on how to get this kick started? I cannot manually delete these records from the console without holding the console hostage for hours and hours. This might be part of the problem. If I tried to delete 1000 nodes, it would take at least a 1/2 day to complete. I know that there are hundreds of related records in other tables that are also deleted in this process. But I would expect at least some progress on these deletions even if maintenance doesn't fully complete it on a nightly basis.
FYI -Event logs indicate that the maintenance service starts at 9pm and finishes in approximately 20 minutes. If I were to manually delete nearly 9K devices, there's no way that it could do it in 20 minutes.
Question: Does DB maintenance purge devices in a more elegant (and efficient) manner than my manual deletion? If not, is this the culprit - that its just too many devices being purged at one time and thus it cannot be completed within the maintenance window? If so, what are my options?
Any and all ideas are welcome!