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 |
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, #2 |
char(3) |
No |
N/A |
Date and Time (DATETIME) |
Combination of the Date (DATE) and Time (TIME) fields#2 |
char(6) |
No |
N/A |
Drawer Type (DRAWER_TYPE) |
For a PI record, the data summarization type. |
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, #2 |
char(3) |
No |
N/A |
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. |