Fields added only when data is stored in the Store database
The following table lists the fields that are added only when data is stored in the Store database:
|
PFM - View name (PFM - Manager name) |
Description |
Frmt |
Delta |
Sup. ver. |
Data source |
|---|---|---|---|---|---|
|
Agent Host (DEVICEID) |
Name of host where PFM - Agent is running |
string(256) |
No |
All |
-- |
|
Agent Instance (PROD_INST) |
Instance name of PFM - Agent |
string(256) |
No |
All |
-- |
|
Agent Type (PRODID) |
Product ID of PFM - Agent (1-byte identifier) |
char |
No |
All |
-- |
|
Date (DATE) |
Record creation date (GMT)#1, #3 |
char(3) |
No |
All |
-- |
|
Date and Time (DATETIME) |
Combination of the Date (DATE) and Time (TIME) fields#3 |
char(6) |
No |
All |
-- |
|
Drawer Type (DRAWER_TYPE) |
Data summarization type (for a record of the PI record type). The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.#2 |
char |
No |
All |
-- |
|
GMT Offset (GMT_ADJUST) |
Difference (in seconds) between Greenwich Mean Time and local time |
long |
No |
All |
-- |
|
Time (TIME) |
Record creation time (GMT)#1, #3 |
char(3) |
No |
All |
-- |
- Legend:
-
Smry: Summary
Frmt: Format
Sup. ver.: Supported version
--: Indicates that the field's value is obtained without processing the performance data acquired from SAP system.
- #1
-
The referencing 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:
Type
Setting value for each record type
Minute
0 second of the time when the record was created.
Hour
0 minute and 0 second of the time when the record was created.
Day
0:00 and 0 second of the day when the record was created.
Week
0:00 and 0 second on Monday of the week when the record was created.
Month
0:00 and 0 second on the 1st day of the month when the record was created.
Year
0:00 and 0 second on January 1st of the year when the record was created.
- #2
-
The following table shows the type displayed in PFM - Web Console reports and the type displayed using the ODBC driver:
Type
PFM - Web Console
ODBC driver
Minute
Minute
m
Hour
Hour
H
Day
Day
D
Week
Week
W
Month
Month
M
Year
Year
Y
- #3
-
If data is displayed using a report or ODBC driver, the Date field is displayed in the format YYYYMMDD, the Date and Time field in the format YYYYMMDD hh:mm:ss, and the Time field in the format hh:mm:ss.