Fields added only when data is stored in the Store database
The table below shows the fields that are added only when data is stored in the Store database.
Table 8-7 Fields that are added only when a record is 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 - Agent is running | string(256) | No | All | -- |
Agent Instance (PROD_INST) | Name of the host on which PFM - Agent is running | string(256) | No | All | -- |
Agent Type (PRODID) | Product ID of PFM - Agent indicated as a 1-byte identifier | char | No | All | -- |
Date (DATE) | Date on which the record was created (Greenwich Mean Time)#1, #3 | char (3) | No | All | -- |
Date and Time (DATETIME) | Combination of the Date (DATE) field and the Time (TIME) field#3 | char (6) | No | All | -- |
Drawer Type (DRAWER_TYPE) | For records of the PI record type, the data summarization category is indicated. The displayed category differs depending on whether the report is displayed in PFM - Web Console or using the ODBC driver.#2 | char | No | All | -- |
GMT Offset (GMT_ADJUST) | Difference between the 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, #3 | char (3) | No | All | -- |
Table 8-8 Setting for each record category
Category | Setting for each record category |
---|---|
Minute | 0 seconds for the time at which the record is created |
Hour | 0 minutes and 0 seconds for the time at which the record is created |
Day | 0 hours, 0 minutes, and 0 seconds for the day on which the record is created |
Week | 0 hours, 0 minutes, and 0 seconds for the week in which the record is created |
Month | 0 hours, 0 minutes, and 0 seconds for the first day of the month in which the record is created |
Year | 0 hours, 0 minutes, and 0 seconds of January 1 of the year in which the record is created |
Table 8-9 Differences in data summarization category according to 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 |