- Fire the following query and note the <r_object_id> of the latest version of xcp_atrifact_bundle
select r_object_id, namespace, r_version_label from xcp_artifact_bundle (all) where namespace='<namespace>’
- Fire the following query to delete all the older versions. Be very careful in noting the object ID. It should be the object ID of the latest version of the object.
delete xcp_artifact_bundle (all) objects where namespace = ‘<namespace>’ and r_object_id != ‘<r_ojbect_id> noted in first query’
- Once the objects are deleted, run dm_DMClean job to purge the older objects and its content from repository by navigating to “Job Management” > Jobs. Select dm_DmClean job. Right click and run.
You can do the same clean up for the xcpui, xcpcommons and xCP core in the xcp_artifact_bundle.