inv_performance_tree

Contains the hierarchy of the inventory items from the performance inventory module

Column Name Column Datatype Column Null Option Column Comment
object_uuid byte(16) not null Primary Key. Foreign key to either ca_discovered_hardware, ca_discovered_user, ca_link_hw_user.
item_id integer not null Primary Key . Id of the current node
item_root_id integer with null ID of the Root node. Points to the item_id that is the root of the component.
item_parent_id integer with null Id of the parent node. Points to the item_id that is the parent of this tree item. 0 indicates that this is the root.
item_parent_name_id integer with null Name id of the parent item. Foreign key to inv_tree_name_id. 0 indicates that this is the root.
item_indent integer with null Level for this tree item. 1=Root,2=child to root, etc
item_index integer with null Index for this tree item, among those that points to the same mother tree item.
item_flag integer with null 1=Simple tree structure. 2=Rows.
item_root_name_id integer with null Name id of the root node. Foreign key to inv_tree_name_id
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.
item_name_id integer with null Name id of the current tree item. Foreign key to inv_tree_name_id.
auto_rep_version date with null Replication version information
object_type integer with null Object Owner Type. 1=Computer, 2=User

Product Name: Unicenter Desktop and Server Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.