Fields that are added only when a record is recorded in the Store database
The table below shows the fields that are added only when data is being recorded in the Store database.
|
PFM - View name (PFM - Manager name) |
Explanation |
Format |
Delta |
Supported version |
Data source |
|---|---|---|---|---|---|
|
Agent Host (DEVICEID) |
Name of the host on which PFM - RM for Virtual Machine is running |
string (256) |
No |
All |
-- |
|
Agent Instance (PROD_INST) |
PFM - RM for Virtual Machine instance name |
string (256) |
No |
All |
-- |
|
Agent Type (PRODID) |
PFM - RM for Virtual Machine product ID, expressed as a 1-byte ID |
char |
No |
All |
-- |
|
Date (DATE) |
Date on which the record was created. Greenwich Mean Time#1, #2 |
char (3) |
No |
All |
-- |
|
Date and Time (DATETIME) |
Combination of Date (DATE) field and Time (TIME) field#2 |
char (6) |
No |
All |
-- |
|
Drawer Type (DRAWER_TYPE) |
For a record of the PI record type, this is the category in which data is summarized. The category display differs depending on whether the record is displayed as a report on PFM - Web Console, or whether it is displayed using an ODBC driver.#3 |
char |
No |
All |
-- |
|
GMT Offset (GMT_ADJUST) |
Difference between Greenwich Mean Time and the local time, in seconds |
long |
No |
All |
-- |
|
Time (TIME) |
Time at which the record was created. Greenwich Mean Time#1, #2 |
char (3) |
No |
All |
-- |
- Legend:
-
--: The field stores the raw (not altered) value of performance data acquired from the monitoring-target environment.
- #1
-
Since a record of the PI record type summarizes data, the time used as the basis for summarizing data is specified. The following table indicates the setting for each record category.
Table 5‒9: Setting for each record category Category
Setting for each record category
Minute
The 0th second of the time at which the record was created
Hour
The 0th minute and 0th second of the time at which the record was created
Day
The 0th hour, 0th minute, and 0th second of the time at which the record was created
Week
The 0th hour, 0th minute, and 0th second of the Monday of the week in which the record was created
Month
The 0th hour, 0th minute, and 0th second of the first day of the month in which the record was created
Year
The 0th hour, 0th minute, and 0th second of January 1st of the year in which the record was created
- #2
-
When data is displayed in a report or by 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 table below shows the difference in data summary category between a report displayed on PFM - Web Console and data displayed using the ODBC driver.
Table 5‒10: Difference in data summary category depending on the display method Category
PFM - Web Console
ODBC driver
Minute
Minute
m
Hour
Hour
H
Day
Day
D
Week
Week
W
Month
Month
M
Year
Year
Y