Query on CPU or Hard Disk changed

Products

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

Issue/Introduction

There are some predefined queries for inventory changed :

But how to query for CPU or Hard disk changed ?

Environment

Client Automation - All Versions.

Resolution

CPU changed

Following SQL Query could be used for CPU changed

 

select object_uuid from inv_generalinventory_item, inv_tree_name_id,  inv_item_name_id where inv_tree_name_id.tree_name='$Processors$' and inv_tree_name_id.domain_uuid=(select set_val_uuid from ca_settings where set_id=1) and inv_item_name_id.item_name='Model' and inv_item_name_id.domain_uuid=(select set_val_uuid from ca_settings where set_id=1) and inv_generalinventory_item.item_parent_name_id=inv_tree_name_id.tree_name_id and  inv_item_name_id.item_name_id=inv_generalinventory_item.item_name_id and inv_generalinventory_item.item_value_text<>inv_generalinventory_item.item_previous_value_text

 

This query is based on Processor Model :

 

 

 

 

In Query Designer, click on Advanced Argument. 
In Pseudo Text put "CPU Change" and in Additional WHERE clause put the query above (in a single line, no carriage return inside)

 

 

For Hard Disk change following SQL Query could be used. It is based on Size of Disk under Fixed Drives inventory

 

select object_uuid from inv_generalinventory_item, inv_tree_name_id,  inv_item_name_id
where inv_tree_name_id.tree_name='$Fixed Drives$' and inv_tree_name_id.domain_uuid=(select set_val_uuid from ca_settings where set_id=1) and
inv_item_name_id.item_name='Size' and inv_item_name_id.domain_uuid=(select set_val_uuid from ca_settings where set_id=1) and
inv_generalinventory_item.item_parent_name_id=inv_tree_name_id.tree_name_id and inv_item_name_id.item_name_id=inv_generalinventory_item.item_name_id
and inv_generalinventory_item.item_value_double<>inv_generalinventory_item.item_previous_value_double