ExportLogons
Column_name | Type | Length | Index | Description | Example |
---|---|---|---|---|---|
LogonID | bigint | 3 | Ascending Identity | 1 | |
LogonGUID | uniqueidentifier | UUID of the logon | 819EF606-F9B6-40BE-9C0C-A033A34EC4F8 | ||
HostSID | nvarchar | 200 | 1 | Host SID | S-1-21-123456789-123456789-1635717638-390614945 |
UserSID | nvarchar | 200 | User SID | S-1-21-123456789-123456789-1635717638-1072059836 | |
LogonTime | datetime | Logon Date/Time | 2017-01-03 10:24:00.000 | ||
IsAdmin | bit | 1 if an admin, 0 otherwise | 0 | ||
IsPowerUser | bit | 1 if a power user, 0 otherwise | 0 | ||
UILanguage | int | Locale Identifier of the UI Language | 1033 | ||
Locale | int | Locale Identifier of the Locale | 2057 | ||
UserName | nvarchar | 1024 | User name | EGUser1 | |
UserDomainSID | nvarchar | 200 | User Domain SID | S-1-21-123456789-123456789-1635717638 | |
UserDomainName | nvarchar | 1024 | User Domain | EGDomain | |
UserNameNETBIOS | nvarchar | 15 | User NETBIOS | EGDOMAIN | |
ChassisType | nvarchar | 40 | Chassis Type | Docking Station | |
HostName | nvarchar | 1024 | 2* | Host name | EGHostWin1 |
HostNameNETBIOS | nvarchar | 15 | 2* | Host NETBIOS | EGHOSTWIN1 |
OS | nvarchar | 20 | OS Version | 6.3 | |
OSProductType | int | OS Product Type | 1 | ||
PlatformType | nvarchar | 10 | Platform Type | Windows | |
HostDomainSID | nvarchar | 200 | Host Domain SID | S-1-21-123456789-123456789-1635717638 | |
HostDomainName | nvarchar | 1024 | Host Domain | EGDomain | |
HostDomainNameNETBIOS | nvarchar | 15 | Host Domain NETBIOS | EGDOMAIN | |
PolicyName | nvarchar | 1024 | Policy Name | EventGen Test Policy | |
WorkstyleName | nvarchar | 1024 | Workstyle name | EventGen Test Workstyle |