To determine the source of the unwanted data, add inventory fields such as INV ID and INV Date to your reports. Verify whether the data entries belong to old inventories. If confirmed, use one of the following methods to clean the data. If the data does not originate from old inventories, log a support case for further assistance.

Option 1 - Delete inventories from the Admin Console UI:

1. Get the INV ID from the report.
2. Log in to the Admin Console UI → Inventory (located at the top-right corner).
3. Find the inventory using the INV ID, then select it and click Delete Selected.

IMPORTANT: Do not click anywhere else in the Admin UI while the deletion is in progress. Doing so will terminate the deletion process.

NOTE: For environments with a large number of inventory records, this method may take several hours. In those cases, consider Option 2 or Option 3.

Option 2 - Delete inventories using SQL:

When there are many inventory records on the server, deleting via the UI may be time-consuming. Using a SQL statement is a more efficient alternative.

1. Get the INV ID from the report for the data to be deleted. For example, INV ID = 284738196.
2. Connect to the BDNA_PUBLISH database.
3. Ensure there is no Normalize task or Catalog sync process running.
4. Run the following SQL statement:
   

   EXECUTE PUBLISH_CLEARDATA @inv_id = 284738196, @task_id = NULL;

Option 3 - Delete Inventory via NormalizeCMD (Recommended for 5.5.82 and later):

From version 5.5.82, inventory deletion can be performed as a background maintenance task using the NormalizeCMD command. This is the recommended approach as it:

• Runs as a background task, eliminating the UI-blocking behaviour in Option 1.
• Allows administrators to monitor deletion progress in real time from the Maintenance page.

Run the following command in a command prompt, replacing <inventoryID> with the relevant INV ID:

NormalizeCMD -DELETEINVENTORY /INVENTORY_ID=<Place inventoryID here>

Progress can be monitored from the Maintenance page in the Admin UI.

The unwanted inventory data will be removed from Analyze reports after performing one of the solutions above.

5.5.82 Release Notes