Table sem5.dbo.SERVER_POLICY_LOG_2
Keeps policy change activities that occur in server

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
USN bigint 8 A USN-based serial number; this ID is not unique.
DOMAIN_ID char 32  √  null GUID of the domain which was administered
SITE_ID char 32 GUID of the site to which the log belongs
SERVER_ID char 32 GUID of the server to which the log belongs
TIME_STAMP bigint 8 The time when the event is logged into system (GMT), which is server side time
EVENT_ID int 4 A unique ID of the policy event:
0 = Policy added
1 = Policy deleted
2 = Policy edited
3 = Add shared policy upon system install
4 = Add shared policy upon system upgrade
5 = Add shared policy upon domain creation
OBJECT_ID char 32 GUID of the AgentPolicy
ADMIN_ID char 32 GUID of the administrator who is modifying the policy
EVENT_DESC nvarchar 512  √  null Description of the event. Usually, the first line of the description is treated as the summary.
EVENT_DATA varbinary 2000  √  null Additional data in binary format. This field is optional.
RESERVED_INT1 int 4  √  null
RESERVED_INT2 int 4  √  null
RESERVED_BIGINT1 bigint 8  √  null
RESERVED_BIGINT2 bigint 8  √  null
RESERVED_CHAR1 char 32  √  null
RESERVED_CHAR2 char 32  √  null
RESERVED_VARCHAR1 nvarchar 520  √  null
RESERVED_BINARY varbinary 2000  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USN Performance Asc I_SERVER_POLICY_LOG_2
EVENT_ID Performance Asc I_SERVER_POLICY_LOG_2_ID
OBJECT_ID Performance Asc I_SERVER_POLICY_LOG_2_OBJ
TIME_STAMP Performance Asc I_SERVER_POLICY_LOG_2_TIME