This table contains the inventory items for all external assets similar to i.e. inv_generalinventory_item
| Column Name | Column Datatype | Column Null Option | Column Comment |
| item_parent_id | integer | not null | Primary Key. Foreign key to inv_externaldevice_tree. Points to the tree that this Item belongs to. |
| item_name_id | integer | not null | Primary Key. Foreign key to inv_item_name_id. Describes the name for this item. |
| object_uuid | byte(16) | not null | Primary Key. Foreign key to either ca_discovered_hardware, ca_discovered_user, ca_link_hw_user. |
| item_root_id | integer | with null | Foreign key to inv_externaldevice_tree. Points to the root tree that this item belongs to. |
| item_root_name_id | integer | with null | Name id of the root item. Foreign key to inv_tree_name_id. |
| item_parent_name_id | integer | with null | Name id of the parent item. Foreign key to inv_tree_name_id. |
| item_index | integer | with null | Index for this item. Placement for all items pointing to the same mother tree. |
| item_type | integer | with null | Data type of the item ( 1=text, 2=numeric, 3=double) |
| item_format | integer | with null | Additional value format qualifier. 500=Text, 200=long,300=double |
| item_value_text | nvarchar(384) | with null | Value in text, if item_type is text |
| item_previous_value_text | nvarchar(384) | with null | Previous value in text, if item_type is text. |
| item_value_long | integer | with null | Value in numeric, if item_type is numeric |
| item_previous_value_long | integer | with null | Previous value in double, if item_type is double |
| item_value_double | float4 | with null | Value in double, if item_type is double |
| item_previous_value_double | float4 | with null | Previou value in double , if item is double |
| item_date | integer | with null | Date in seconds since 1.1.1970 when this item was stored. |
| item_lock | integer | with null | If the value is locked it can't be updated. 0=unlocked. 1=locked. |
| domain_uuid | byte(16) | with null | Foreign key to the ca_n_tier table. Can normally also be found in ca_settings table where set_id=1 |
| auto_rep_version | date | with null | Replication version |
| object_type | integer | with null | Object Owner Type. 1=Computer, 2=User |
Product Name: Unicenter Desktop and Server Management
Table Type: Table