Hi.!
I'm trying to extract info right out of the database and even when data is really auto-describing, there are some fields that are not quite clear to me.
Example:
Message and MessageType (from the ConnectionLog table).
=============================
Message MessageType
=============================
Opened session 4
Open session 4
Opened session (Private) 4
Open session - Quick Connect 4
=============================
(I suppose the different messages might be related to different versions of the software?)
Anyhow, I couldn't find a 'MessageType' table to explain this, so, is there a Dictionary or documentation explaining the different messages and types?
Thanks a lot in advance..!
Hi,
Our back-end database doesn't have any official documentation and things can change from version to version.
As for ConnectionLog.Message field contains a value in the form of a pseudo-free description to specify a subtype of the message.
For example: Opened session vs Opened session (Private) vs Open session - Quick Connect, they are all MessageType = 4 (OpenConnection).
The MessageType value which is a static constant represented here (Note: some constants here may not be used, obsolete or missing) :Unknown = 0 Info = 1 Warning = 2 Error = 3 OpenConnection = 4 AddConnection = 5 EditConnection = 6 DeleteConnection = 7 OpenVPN = 8 CloseVPN = 9 CredentialsSentToPlugin = 10 Comment = 11 ExportedConnection = 12 UserAdded = 13 UserDeleted = 14 UserEdited = 15 SecurityGroupAdded = 16 SecurityGroupDeleted = 17 SecurityGroupEdited = 18 RoleAdded = 19 RoleDeleted = 20 RoleEdited = 21 MacroScriptTool = 22 ExportedDocuments = 23 KeyAgentKeyUsed = 24 ReportOpened = 25 RepositoryAdded = 26 RepositoryDeleted = 27 RepositoryEdited = 28 AttachmentAdded = 29 AttachmentDeleted = 30 AttachmentEdited = 31 AttachmentDocumentUpdated = 32 AttachmentOpened = 33 ActivityLogCleared = 34 DeletedEntryCleared = 35 EntryHistoryCleared = 36 DataSourcePermissionChanged = 37 ServerPropertiesViewed = 38 ServerPropertiesEdited = 39 ServerUpdated = 40 DocumentUpdated = 41 PasswordViewed = 43 PasswordChanged = 44 ConnectionStringViewed = 45 PasswordHistoryCleared = 46 ConnectionViewed = 47 ShortcutAdded = 48 ShortcutDeleted = 49 PasswordTemplateAdded = 50 PasswordTemplateEdited = 51 PasswordTemplateDeleted = 52 ResetPassword = 53 Checkout = 54 Checkin = 55 PermissionChanged = 56 Validation = 57 TypingMacroExecuted = 62 TerminalScriptExecuted = 63 ConnectionCopied = 64 ConnectionHistoryVersionReset = 65 AccessDenied = 66 ...
Stéfane Lavergne
Hello and thanks a lot for your response..!
That's enough info for what I'm needing now.!