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.
|
PFM - View name (PFM - Manager name) |
Description |
Format |
Delta |
Supported version |
|---|---|---|---|---|
|
Agent Host (DEVICEID) |
Identifier including the name of the host where PFM - RM for Platform is running |
string (256) |
No |
All |
|
Agent Instance (PROD_INST) |
Instance name of PFM - RM for Platform |
string (256) |
No |
All |
|
Agent Type (PRODID) |
Product ID of PFM - RM for Platform, expressed as a 1-byte identifier |
char |
No |
All |
|
Date (DATE) |
Record creation date, in GMT (Greenwich Mean Time)#1, #2 |
char (3) |
No |
All |
|
Date and Time (DATETIME) |
Combination of the Date (DATE) and Time (TIME) fields#2 |
char (6) |
No |
All |
|
Drawer Type (DRAWER_TYPE) |
For a record of the PI record type, the data summarization type. The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.#3 |
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 in GMT (Greenwich Mean Time)#1, #2 |
char (3) |
No |
All |
- #1
-
A relative time during summarization is set because data is summarized for records of the PI record type. The following table shows the setting for each record type:
|
Type |
Setting for each record type |
|---|---|
|
Minute |
At the 0 second of the time when the record was created. |
|
Hour |
At the 0 minute and 0 second of the time when the record was created. |
|
Day |
At 00:00:00 of the day when the record was created. |
|
Week |
At 00:00:00 on Monday of the week when the record was created. |
|
Month |
At 00:00:00 on the first of the month when the record was created. |
|
Year |
At 00:00:00 on January 1st of the year when the record was created. |
- #2
-
When data is displayed in reports and by the ODBC driver, 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.
- #3
-
The following table shows the summary type displayed in PFM - Web Console reports and the type displayed when the ODBC driver is used.
|
Type |
PFM - Web Console |
ODBC driver |
|---|---|---|
|
Minute |
Minute |
m |
|
Hour |
Hour |
H |
|
Day |
Day |
D |
|
Week |
Week |
W |
|
Month |
Month |
M |
|
Year |
Year |
Y |