How do I delete the Wbem Inventory information?

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Server Automation
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

How do I delete the Wbem Inventory information from all the agents?

Solution:

Run the following commands on the SQL server directly after taking a complete backup of the MDB database:

   delete from inv_wbeminventory_tree;    
   delete from inv_wbeminventory_item; 

This will delete all the information related to WBEM inventory from the database.

Note: Please make sure that you take a complete backup of the MDB before doing this operation.

Environment

Release: UASIT.99000-12.5-Asset Intelligence
Component: