history log of connection in SQL

0 vote

avatar

then I come across for another table to get the log to send on trace tools?

requete sql : login,date , sesion , machine

view system to cross with another table:

dm_exec_connections ,login_token etc...

thank you

All Comments (2)

avatar

the table :SELECT TOP 1000 [ID]

,[Name]

,[FullName]

,[IsAdministrator]

,[CanAdd]

,[CanDelete]

,[CanEdit]

,[ConnectionOverrides]

,[CustomSecurity]

,[IsTemplate]

,[DataSourceID]

,[CanAddCredentials]

,[CanAddDataEntry]

,[CanEditCredentials]

,[CanEditDataEntry]

,[CanDeleteCredentials]

,[CanDeleteDataEntry]

,[IsEnabled]

,[CreationDate]

,[Email]

,[IsOwner]

,[Password]

,[PasswordSalt]

,[IsLockedOut]

,[LastLoginDate]

,[LastPasswordChangedDate]

,[LastLockoutDate]

,[FailedPasswordAttemptCount]

,[FailedPasswordAttemptWindowStart]

,[UserType]

,[PersonalConnectionCacheID]

,[PersonalConnections]

FROM [Infogerance].[dbo].[UserInfo]

missing information with what can I cross this sql table?

thank you

avatar

Bonjour,

Que représentent les champs dm_exec_connections ,login_token?

Cordialement

Maurice