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

10.4 Administrative Tables
3PAR System Reporter User’s Guide System Reporter 2.8
10.3.3 The system Table
The system_3 table contains a row for each InServ system that has been sampled. A single
physical InServ may have multiple entries in this table because any changes in the columns for
that system will result in a new row in the table.
Table 10-3. system_3 Table
Column Type Comment
uniq_id INTEGER PRIMARY
KEY
(AUTO_INCREMENT)
A unique identifier for the InServ system
instance. All samples in the data tables have
this uniq_id in the sys_uid column.
serial INTEGER NOT NULL Serial number of the InServ.
name VARCHAR(32) NOT
NULL
InServ system name, This is what gets used in
most reports to identify the system.
mhz INTEGER NOT NULL The CPU frequency in MHz. For os_rev prior
to 2.2.2, the MHz is used to calculate the
times for the service time histogram buckets.
For os_rev of 2.2.2 or later, the service time
histogram buckets are in terms of absolute
time in milliseconds rather than relative to
CPU frequency. See Service Time Histogram
Buckets on page 10.36.
ip_name VARCHAR(32) NOT
NULL
IP Address of the system.
os_rev VARCHAR(32) NOT
NULL
InFormOS revision. This is needed in some
cases to determine how to interpret some
data. For example, see the mhz column
description above.
system_model VARCHAR(32) NOT
NULL
System hardware model, for example:
InServ S400X
InServ T400