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. |
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 reports, the Date field is displayed in the format YYYYMMDD, the Date and Time field is displayed in the format YYYYMMDD hh:mm:ss, and the Time field is displayed in the format hh:mm:ss.