vdsAuditMsg
  • 08 Jan 2025
  • 1 Minute à lire
  • Sombre
    Lumière
  • PDF

vdsAuditMsg

  • Sombre
    Lumière
  • PDF

The content is currently unavailable in French. You are viewing the default English version.
Résumé de l’article

The vdsAuditMsg table stores audit messages. It contains one record per audit message generated, with additional information held in the vdsAuditMsgField table (see  vdsAuditMsgField).

Columns

Table:  vdsAuditMsg table columns
Column nameData typePrimary keyNullableDescription
vdsTimeStamptimestampYesNoThe date and time of the event.
vdsAMIDvarchar(32)YesNo32-character hexadecimal digit AMID (without hex prefix "0x").
vdsSourcevarchar(64)No
NoThe source component name.
vdsTypeintegerNoNoThe numeric type.
vdsCodevarchar(8)NoNoThe audit message code, e.g. "I-010003".
vdsDescvarchar(255)NoNoThe description of the audit message.
vdsCategoryvarchar(32)NoNoThe category for the audit message, e.g. "Authentication".
vdsUserIdvarchar(255)NoYes 
vdsDomainvarchar(255)NoYes 
vdsClientLocationvarchar(255)NoYes 
vdsSerialNovarchar(255)NoYes 
vdsSignaturevarchar(128)NoYes 
vdsEpochIDvarchar(128)NoYes 
vdsEpochSNintNoYes 
vdsCharacteristicsvarchar(1024)NoYes 
vdsCredentialTypevarchar(255)NoYes 
vdsApplicationNamevarchar(32)NoYes 
vdsPolicyIDvarchar(255)NoYes 
vdsMobileNumbervarchar(64)NoYes 
vdsDPTypevarchar(32)NoYes 
vdsClientTypevarchar(60)No
Yes 
vdsUserLocationvarchar(255)NoYes 
vdsErrorCodeintNoYes 
vdsErrorMessagevarchar(1024)NoYes 
vdsAuditLocationvarchar(255)NoYes 
vdsServerLocationvarchar(255)NoYes 
vdsDataSourceLocationvarchar(1024)NoYes 
vdsConfigurationDetailsvarchar(1024)NoYes 
vdsFromLocationvarchar(255)NoYes 
vdsToLocationvarchar(255)NoYes 
vdsInfoMessagevarchar(1024)NoYes 
vdsExpirationDatetimestampNoYes 
vdsLocalAuthenticationvarchar(16)NoYes 
vdsBackendAuthenticationvarchar(32)NoYes 
vdsObjectvarchar(64)NoYesThe type of target object.
vdsCommandvarchar(64)NoYes 
vdsRadiusProfilevarchar(1024)NoYes 
vdsReasonvarchar(1024)NoYes 
vdsTargetUserIdvarchar(255)NoYes 
vdsTargetDomainvarchar(255)NoYes 
vdsPendingOperationIDvarchar(8)NoYesThe ID for the related pending operation. This is a case-sensitive alphanumeric 8-character string.
vdsCorrelationIDvarchar(36)NoYesThe correlation ID is used to identify the audit messages that correlate to one another.
vdsIPAddressintegerNoYes

The IP address of the client related to this audit message (only in case the client is not the source of the audit message).

This field is usually set only, if vdsClientLocation is specified.

vdsCmdElapsedTimeintegerNoYesThe time in milliseconds that passed since the (SOAP) operation started. Note that you do not need to enable performance monitoring to capture the elapsed time, but not every audit message includes it.

Keys

Primary key: (vdsAMID, vdsTimeStamp)

Foreign keys: None

Indexes

Each index level includes indexes of the levels below as well.

Table: vdsAuditMsg table indexes
Index nameIncluded fields
Level 0
vdsauditMsgIdx

vdsTimeStamp

vdsAMID

Level 1 (default)
vdsauditUserIdxvdsUserId
vdsauditDomainIdxvdsDomain
vdsauditSerialIdxvdsSerialNo
vdsauditClientLocIdxvdsClientLocation
vdsauditCodeIdxvdsCode
vdsauditDescIdxvdsDescription
vdsauditCatIdxvdsCategory
vdsauditTargetUserIdx

vdsTargetDomain

vdsTargetUserId

vdsauditPolicyIDIdxvdsPolicyID
vdsauditClientTypeIdxvdsClientType
vdsauditIPAddressIdxvdsIPAddress
Level 2
vdsauditSignatureIdxvdsSignature
vdsauditEpochIDIdxvdsEpochID
vdsauditEpochSNIdxvdsEpochSN
vdsauditCharacterIdxvdsCharacteristics
vdsauditCredTypeIdxvdsCredentialType
vdsauditAppNameIdxvdsApplicationName
vdsauditMobileNoIdxvdsMobileNumber
vdsauditDPTypeIdxvdsDPType
vdsauditUserLocIdxvdsUserLocation
vdsauditErrCodeIdxvdsErrorCode
vdsauditErrMsgIdxvdsErrorMessage
vdsauditAuditLocIdxvdsAuditLocation
vdsauditServerLocIdxvdsServerLocation
vdsauditDataSrcLocIdxvdsDataSourceLocation
vdsauditConfDetailsIdxvdsConfigurationDetails
vdsauditFromLocIdxvdsFromLocation
vdsauditToLocIdxvdsToLocation
vdsauditInfoMsgIdxvdsInfoMessage
vdsauditExpDateIdxvdsExpirationDate
vdsauditLocalAuthIdxvdsLocalAuthentication
vdsauditBackendAuthIdxvdsBackendAuthentication
vdsauditObjectIdxvdsObject
vdsauditCommandIdxvdsCommand
vdsauditRadProfIdxvdsRadiusProfile
vdsauditReasonIdxvdsReason
vdsauditStartTimeIdxvdsStartTime
vdsauditPendingOperationIDIdxvdsPendingOperationID

Cet article vous a-t-il été utile ?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

Ozzy, facilitant la découverte de connaissances grâce à l’intelligence conversationnelle