|
Name |
|
|
Dimensional Type |
<None> |
|
Comment |
Holds list of events that can occur on keyed (license-monitored) computers, such as on, off, login, logout, program start, etc. events. |
|
CKT_MD_KEYEDCOMPUTEREVENT |
|
Name |
Child Table |
Foreign Key Columns |
|
Relationship_270 |
MD_KCEvent_SurrogateKey |
|
Name |
Code |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_KCEvent_SurrogateKey |
|
<None> |
numeric |
|
|
MD_KCEvent_SystemOfRecord |
Until we add data from another keyserver, the data here will all come from K2, and "K2" will be the only value present. |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_KCEvent_UniqueID |
Unique identifier associated with a particular event (a logon, program launch, etc.) for a given key server, i.e., system of record. |
DW_UniqueIdentifier36Char |
varchar(36) |
36 |
|
MD_KCEvent_Name |
Full name of an event, such as 'Session logon' or 'Program launch.' |
DW_CommonName |
nvarchar(64) |
64 |
|
MD_KCEvent_Abbreviation |
Short, single-word version of MD_KCEvent_Name. |
DW_CommonName |
nvarchar(64) |
64 |
|
MD_KCEvent_Level |
Boot events belong on one level, login events on another, and application-related events after login on yet another. This attribute groups these events into such levels using rough integer values. They are not meant to be exact, but rather just to enable us to know, e.g., if a higher-level event such as a reboot has taken place (meaning, whether or not a previous application-level or session-level event ended properly, we should consider it ended anyway). |
<None> |
int |
|
|
MD_KCEvent_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_KCEvent_Timestamp |
|
<None> |
timestamp |
|
|
MD_KCEvent_SurrogateKey |
|
<None> |
numeric |
|
|
MD_KCEvent_SystemOfRecord |
Until we add data from another keyserver, the data here will all come from K2, and "K2" will be the only value present. |
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_KCEvent_UniqueID |
Unique identifier associated with a particular event (a logon, program launch, etc.) for a given key server, i.e., system of record. |
DW_UniqueIdentifier36Char |
varchar(36) |
36 |
|
MD_KCEvent_Name |
Full name of an event, such as 'Session logon' or 'Program launch.' |
DW_CommonName |
nvarchar(64) |
64 |
|
MD_KCEvent_Abbreviation |
Short, single-word version of MD_KCEvent_Name. |
DW_CommonName |
nvarchar(64) |
64 |
|
MD_KCEvent_Level |
Boot events belong on one level, login events on another, and application-related events after login on yet another. This attribute groups these events into such levels using rough integer values. They are not meant to be exact, but rather just to enable us to know, e.g., if a higher-level event such as a reboot has taken place (meaning, whether or not a previous application-level or session-level event ended properly, we should consider it ended anyway). |
<None> |
int |
|
|
MD_KCEvent_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_KCEvent_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MD_KEYEDCOMPUTEREVENT_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
|
MD_KEYEDCOMPUTEREVENT_AK |
TRUE |
FALSE |
FALSE |
FALSE |
TRUE |
|
|
MD_KEYEDCOMPUTEREVENT_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
|
MD_KEYEDCOMPUTEREVENT_AK |
TRUE |
FALSE |
FALSE |
FALSE |
TRUE |
|
Name |
|
Identifier_1 |
|
AltKey |
|
Identifier_1 |
|
AltKey |
|
|
|