profiling.policy table

The profiling.policy table provides summary information for poll policies and poll definitions.

The following table describes the columns in the profiling.policy table.
Table 1. profiling.policy database table
Column name Constraints Data type Description
AVGSCOPETIME

Not NULL

Integer

The average time taken to evaluate the scope of each poll (not counting the first poll).
FIRSTSCOPETIME

Not NULL

Integer

Time taken, in CPU clock ticks, for the list of entities in scope for the poll to be evaluated for the first time.

ENTITYCOUNT

Not NULL

Integer

Number of entities being monitored by this poll policy and poll definition combination.

POLICYID

Not NULL

Primary key

Integer

Value of the ncmonitor.poll.policyId field.

POLICYNAME

Not NULL

Text

Value of the ncmonitor.policy.policyName field.

SCOPETIME

Not NULL

Integer

The total time taken, in CPU clock ticks, for the list of entities in scope for the poll to be evaluated, excluding the first time.
SCOPECOUNT

Not NULL

Integer

The number of times that the scope of the poll has been evaluated.

TARGETCOUNT

Not NULL

Integer

Number of addresses being polled by this poll policy and poll definition combination.

TEMPLATEID

Not NULL

Primary key

Integer

Value of the ncmonitor.poll.templateId field.