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 |
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 |
|
Copyright © 2014 CA.
All rights reserved.
|
|