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:
Table 5-7 Fields added only when data is stored in the Store database
PFM - View name (PFM - Manager name) | Description | Format | Delta | Data source |
---|---|---|---|---|
Agent Host (DEVICEID) | Name of host where PFM - RM for Microsoft SQL Server is running | string(256) | No | N/A |
Agent Instance (PROD_INST) | Instance name of PFM - RM for Microsoft SQL Server | string(256) | No | N/A |
Agent Type (PROD_ID) | Product ID of PFM - RM for Microsoft SQL Server (1-byte identifier) | char | No | N/A |
Date (DATE) | Record creation date in (GMT)#1, #3 | char(3) | No | N/A |
Date and Time (DATETIME) | Combination of the Date (DATE) and Time (TIME) fields#3 | char(6) | No | N/A |
Drawer Type (DRAWER_TYPE) | For a PI record, the data summarization type. The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.#2 | char | No | N/A |
GMT Offset (GMT_ADJUST) | Difference (in seconds) between Greenwich Mean Time and local time | long | No | N/A |
Time (TIME) | Record creation time (GMT)#1, #3 | char(3) | No | N/A |
Table 5-8 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. |
Table 5-9 Difference of displayed types made by PFM - Web Console and 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 |