Is there a Database Dictionary?

Is there a Database Dictionary?

avatar
fernando01
Disabled

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..!

All Comments (2)

avatar

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

avatar

Hello and thanks a lot for your response..!

That's enough info for what I'm needing now.!