Fields that are added only when a record is recorded in the Store database

The following table lists the fields that are added only when data is recorded in the Store database:

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

View name (Manager name)DescriptionFormatDeltaSupported versionData source#1
Agent Host
(DEVICEID)
Name of host where PFM - Agent is runningstring(256)NoAll--
Agent Instance
(PROD_INST)
Name of host where PFM - Agent is runningstring(256)NoAll--
Agent Type
(PRODID)
Product ID of PFM - Agent (1-byte identifier)charNoAll--
Date
(DATE)
Record creation date (GMT)#1 #2char(3)NoAll--
Date and Time
(DATETIME)
Combination of the Date (DATE) and Time (TIME) fields#2char(6)NoAll--
Drawer Type
(DRAWER_TYPE)
For a record of the PI record type, this is the data summarization type.
The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.#3
charNoAll--
GMT Offset
(GMT_ADJUST)
Difference (in seconds) between Greenwich Mean Time and local timelongNoAll--
Time
(TIME)
Record creation time (GMT)#1 #2char(3)NoAll--
Legend:
--: Indicates that the field's value is obtained without processing acquired performance data.
#1
Reference time during summarization is set because data is summarized for records of the PI record type. The following table shows the setting value for each record type:

Table 9-8 Setting for each record category

TypeSetting value for each record type
Minute0 second of the time when the record was created
Hour0 minute and 0 second of the time when the record was created
Day0:00 and 0 second of the day when the record was created
Week0:00 and 0 second on Monday of the week when the record was created
Month0:00 and 0 second on the 1st day of the month when the record was created
Year0:00 and 0 second on January 1st of the year when the record was created
#2
When data is displayed in a report or by using the ODBC driver, the "Date" field is displayed in the YYYYMMDD format, the "Date and Time" field is displayed in the YYYYMMDD hh:mm:ss format, and the "Time" field is displayed in the hh:mm:ss format.
#3
The following table shows the differences in display depending on whether the report is displayed on PFM - Web Console reports, and using the ODBC driver:

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

TypePFM - Web ConsoleODBC driver
MinuteMinutem
HourHourH
DayDayD
WeekWeekW
MonthMonthM
YearYearY