Action log entries
When you analyze an action log, you can organize the data into categories, actions, and properties (identifiers and arguments). You can map these to database columns, which you can display in a Spotfire visualization.
- The time of the action.
- The time the server logged the action.
- The addresses for the server and the computer where the action was performed.
- The user account that performed the logged action.
- The category of the action, specifying whether the action originated on the Spotfire Server (such as an admin action) or from a service (such as Automation Services).
- The properties (identifying properties or arguments) specific to the action performed. For example, when a user changes a password, the property uName is logged to indicate the user name.
- Whether the action was completed successfully.
- The session and service instance unique identifiers.
How the data is presented
Every logged event is placed on a new row in the log, and semicolons separate the entries within the logged event.
LOGGED_TIME; MACHINE; USER_NAME; ORIGINAL_TIME; ORIGINAL_IP; LOG_CATEGORY; LOG_ACTION; SUCCESS; SESSION_ID; ID1; ID2; ARG1; ARG2; ARG3; ARG4; ARG5; ARG6
The properties and arguments correspond to the fields
id1
,
id2
, and
arg1
through
arg6
.
ARG5
corresponds to
SERVICE_INSTANCE_ID
.
Example
2019-03-18T09:36:00.381+0100;10.100.32.129;jdoe;2019-03-18T09:36:00,381+0100;10.98.45.189;
admin;change_passwd;true;7583cdc4-a6b8-40d4-88e6-90f5d499ff79
For logs that are written to a database, the fields correspond to column names. The logged data is mapped to the appropriate columns to create a database view.
CREATE OR REPLACE VIEW ADMIN_CHANGE_PASSWD AS SELECT
LOGGED_TIME;
MACHINE;
USER_NAME;
ORIGINAL_TIME;
ORIGINAL_IP;
SUCCESS;
SESSION_ID;
ID1 AS UNAME FROM ACTIONLOG WHERE LOG_CATEGORY = 'admin' AND LOG_ACTION = 'change_passwd'
Category | Action | id1 | id2 | arg1 | arg2 | arg3 | arg4 | arg5 | arg6 |
---|---|---|---|---|---|---|---|---|---|
admin | change_passwd | uName | |||||||
admin | create_group | gName | displayName | ||||||
admin | create_user | uName | displayName | ||||||
admin | group_add_member | name | gName | sort | groupingId | ||||
admin | group_remove_member | name | gName | sort | groupingId | ||||
admin | remove_license | gName | licenseName | ||||||
admin | remove_principal | name | sort | groupingId | |||||
admin | rename_principal | oldName | newName | sort | |||||
admin | set_license | gName | licenseName | excludingFunction | |||||
admin | set_preference | name | prefType | category | id | ||||
analysis_as | apply_bookmark | libraryId | path | bookmarkName | |||||
analysis_pro | apply_bookmark | libraryId | path | bookmarkName | |||||
analysis_pro | arrange_visualizations | libraryId | path | pageName | tileMode | origin | |||
analysis_pro | canvas_size | libraryId | path | layoutName | layoutSize | ||||
analysis_pro | change_column_or_aggregation | libraryId | path | oldExpression | newExpression | origin | |||
analysis_pro | create_annotation | libraryId | path | visualizationTitle | visualizationType | pageName | |||
analysis_pro | create_comment | libraryId | path | visualizationTitle | conversationId | captureState | |||
analysis_pro | create_details_visualization | libraryId | path | originVisualizationType | visualizationType | visualizationTitle | |||
analysis_pro | create_page | libraryId | path | origin | |||||
analysis_pro | create_visualization | libraryId | path | visualizationType | visualizationTitle | origin - userInput | |||
analysis_pro | create_vis_recommendations | libraryId | path | visualizationType | predictorsType | origin - userInput | |||
analysis_pro | delete_page | libraryId | path | pageName | origin | ||||
analysis_pro | duplicate_page | libraryId | path | pageName | origin | ||||
analysis_pro | duplicate_visualization | libraryId | path | visualizationType | visualizationTitle | ||||
analysis_pro | export | libraryId | path | exportFormat | exportPages | ||||
analysis_pro | hide_page | libraryId | path | pageName | origin | ||||
analysis_pro | incl_col_from_recommendations | libraryId | path | columnName | value | ||||
analysis_pro | initiate_analyze_from_marking | libraryId | path | visualizationType | origin | ||||
analysis_pro | modify_filter | libraryId | path | filterName | filterType | origin | |||
analysis_pro | rename_page | libraryId | path | oldName | pageName | origin | |||
analysis_pro | reset_all_filters | libraryId | path | origin | |||||
analysis_pro | reset_all_visible_filters | libraryId | path | origin | |||||
analysis_pro | reset_filter | libraryId | path | filterName | filterType | origin | |||
analysis_pro | set_custom_expression | libraryId | path | oldExpression | newExpression | origin | |||
analysis_pro | set_page | libraryId | path | pageName | |||||
analysis_pro | set_preferred_aggregation | libraryId | path | columnName | aggregationMethod | defaultAggregationMethod | |||
analysis_pro | show_page | libraryId | path | pageName | origin | ||||
analysis_pro | switch_visualization | libraryId | path | originVisualizationType | visualizationType | visualizationTitle | |||
analysis_pro | visualization_area_layout_mode | libraryId | path | visualizationAreaMode | |||||
analysis_pro | y_axis_number_of_scales | libraryId | path | numberOfScales | visualizationType | origin | |||
analysis_wp | apply_bookmark | libraryId | path | bookmarkName | webplayerSessionId | analysisId | service_instance_id | ||
analysis_wp | arrange_visualizations | libraryId | path | pageName | tileMode | webplayerSessionId | analysisId | service_instance_id | origin |
analysis_wp | change_column_or_aggregation | libraryId | path | oldExpression | newExpression | webplayerSessionId | analysisId | service_instance_id | origin |
analysis_wp | create_annotation | libraryId | path | visualizationTitle | visualizationType | webplayerSessionId | analysisId | service_instance_id | pageName |
analysis_wp | create_comment | libraryId | path | visualizationTitle | conversationId | webplayerSessionId | analysisId | service_instance_id | captureState |
analysis_wp | create_details_visualization | libraryId | path | originVisualizationType | visualizationType | webplayerSessionId | analysisId | service_instance_id | visualizationTitle |
analysis_wp | create_page | libraryId | path | webplayerSessionId | analysisId | service_instance_id | origin | ||
analysis_wp | create_visualization | libraryId | path | visualizationType | visualizationTitle | webplayerSessionId | analysisId | service_instance_id | origin - userInput |
analysis_wp | create_vis_recommendations | libraryId | path | visualizationType | predictorsType | webplayerSessionId | analysisId | service_instance_id | origin - userInput |
analysis_wp | delete_page | libraryId | path | pageName | webplayerSessionId | analysisId | service_instance_id | origin | |
analysis_wp | duplicate_page | libraryId | path | pageName | webplayerSessionId | analysisId | service_instance_id | origin | |
analysis_wp | duplicate_visualization | libraryId | path | visualizationType | webplayerSessionId | analysisId | service_instance_id | visualizationTitle | |
analysis_wp | export | libraryId | path | exportFormat | exportPages | webplayerSessionId | analysisId | service_instance_id | |
analysis_wp | hide_page | libraryId | path | pageName | webplayerSessionId | analysisId | service_instance_id | pageTabs or contextMenu | |
analysis_wp | modify_filter | libraryId | path | filterName | filterType | webplayerSessionId | analysisId | service_instance_id | origin |
analysis_wp | rename_page | libraryId | path | oldName | pageName | webplayerSessionId | analysisId | service_instance_id | origin |
analysis_wp | reset_all_filters | libraryId | path | webplayerSessionId | analysisId | service_instance_id | origin | ||
analysis_wp | reset_all_visible_filters | libraryId | path | webplayerSessionId | analysisId | service_instance_id | origin | ||
analysis_wp | reset_filter | libraryId | path | filterName | filterType | webplayerSessionId | analysisId | service_instance_id | origin |
analysis_wp | set_custom_expression | libraryId | path | oldExpression | newExpression | webplayerSessionId | analysisId | service_instance_id | origin |
analysis_wp | set_page | libraryId | path | pageName | webplayerSessionId | analysisId | service_instance_id | ||
analysis_wp | set_preferred_aggregation | libraryId | path | columnName | aggregationMethod | webplayerSessionId | analysisId | service_instance_id | defaultAggregationMethod |
analysis_wp | show_page | libraryId | path | pageName | webplayerSessionId | analysisId | service_instance_id | pageTabs or contextMenu | |
analysis_wp | switch_visualization | libraryId | path | originVisualizationType | visualizationType | webplayerSessionId | analysisId | service_instance_id | visualizationTitle |
analysis_wp | visualization_area_layout_mode | libraryId | path | visualizationAreaMode | webplayerSessionId | analysisId | service_instance_id | ||
analysis_wp | y_axis_number_of_scales | libraryId | path | numberOfScales | visualizationType | webplayerSessionId | analysisId | service_instance_id | origin |
auth | impersonate | uName | |||||||
auth | login | clientType | clientVer | displayName | |||||
auth | logout | uName | |||||||
auth_as | login | uName | |||||||
auth_as | logout | uName | |||||||
auth_pro | login | uName | |||||||
auth_pro | logout | uName | |||||||
auth_wp | login | uName | webplayerSessionId | ||||||
auth_wp | logout | uName | webplayerSessionId | ||||||
automation_job_as | job_finished | libraryId | libraryPath | jobId | status | executionTime | message | ||
automation_job_as | job_started | libraryId | libraryPath | jobId | status | executionTime | message | ||
automation_task_as | task_finished | libraryId | libraryPath | jobId | status | executionTime | message | ||
automation_task_as | task_started | libraryId | libraryPath | jobId | taskClass | unused | taskName | ||
codetrust | add_extcert | sort | name | serialNumber | issuer | ||||
codetrust | add_hash | sort | name | type | hash | signatureStatus | |||
codetrust | add_user | sort | trusting | trusted | |||||
codetrust | create_cert | serialNumber | subjectDN | ||||||
codetrust | remove_extcert | sort | name | serialNumber | issuer | ||||
codetrust | remove_hash | sort | name | type | hash | ||||
codetrust | remove_user | sort | trusting | trusted | |||||
codetrust | revoke_cert | serialNumber | date | ||||||
codetrust | upload_extcert | serialNumber | issuer | subjectDn | |||||
codetrust | upload_hash | hash | |||||||
data_connector_pro | create_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_pro | create_source | libraryId | libraryPath | dataSourceType | dataSourceInformation | ||||
data_connector_pro | get_data | libraryId | libraryPath | dataSourceType | dataSourceInformation | internalQuery | NumRows | duration | externalQuery |
data_connector_pro | load_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_pro | load_source | libraryId | libraryPath | dataSourceType | dataSourceInformation | ||||
data_connector_pro | synch_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_pro | update_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_pro | update_source | libraryId | libraryPath | dataSourceType | dataSourceInformation | ||||
data_connector_wp | create_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_wp | create_source | libraryId | libraryPath | dataSourceType | dataSourceInformation | ||||
data_connector_wp | get_data | libraryId | libraryPath | dataSourceType | dataSourceInformation | internalQuery | NumRows | duration | externalQuery |
data_connector_wp | load_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_wp | load_source | libraryId | libraryPath | dataSourceType | dataSourceInformation | ||||
data_connector_wp | synch_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_wp | update_connection | libraryId | libraryPath | dataSourceType | dataSourceInformation | dataSourceLibraryId | |||
data_connector_wp | update_source | libraryId | libraryPath | dataSourceType | dataSourceInformation | ||||
datafunction_pro | execute | unused | path | params | duration | ||||
datafunction_wp | execute | unused | path | params | duration | ||||
datasource_pro | execute | unused | path | title | params | duration | NumRows | ||
datasource_wp | execute | unused | path | title | params | duration | NumRows | ||
ems | create_connection | unused | unused | arguments | |||||
file_pro | load | unused | path | ||||||
file_wp | load | unused | path | ||||||
find_pro | search | libraryId | path | expression | |||||
find_wp | search | libraryId | path | expression | webPlayerSessionId | analysisId | serviceInstanceId | ||
info_link | create_il | libraryId | path | ||||||
info_link | get_data | libraryId | path | duration | sizeb | groupingId | |||
info_link | load_il | libraryId | path | groupingId | |||||
info_link | update_il | libraryId | path | ||||||
library | clear_perm | libraryId | path | recursive | |||||
library | copy | libraryId | path | libraryType | destLibraryId | destPath | groupingId | ||
library | create | libraryId | path | libraryType | preSize | postSize | |||
library | delete | libraryId | path | libraryType | groupingId | ||||
library | export | libraryId | path | destPath | groupingId | ||||
library | import | libraryId | path | destPath | groupingId | ||||
library | load_content | libraryId | path | libraryType | duration | sizeb | groupingId | ||
library | move | libraryId | path | libraryType | destLibraryId | destPath | groupingId | ||
library | remove_perm | libraryId | path | name | sort | ||||
library | save_content | libraryId | path | libraryType | preSize | postSize | |||
library | set_group_perm | libraryId | path | gName | permission | groupingId | |||
library | set_user_perm | libraryId | path | uName | permission | groupingId | |||
library_as | load | libraryId | path | ||||||
library_pro | close | libraryId | path | ||||||
library_pro | load | libraryId | path | ||||||
library_wp | clone | libraryId | path | webplayerSessionId | analysisId | ||||
library_wp | close | libraryId | path | webplayerSessionId | analysisId | ||||
library_wp | load | libraryId | path | webplayerSessionId | analysisId | ||||
library_wp | load_start | libraryId | path | webplayerSessionId | analysisId | ||||
library_wp | update | libraryId | libraryPath | webplayerSessionId | analysisId | ||||
library_wp | update_start | libraryId | libraryPath | webplayerSessionId | analysisId | ||||
routing_rules | create | ruleId | unused | ruleName | message | ||||
routing_rules | create_schedule | scheduleId | unused | scheduleName | message | ||||
routing_rules | delete | ruleId | unused | unused | message | ||||
routing_rules | disable | ruleId | unused | ruleName | message | ||||
routing_rules | enable | ruleId | unused | ruleName | message | ||||
routing_rules | update | ruleId | unused | ruleName | message | ||||
scheduled_updates | adjust_ratio | unused | libraryId | message | |||||
scheduled_updates | analysis_update | taskId | analysisId | destination | message | ||||
scheduled_updates | cancel_update | ruleId | libraryId | ruleName | destination | message | |||
scheduled_updates | evaluation | unused | unused | serviceUrl | seviceStatus | message | |||
scheduled_updates | external_update | ruleId | libraryId | analysisPath | resourcePool | message | |||
scheduled_updates | job_cancel_load | jobTaskId | serviceId | message | |||||
scheduled_updates | job_execution | jobId | taskId | payLoad | message | ||||
scheduled_updates | job_load | jobTaskId | serviceId | message | |||||
scheduled_updates | job_unload | jobTaskId | serviceId | message | |||||
scheduled_updates | load | ruleId | libraryId | ruleName | destinationList | message | |||
scheduled_updates | no_retry | unused | libraryId | message | |||||
scheduled_updates | no_update | taskId | libraryId | destination | message | ||||
scheduled_updates | queued | taskId | libraryId | duration | message | ||||
scheduled_updates | reload | ruleId | libraryId | ruleName | message | ||||
scheduled_updates | reschedule | ruleId | libraryId | ruleName | message | ||||
scheduled_updates | retry | unused | libraryId | destination | message | ||||
scheduled_updates | retry_exhausted | unused | unused | destination | message | ||||
scheduled_updates | routing | unused | libraryId | message | |||||
scheduled_updates | rule_schedule | ruleId | libraryId | ruleName | message | ||||
scheduled_updates | schedule_change | ruleId | libraryId | ruleName | message | ||||
scheduled_updates | su_evaluation | ruleId | libraryId | ruleName | message | ||||
scheduled_updates | su_execution | jobId | libraryId | message | |||||
scheduled_updates | su_request | jobId | libraryId | processType | message | ||||
scheduled_updates | task_execution | taskId | unused | destinationName | message | ||||
scheduled_updates | unload | ruleId | libraryId | ruleName | destinationList | message | |||
scheduled_updates | update | ruleId | libraryId | ruleName | message |
For more information, see Action log generic entries and Action log categories. For an example of a typical set of user actions logged to the action logs, see Sample action log output.
You can configure action logging so that only certain categories are logged. See Configuring the action log web service from the configuration tool for more information.