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

10.14 The Sample Data and Inventory Tables
3PAR System Reporter User’s Guide System Reporter 2.8
10.3.10 The recentsample Table
The recentsample_1 table contains a row for each sample resolution containing the time of
the most recent sample for that resolution.
Beginning with the 2.4.1 release System Reporter inserts data from each InServ system into the
database separately. Consequently, a given data table at a specific time may contain data from
only some of the systems since the remaining systems’ data may not have been inserted yet. In
order to avoid reporting on such partial samples, System Reporter updates the recentsample
table with the time of the most recent complete sample for each resolution.
10.4 The Sample Data and Inventory Tables
The sample data tables include the space and performance samples of various objects in the
InServ systems. For each type of sample, there are three separate tables, one for each sampling
resolution:
■ hires - High resolution samples
■ hourly - Hourly samples
■ daily - Daily sample.
The tables for the different resolutions are identical in their structure. In the table names, the
substring can be replaced by either hires, hourly or daily.
The database often needs to be queried to determine all the objects that are present in the
table. Often, this information is used to populate the menus in a web browser or Excel client.
Since the data tables can be very large, this type of query can take a long time in spite of
Table 10-10. recentsample_1 Table
Column Type Comment
resolution VARCHAR(32) NOT
NULL
The sample resolution, one of hires, hourly or
daily.
tsecs INTEGER NOT
NULL
Sample time in secs of the most recent complete
sample of the resolution. This is the Unix time
and is the number of seconds since 0:00:00 Jan 1,
1970 GMT.