HP System Reporter Media Kit, System Reporter E-Media Kit manual 10.39, Statpdinv Table

System Reporter 2.8 3PAR System Reporter User’s Guide

10.4.11 The statpdinv Table

The statpdinv_<res>_2 table holds inventory for the statpd_<res>_3 table.

Table 10-22.statpdinv_<res>_2 Table

Column	Type	Comment
tsecs	INTEGER NOT	Sample time in secs. This is the Unix time
	NULL	and is the number of seconds since
		0:00:00 Jan 1, 1970 GMT.
sys_uid	INTEGER NOT	A unique identifier for the InServ system
	NULL	instance refers to the uniq_id for the
		InServ system instance in the system_3
		table.
pdid	INTEGER NOT	The physical disk ID.
	NULL
port_n	INTEGER NOT	The node that the disk’s primary port is
	NULL	connected to (the “n” part of n:s:p).
port_s	INTEGER NOT	The PCI slot in the node that the disk’s
	NULL	primary port is connected to (the “s” part
		of n:s:p).
port_p	INTEGER NOT	The port number in the PCI slot in the
	NULL	node that the disk’s primary port is
		connected to (the “p” part of n:s:p).
disktype	VARCHAR(32) NOT	The disk type. Currently, the disk types
	NULL	are:
		■ FC - Fibre channel drive.
		■ NL - Nearline drive.
diskspeed	INTEGER NOT	The approximate disk speed in K RPM.
	NULL

The Sample Data and Inventory Tables

10.39