Previous Topic: WGN_V_INTPARTPNTUSER_1Next Topic: WGN_V_ISSUE_1

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

WGN_V_PNTUSER_1

This view returns all columns from Wgn3EventParticipant along with those relating to login information, user IDs and group IDs. Additionally the EventMajorType is derived from the ParticipantNodeUID column on the Wgn3EventParticipant, thus eliminating the need to join to Wgn3Event within the view. This view should be used when you require participant, user and group information and does not require any other event attributes. Since there is no join to Wgn3Event in this view, this returns rows quicker if event information is not needed and could be used instead of either WGN_V_EVENTPARTPNTUSER_1 or WGN_V_EVENTPARTUSERGRP_1.

View Stack

WGN_V_PNTUSER_1

 

 

→

WGN_V_m_PNTUSER_1

 

→

WGN_V_MD_PNTUSER_1

 

 

→

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.

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.

eventmajortype

INTEGER

4

Identifies the 'major' event type (such as, email or web page)

WGN_V_PNTUSER_2

This view returns all columns as WGN_V_PNTUSER_1 and from the point of view of Management group RLS it is identical to that view. However for the administrator view of this some of the joins have been changed from INNER to LEFT joins to be able to return rows that do not necessarily have groups associated to them

View Stack

WGN_V_PNTUSER_2

 

 

 

→

WGN_V_m_PNTUSER_2

 

 

→

WGN_V_MD_PNTUSER_2

 

 

→

WGN_V_MD_PNTUSER_1

 

 

 

→

wgn3eventparticipant

 

 

 

 

WGN_V_RLS_ADDR_1

 

 

 

 

→

TMP_WGN3ADDRRLS