Queries using additional inventory in dynamic groups show empty list after recreation of tables

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

After removing/deleting additional inventory the related tables they should be recreated if the 
data (.mnv file) is still available and recollected from an agent, then then inventory will show
again under Additional Inventory.

Client Automation - Remove/Delete Additional Inventory

But if there exist any dynamic group which uses the additional inventory data in a query then it 
will return an empty list of computers.

Environment

Client Automation - All versions

Cause

The query associated with the dynamic group uses the index values in the additional inventory 
tables, but when they have to be recreated these values changes.

Resolution

Recreate the affected queries associated to the dynamic groups, so they will be rebuit with the 
newer indexes values, then returning the list of computers according the selected columns as 
before.