About the ESMJobRunCheckResults table

The ESMJobRunCheckResults table lists the messages from the policy runs on the agents.

Table: ESMJoESMJobRunCheckResults table

Field name

Type

Description

AgentID

<number>

RecID from ESMAgent table

JobRunID

<number>

RecID from ESMJobRun table

PolicyCheckID

<number>

RecID from ESMPolicyCheck table

MessageID

<number>

RecID from ESMMessage table

ResultState

<text>

Status of the policy run; either scheduled, error, running, or complete

NameValue

<text>

Source of the policy run message; either agent, module, or check name

Information

<text>

Policy run date and time, or the message text that describes the problem or the policy infraction