HP System Reporter E-Media Kit manual Sample Data and Inventory Tables, 10.14, Recentsample Table

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.

Table 10-10.recentsample_1 Table

Column	Type	Comment
resolution	VARCHAR(32) NOT	The sample resolution, one of hires, hourly or
	NULL	daily.
tsecs	INTEGER NOT	Sample time in secs of the most recent complete
	NULL	sample of the resolution. This is the Unix time
		and is the number of seconds since 0:00:00 Jan 1,
		1970 GMT.

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 <res> 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

10.14

The Sample Data and Inventory Tables