Table sem5.dbo.AGENTSTATUS
The status of SEPM server tasks.

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
IDX char 32
AGENTTYPE varchar 255 ('') Type of Agent:
SAV 10.x
LogSender
ClientInventory
SAV 11.x
AgentSweepingTask (Database maintenance)
TopThreatsTask (Gathers top and latest threats information)
VirusCatTask (Gathers virus properties)
ThreatCatTask (Gathers risk properties)
AGENTNAME varchar 255 ('') Name associated with this agent (for LogSender agents: Server Group name; for LogSenderSAVSMTP agents: mail gateway host name; for ClientInventory agents: name of Parent Server; else: blank)
LASTRUNGMT varchar 50 ((0)) Last time this agent ran, stored as GMT
REMOTE_TZ_OFFSET int 4 ((0)) Time zone offset
REPORTER_TZ_OFFSET int 4 ((0)) Time zone offset
MAIL int 4 ((0)) Flag whether e-mail has already been sent (1 = Yes, 0 = No)
VERSION_BUILD varchar 20 ('00.00.00') Version/build (major.minor.build) of agent
MACHINE_NAME nvarchar 128 ('') Computer name of the client computer
SERVERGROUP_IDX char 32 ('') Pointer to 'identity_map' table
LASTRUN_DATA nvarchar 510  √  (NULL) Extra data associated with the agent run if any

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
IDX Primary key Asc PK_AGENTSTATUS