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