Fields added only when data is stored in the Store database

The table below shows the fields that are added only when data is stored in the Store database.

Table 8-7 Fields that are added only when a record is recorded in the Store database

PFM - View name
(PFM - Manager name)
ExplanationFormatDeltaSupported versionData source
Agent Host
(DEVICEID)
Name of the host on which PFM - Agent is runningstring(256)NoAll--
Agent Instance
(PROD_INST)
Name of the host on which PFM - Agent is runningstring(256)NoAll--
Agent Type
(PRODID)
Product ID of PFM - Agent indicated as a 1-byte identifiercharNoAll--
Date
(DATE)
Date on which the record was created (Greenwich Mean Time)#1, #3char (3)NoAll--
Date and Time
(DATETIME)
Combination of the Date (DATE) field and the Time (TIME) field#3char (6)NoAll--
Drawer Type
(DRAWER_TYPE)
For records of the PI record type, the data summarization category is indicated. The displayed category differs depending on whether the report is displayed in PFM - Web Console or using the ODBC driver.#2charNoAll--
GMT Offset
(GMT_ADJUST)
Difference between the Greenwich Mean Time and the local time, in secondslongNoAll--
Time
(TIME)
Time at which the record was created (Greenwich Mean Time)#1, #3char (3)NoAll--
Legend:
--: Indicates that the performance data acquired from UNIX is not processed and set as a field.
#1
In records of the PI record type, data is summarized, and therefore the time used as the reference point for summarization is set. The table below shows the setting for each record category.

Table 8-8 Setting for each record category

CategorySetting for each record category
Minute0 seconds for the time at which the record is created
Hour0 minutes and 0 seconds for the time at which the record is created
Day0 hours, 0 minutes, and 0 seconds for the day on which the record is created
Week0 hours, 0 minutes, and 0 seconds for the week in which the record is created
Month0 hours, 0 minutes, and 0 seconds for the first day of the month in which the record is created
Year0 hours, 0 minutes, and 0 seconds of January 1 of the year in which the record is created
#2
The table below shows the differences in display depending on whether the report is displayed on PFM - Web Console or using the ODBC driver.

Table 8-9 Differences in data summarization category according to the display method

CategoryPFM - Web ConsoleODBC driver
MinuteMinutem
HourHourH
DayDayD
WeekWeekW
MonthMonthM
YearYearY
#3
When data is displayed in a report or by using the ODBC driver, the Date field uses the YYYYMMDD format, the Date and Time field uses the YYYYMMDD hh:mm:ss format, and the Time field uses the hh:mm:ss format.