Deleting ITAM Tables from MDB

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager
• ServiceDesk
• ASSET PORTFOLIO MGMT- SERVER
• CA IT Asset Manager Asset Portfolio Management
• CA Service Management - Asset Portfolio Management

Issue/Introduction

The environment has both SDM and ITAM, both sharing the same MDB database.  When decomissioning and uninstalling ITAM, how can we delete ITAM data from the MDB in order to reclaim database space?

Environment

Service Desk Manager 17.x

IT Asset Portfolio Manager 17.x

Resolution

There are some tables in the MDB database that are only used by SDM, some that are only used by APM, and some that are shared by both products.  We do not have a specific listing of which tables fall into which of these categories.   So it is not as simple as dropping the "ITAM" portion database.  Due to the risk of deleting data shared by both applications, this action is not recommended or supported.