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:
Table 9-7 Fields that are added only when a record is recorded in the Store database
View name (Manager name) | Description | Format | Delta | Supported version | Data source#1 |
---|---|---|---|---|---|
Agent Host (DEVICEID) | Name of host where PFM - Agent is running | string(256) | No | All | -- |
Agent Instance (PROD_INST) | Name of host where PFM - Agent is running | 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 #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, this is 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 (GMT)#1 #2 | char(3) | No | All | -- |
Table 9-8 Setting for each record category
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 |
Table 9-9 Differences in data summarization category according to the display method
Type | PFM - Web Console | ODBC driver |
---|---|---|
Minute | Minute | m |
Hour | Hour | H |
Day | Day | D |
Week | Week | W |
Month | Month | M |
Year | Year | Y |