We are getting errors from the remove_not_present_items.sh script in DX NetOps Performance Management.
According to the Errors running the remove_not_present_items.sh script Knowledge Base article there are to many items for it to manage.
We can use the script deleteRetiredItemsInFile.pl script attached to this article to remove the items.
All supported DX NetOps Performance Management releases
Buildup of retired items created a data set to large for the remove_not_present_items.sh script to work with.
The attached script requires a list of Item_ID values in a file to work with for deletion requests.
To generate the list of IDs we use a vsql prompt on the Data Repository database.
When the script runs it issues a curl statement to the DA /rest/retired API with deletion calls for each Item_ID in the list of IDs it's provided.
Complete the following steps to delete the retired items.
To monitor deletion run the vsql command in step 1.3 and monitor the Retired item counts. They should be decreasing as the script runs.