This table is a "info quick lookup" table. It is used when designing queries and reports. Instead of looking in the "live" infotxt,infolng,infodbl,infotree,infoname,infotrnm tables for valid inventory items to report and query on, this table will hold the "distinct" items. It is only used when switching the functionality on. The table is usually maintained by an Engine job.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| domainid | integer | with null | Domain ID. |
| itrtnmid | integer | with null | Item Root Name ID |
| itrtname | varchar(127) | with null | Item Root Name |
| itprnmid | integer | with null | Item Root Name |
| itprname | varchar(127) | with null | Item Parent Name |
| itgrnmid | integer | with null | Item Group Name ID |
| itgrname | varchar(127) | with null | Item Group Name |
| itgrrwnm | varchar(127) | with null | Item Group Row Name |
| itident | integer | not null | Item Ident (1=root, 2=group, 3=group in group, 4=Item etc) |
| itflag | integer | with null | Item Flag. |
| itnameid | integer | with null | Item Name ID |
| itname | varchar(127) | with null | Itemname |
| ittbl | integer | with null | Item Table |
| ittype | integer | with null | Item format (MB, GHZ etc) |
| utype | integer | with null | Unittype that cache row depends on (-1=All) |
Product Name: Unicenter Desktop and Server Management
Table Type: Table