Forum / Remote Desktop Manager - Feature Request

history log of connection in SQL

  • Create an Issue
  • Cancel

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

Clock5 yrs

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

Clock5 yrs

Bonjour,

Que représentent les champs dm_exec_connections ,login_token?

Cordialement



Maurice Côté

Customers that use Devolutions Server are provided free remote sessions for performing upgrades. Please send a request to the Devolutions Service Desk to get the process started.

signaturesignature

Clock5 yrs