Previous Topic: OwnerTypeNext Topic: LoginState


WgnUserLogin

This table stores login records used to determine which machines a CA DataMinder user logs on from, and which OS user they logged on as. This table is referenced by the captured data, allowing the data to be coupled to a particular user login location.

Column

Primary Key

Datatype

Length

Notes

LoginIDM

Part-key identifying a unique login instance. A user will have one of these for each machine they have logged on to.

Yes

INTEGER

4

 

LoginID

Part-key identifying a unique login instance.

Yes

INTEGER

4

 

NativeUser

Name of the OS user that the CA DataMinder is logged on as.

 

VARCHAR

128

 

UserIDM

Part-key identifying the CA DataMinder user associated with the login.

 

INTEGER

4

Foreign key: Wgn3User

UserID

Part-key identifying the CA DataMinder user associated with the login.

 

INTEGER

4

Foreign key: Wgn3User

LoginState

The state of the user login, that is, logged in or out.

 

INTEGER

4

Follow the hyperlink for details.

LastLogonTime

The time the user last logged in or out.

 

TIMESTAMP

8

 

PolicyVersion

The version of user policy that is being used.

 

VARCHAR

255

 

SourceMachine

The name of the machine on which the user logged in.

 

VARCHAR

255

For administrator console logins to the CMS, the source machine may not belong to the local CMS machine hierarchy.

DefaultLoginFlag

This is the 'default' login record for the OS user. This is used to control automatic logins.

 

BIT

1