The login name of the user who originated the session. For example, if you connect to SQL Server using Login1 and execute ...

The login name of the user who originated the session. For example, if you connect to SQL Server using Login1 and execute a statement as Login2, LoginSessionName will show Login1; while LoginName will show Login2. This column will display both SQL Server and Windows logins.