WGN_V_EVENTPARTUSERGRP

Database Schema and Views Reference Guide › Database Views › Primary Views Definitions › WGN_V_EVENTPARTUSERGRP_1

WGN_V_EVENTPARTUSERGRP_1

This view returns all columns from Wgn3Event along with participant, user and group information subject to RLS. Use this view when you require event, user and group information. This view allows easy access to event, user and group information but only applies RLS once.

Note: Because the underlying tables are not accessible, if this view were not available you would need to use the WGN_V_EVENT_2, Wgn_V_User_1 and Wgn_V_Group_1 views, which would mean that RLS was applied three times.

View Stack


WGN_V_EVENTPARTUSERGRP_1
→	WGN_V_m_EVENTPARTUSERGRP_1
	→	WGN_V_MD_EVENTPNTUSRGR_1
		→	WGN3Event
			wgn3eventparticipant
			WGN_V_RLS_ADDR_1
			→	TMP_WGN3ADDRRLS

Column Details

Column	Data Type	Length	Description
EventUID	IDENTITYDEF	13	Key used to uniquely identify a captured or imported event.
EventTimestamp	TIMESTAMP	8	The time at which the event occurred.
SequenceIDM	INTEGER	4	Part-key used to identify the owning sequence and also uniquely identify the event.
SequenceID	INTEGER	4	Part-key used to identify the owning sequence and also uniquely identify the event.
EventIndex	INTEGER	4	Part-key used to uniquely identify the event.
EventMajorType	INTEGER	4	Identifies the 'major' event type (such as, email or web page)
EventMinorType	INTEGER	4	Identifies the 'minor' event type (such as, email sent)
EventSubType	INTEGER	4	Identifies the 'direction' of the event (such as, incoming or outgoing)
AesMajorType	INTEGER	4	Part-key that identifies the source object (software package) that captured the sequence.
AesMinorType	INTEGER	4	Part-key that identifies the source object (software package) that captured the sequence.
AesSubType	INTEGER	4	Part-key that identifies the source object (software package) that captured the sequence.
EventText1	LONGVARCHAR	255	Event specific string identifying the event.
EventText2	LONGVARCHAR	4000	Event specific string identifying the event.
EventAttributes	VARCHAR	255	Attributes of the event.
ExternalID	VARCHAR	255	This attribute contains an external (non-CA DataMinder) unique ID of an event to enable matching with duplicates of the same event captured elsewhere.
Duration	INTEGER	4	The length of time for which the event occurred.
ExpiryTimestamp	TIMESTAMP	8	Stores the time at which the event expires. Expired events are removed by the next scheduled database purge.
IsPermanent	BIT	1	If this column has a non-zero (true) value, then the event will never be deleted by a scheduled database purge.
UpdateTimestamp	TIMESTAMP	8	The time that event was last written to the DBMS.
PurgeState	INTEGER	4	Indicates whether the row can be purged if 'Purge On Replicate' is enabled. This column is ignored on a CMS.
GMTOffset	INTEGER	4	Specifies the difference (in minutes) between UTC time and the time zone in which an events source machine resides.
DSTOffset	INTEGER	4	Specifies the size of the daylight saving offset (in minutes) for the source machine's timezone.
BlobType	INTEGER	4	Identifies the type of the blob (such as a file based blob).
BlobLocation	VARCHAR	255	The location of the blob data. The format of this string depends on the BlobType.
BlobSize	DECIMAL	13	The size of the blob (in bytes) before encryption/compression.
BLOBPhysicalSize	DECIMAL	13	The size of the blob (in bytes) after encryption/compression.
ParticipantIndex	INTEGER	4	Part-key used to identify an event participant.
AddressUID1	DECIMAL	13	Part-key used to uniquely identify an email address or the address of an IM participant.
AddressUID2	DECIMAL	13	Part-key used to uniquely identify an email address or the address of an IM participant.
ParticipantNodeUID	INTEGER	4	The classification of the participant.
InterventionNodeUID	INTEGER	4	The classification that CA DataMinder assigns to the participant.
LoginIDM	INTEGER	4	Part-key that indicates the participant who generated the event.
LoginID	INTEGER	4	Part-key that indicates the participant who generated the event.
NativeUser	VARCHAR	128	Name of the OS user that the CA DataMinder is logged on as.
LoginState	INTEGER	4	The state of the user login, that is, logged in or out.
LastLogonTime	TIMESTAMP	8	The time the user last logged in or out.
PolicyVersion	VARCHAR	255	The version of user policy that is being used.
SourceMachine	VARCHAR	255	The name of the machine on which the user logged in.
DefaultLoginFlag	BIT	1	This is the 'default' login record for the OS user. This is used to control automatic logins.
UserIDM	INTEGER	4	Part-key identifying the CA DataMinder user associated with the login.
UserID	INTEGER	4	Part-key identifying the CA DataMinder user associated with the login.
GroupIDM	INTEGER	4	Part-key used to uniquely identify a group within the installation.
GroupID	INTEGER	4	Part-key used to uniquely identify a group within the installation.
epEventTimeStamp	TIMESTAMP	8	Same as EventTimeStamp but this is taken from Wgn3EventParticipants instead of Wgn3Event. Used to ensure predicates commute.