Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


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 - Agent for Microsoft SQL Server is running

string(256)

No

N/A

Agent Instance

(PROD_INST)

Instance name of PFM - Agent for Microsoft SQL Server

string(256)

No

N/A

Agent Type

(PRODID)

Product ID of PFM - Agent 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

Legend:

N/A: The field value is specified without processing the performance data acquired from Microsoft SQL Server.

#1

A basic value is set because records of the PI record type are summarized. The following table shows the setting values for each record type.

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.

#2

When data is displayed in reports, 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.