HP 3PAR System Reporter Software - Manual (Page 335)

10.43 The Sample Data and Inventory Tables
System Reporter 2.8 3PAR System Reporter User’s Guide
10.4.15 The statportinv Table
The statportinv_<res>_1 table holds the inventory for the statport_<res>_2 table.
porttype VARCHAR(32) NOT
NULL
The port type. Currently, the port types
are:
■ disk - Fibre channel ports that disks are
connected to.
■ host -.Fibre channel ports that hosts are
connected to (directly or through a
fabric).
■ rcip - Remote Copy IP ports.
■ rcfc - Remote Copy fibre channel ports.
■ iscsi - iSCSI host ports.
■ free - ports that are not connected.
(common
performance
columns)
The rest of the columns are the common
performance columns described in
Common Performance Table Columns on
page 10.30).
Table 10-25. statport_<res>_2 Table
Column Type Comment
Table 10-26. statportinv_<res>_1 Table
Column Type Comment
tsecs INTEGER NOT
NULL
Sample time in secs. This is the Unix time
and is the number of seconds since
0:00:00 Jan 1, 1970 GMT.
sys_uid INTEGER NOT
NULL
A unique identifier for the InServ system
instance refers to the uniq_id for the
InServ system instance in the system_3
table.