master.probestats table

This table exists when the system has enabled self monitoring of probes. For more information, see Enabling self monitoring of probes. The statistics arriving from the probes feeds are captured in this table. It is recommended that the probe_statistics_cleanup housekeeping trigger is turned on to periodically prune old data from the table. This table should not be modified.

Table 1. Columns in the master.probestats table
Column name Data type Description
SeqNos incr Serial number assigned automatically by ObjectServer to each row.
KeyField varchar(128) primary key Key made up out of ProbeId + StatTime + ProbePID.
StatTime time UTC Timestamp when stats were taken at probe.
ProbeUpTime int Probe uptime in seconds.
ProbeAgent varchar(32) Probe Agent field.
ProbeHost varchar(64) Host that probe is running on.
ProbeId varchar(96) Id = Agent + @ + Host
ProbePID int PID (process ID) of probe process
NumEventsProcessed int Number of events entering rules processing.
NumEventsGenerated int Number of new events generated with the genevent() function.
NumEventsDiscarded int Number of events discarded by the rules.
RulesFileTimeSec int Total time (seconds) for all events to process rules.
AvgRulesFileTime int Average time (millionths of a second) to process rules on events.
CPUTimeSec int Total amount of CPU time (seconds) used by probe process.
ProbeMemory int Memory (kilobytes) used by probe process.