How do I delete the Wbem Inventory information?

book

Article ID: 49963

calendar_today

Updated On:

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: