Tables inv_generalinventory* appear on 2 different schemas

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

Reviewing the database it's found that inv_generalinventory_item and inv_generalinventory_tree tables are duplicated, one set can be found under dbo. and the other under ca_itrm. schema:

Environment

Client Automation 14.x

Resolution

By default all tables that are created during the installation of the MDB will be created by dbo. user, so after a new Domain Manager is installed, all tables will be created under this schema. Then, any new tables created after the installation, will be created by ca_itrm user, so it's expected that some tables are tied to one schema or another, depending of the moment they were created.

Specifically to the inv_generalinventory* tables, if a new inventory/template inventory module is configured in the environment, a new table will be created by the Engine using ca_itrm, so it's expected to have the same table on both schemas, since the first one (under dbo.) was created during the installation, and the other one (under ca_itrm.) was created later by the Engine because probably there are some inventory tasks created on the environment.

Once this happens, the DM will use both tables at the same time, since some data is stored on table under dbo. (for example, basic inventory) and the collected information from any new inventory task will be stored under ca_itrm.