Application-specific events for billing, monitoring and analysis.
Catalog: DataDictionary
Schema: Invantive
Alias: aet
Label: Audit Events
Retrieve: true
Insert: true
Update: false
Delete: false
The columns of the view AUDITEVENTS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
APPLICATION_NAME |
string(240) |
Application Name |
☑ |
Application name. |
APPLICATION_USER |
string(240) |
Application User |
☐ |
Application user. |
BILLING_ID |
string |
Billing ID |
☐ |
ID for billing. |
BILLING_REFERENCE |
string |
Billing Reference |
☐ |
Reference for billing, such as your cost centers. |
DATA_CONTAINER_ID |
string |
Data Container ID |
☑ |
ID of the data container. |
DIMENSION1_NAME |
string |
Dimension 1 Name |
☐ |
Name of dimension 1. |
DIMENSION1_VALUE |
string |
Dimension 1 Value |
☐ |
Value of dimension 1. |
DIMENSION10_NAME |
string |
Dimension 10 Name |
☐ |
Name of dimension 10. |
DIMENSION10_VALUE |
string |
Dimension 10 Value |
☐ |
Value of dimension 10. |
DIMENSION11_NAME |
string |
Dimension 11 Name |
☐ |
Name of dimension 11. |
DIMENSION11_VALUE |
string |
|
☐ |
Value of dimension 11. |
DIMENSION12_NAME |
string |
Dimension 12 Name |
☐ |
Name of dimension 12. |
DIMENSION12_VALUE |
string |
|
☐ |
Value of dimension 12. |
DIMENSION13_NAME |
string |
Dimension 13 Name |
☐ |
Name of dimension 13. |
DIMENSION13_VALUE |
string |
|
☐ |
Value of dimension 13. |
DIMENSION14_NAME |
string |
Dimension 14 Name |
☐ |
Name of dimension 14. |
DIMENSION14_VALUE |
string |
|
☐ |
Value of dimension 14. |
DIMENSION15_NAME |
string |
Dimension 15 Name |
☐ |
Name of dimension 15. |
DIMENSION15_VALUE |
string |
|
☐ |
Value of dimension 15. |
DIMENSION16_NAME |
string |
Dimension 16 Name |
☐ |
Name of dimension 16. |
DIMENSION16_VALUE |
string |
|
☐ |
Value of dimension 16. |
DIMENSION17_NAME |
string |
Dimension 17 Name |
☐ |
Name of dimension 17. |
DIMENSION17_VALUE |
string |
|
☐ |
Value of dimension 17. |
DIMENSION18_NAME |
string |
Dimension 18 Name |
☐ |
Name of dimension 18. |
DIMENSION18_VALUE |
string |
|
☐ |
Value of dimension 18. |
DIMENSION19_NAME |
string |
Dimension 19 Name |
☐ |
Name of dimension 19. |
DIMENSION19_VALUE |
string |
|
☐ |
Value of dimension 19. |
DIMENSION2_NAME |
string |
Dimension 2 Name |
☐ |
Name of dimension 2. |
DIMENSION2_VALUE |
string |
Dimension 2 Value |
☐ |
Value of dimension 2. |
DIMENSION20_NAME |
string |
Dimension 20 Name |
☐ |
Name of dimension 20. |
DIMENSION20_VALUE |
string |
|
☐ |
Value of dimension 20. |
DIMENSION3_NAME |
string |
Dimension 3 Name |
☐ |
Name of dimension 3. |
DIMENSION3_VALUE |
string |
Dimension 3 Value |
☐ |
Value of dimension 3. |
DIMENSION4_NAME |
string |
Dimension 4 Name |
☐ |
Name of dimension 4. |
DIMENSION4_VALUE |
string |
Dimension 4 Value |
☐ |
Value of dimension 4. |
DIMENSION5_NAME |
string |
Dimension 5 Name |
☐ |
Name of dimension 5. |
DIMENSION5_VALUE |
string |
Dimension 5 Value |
☐ |
Value of dimension 5. |
DIMENSION6_NAME |
string |
Dimension 6 Name |
☐ |
Name of dimension 6. |
DIMENSION6_VALUE |
string |
Dimension 6 Value |
☐ |
Value of dimension 6. |
DIMENSION7_NAME |
string |
Dimension 7 Name |
☐ |
Name of dimension 7. |
DIMENSION7_VALUE |
string |
Dimension 7 Value |
☐ |
Value of dimension 7. |
DIMENSION8_NAME |
string |
Dimension 8 Name |
☐ |
Name of dimension 8. |
DIMENSION8_VALUE |
string |
Dimension 8 Value |
☐ |
Value of dimension 8. |
DIMENSION9_NAME |
string |
Dimension 9 Name |
☐ |
Name of dimension 9. |
DIMENSION9_VALUE |
string |
Dimension 9 Value |
☐ |
Value of dimension 9. |
GUI_ACTION |
string(240) |
GUI Action |
☐ |
Action performed within the user interface. |
GUI_IP_ADDRESS_EXTERNAL |
string(240) |
GUI External IP Address |
☑ |
External IP address of the GUI application. |
GUI_IP_ADDRESS_INTERNAL |
string(240) |
GUI Internal IP Address |
☑ |
Internal IP address of the GUI application. |
GUI_MACHINE |
string(240) |
GUI Machine |
☐ |
Name of the machine running the GUI application. |
GUI_MODULE_NAME |
string(240) |
|
☐ |
Module within the GUI application currently running. |
GUI_MODULE_VERSION |
string(240) |
|
☐ |
Version of module within the GUI application currently running. |
GUI_MODULE |
string(240) |
GUI Module |
☐ |
Module within the GUI application currently running. |
GUI_OS_USER |
string(240) |
GUI OS User |
☐ |
OS user running the GUI application. |
IIID |
string |
IIID |
☑ |
Invantive installation ID. |
IS_APPLICATION_MANAGED |
boolean |
Application Managed |
☑ |
Indicator whether event was managed by the application. |
IS_MONITORING |
boolean |
Is Monitoring |
☐ |
Indicator whether event must be forwarded for monitoring. |
IUID |
string |
IUID |
☑ |
Invantive user ID. |
LAST_LOGON_TIME |
datetime |
Logon Time |
☐ |
Date at which the last logon found place. |
LAST_NATURAL_KEY |
string(4000) |
Last Natural Key |
☐ |
Last seen natural key of business object. |
LICENSE_CONTRACT_CODE |
string |
License Contract Code |
☑ |
License contract code. |
LICENSE_KEY_IDENTIFIER |
string |
License Key Identifier |
☑ |
License key identifier. |
LOGGING_LEVEL |
string(30) |
Logging Level |
☑ |
Type of logging message. |
MESSAGE_CODE |
string(30) |
Message Code |
☐ |
|
MESSAGE_UID |
guid |
Message UID |
☑ |
Specific UID for easy recognition. |
METRIC_NAME |
string |
Metric Name |
☐ |
Name of monitoring metric. |
METRIC_VALUE |
string |
Metric Value |
☐ |
Value of monitoring metric. |
OCCURRENCE_DATE_UTC |
datetime |
Occurrence Date (UTC) |
☑ |
UTC date at which the event occurred. |
PARAMETER_VALUES |
string(4000) |
Parameter Values |
☐ |
Parameter values. |
PARTITION |
string(240) |
Partition |
☐ |
Specific partition on which the event was registered. |
POOL_IDENTITY |
string(60) |
Pool Identity |
☐ |
Pool identity. |
PROVIDER_NAME |
string |
Provider |
☐ |
Name of provider. |
REFERENCE_KEY |
string |
Reference Key |
☐ |
Key of the referenced business object. |
REFERENCE_TABLE_CODE |
string |
Reference Table Code |
☐ |
Table code of the referenced business object. |
SERVICE_NAME |
string |
Service Name |
☐ |
Name of service. |
SERVICE_STATE |
string |
Service State |
☐ |
Status of service (production, acceptance, test). |
SESSION_ID |
string(240) |
Session ID |
☑ |
ID of the session. |
SHOWN_TO_USER |
boolean |
Shown to User |
☑ |
Indicator whether event was shown to the user. |
SQL_STATEMENT |
string(4000) |
SQL Statement |
☐ |
SQL statement. |
UNIT_OF_MEASURE |
string |
Unit of Measure |
☐ |
Unit of Measure of value of monitoring metric. |
USER_MESSAGE |
string(4000) |
User Message |
☐ |
Text of the message without message code. |
17-05-2021 11:57 Version 20.1.419-BETA+3191