history log of connection in SQL

0 vote

Published 11 years ago

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)

infofred

Published 11 years ago

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

Maurice Côté

Published 11 years ago

Bonjour,

Que représentent les champs dm_exec_connections ,login_token?

Cordialement

Maurice