Exploring the OnCommand Workflow Automation 4.1 MySQL Databases

Using the technique from Jovicailic.org which was used in Resetting OnCommand Insight 7.3 DWH admin Credentials the MySQL Way (I don’t know the MySQL root password for WFA), this post explores the databases and tables that exist with a new install of WFA 4.1. I think with any product that uses a database server, knowing the databases and tables improve understanding of the product.

Image: WFA 4.1 Databases

WFA 4.1 Databases

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| cm_performance     |

| cm_storage         |

| logs               |

| mysql              |

| performance        |

| performance_schema |

| playground         |

| storage            |

| test               |

| tmp                |

| vc                 |

| wfa                |

| wfa_proc           |

| wfa_staging        |

+--------------------+

Database: information_schema

mysql> use information_schema

Database changed

mysql> show tables;

+---------------------------------------+

| Tables_in_information_schema          |

+---------------------------------------+

| CHARACTER_SETS                        |

| COLLATIONS                            |

| COLLATION_CHARACTER_SET_APPLICABILITY |

| COLUMNS                               |

| COLUMN_PRIVILEGES                     |

| ENGINES                               |

| EVENTS                                |

| FILES                                 |

| GLOBAL_STATUS                         |

| GLOBAL_VARIABLES                      |

| KEY_COLUMN_USAGE                      |

| OPTIMIZER_TRACE                       |

| PARAMETERS                            |

| PARTITIONS                            |

| PLUGINS                               |

| PROCESSLIST                           |

| PROFILING                             |

| REFERENTIAL_CONSTRAINTS               |

| ROUTINES                              |

| SCHEMATA                              |

| SCHEMA_PRIVILEGES                     |

| SESSION_STATUS                        |

| SESSION_VARIABLES                     |

| STATISTICS                            |

| TABLES                                |

| TABLESPACES                           |

| TABLE_CONSTRAINTS                     |

| TABLE_PRIVILEGES                      |

| TRIGGERS                              |

| USER_PRIVILEGES                       |

| VIEWS                                 |

| INNODB_LOCKS                          |

| INNODB_TRX                            |

| INNODB_SYS_DATAFILES                  |

| INNODB_LOCK_WAITS                     |

| INNODB_SYS_TABLESTATS                 |

| INNODB_CMP                            |

| INNODB_METRICS                        |

| INNODB_CMP_RESET                      |

| INNODB_CMP_PER_INDEX                  |

| INNODB_CMPMEM_RESET                   |

| INNODB_FT_DELETED                     |

| INNODB_BUFFER_PAGE_LRU                |

| INNODB_SYS_FOREIGN                    |

| INNODB_SYS_COLUMNS                    |

| INNODB_SYS_INDEXES                    |

| INNODB_FT_DEFAULT_STOPWORD            |

| INNODB_SYS_FIELDS                     |

| INNODB_CMP_PER_INDEX_RESET            |

| INNODB_BUFFER_PAGE                    |

| INNODB_CMPMEM                         |

| INNODB_FT_INDEX_TABLE                 |

| INNODB_FT_BEING_DELETED               |

| INNODB_SYS_TABLESPACES                |

| INNODB_FT_INDEX_CACHE                 |

| INNODB_SYS_FOREIGN_COLS               |

| INNODB_SYS_TABLES                     |

| INNODB_BUFFER_POOL_STATS              |

| INNODB_FT_CONFIG                      |

+---------------------------------------+

Database: cm_performance

mysql> use cm_performance;

Database changed

mysql> show tables;

+--------------------------+

| Tables_in_cm_performance |

+--------------------------+

| aggregate_performance    |

+--------------------------+

Database: cm_storage

mysql> use cm_storage;

Database changed

mysql> show tables;

+---------------------------+

| Tables_in_cm_storage      |

+---------------------------+

| aggregate                 |

| annotation                |

| broadcast_domain          |

| cifs_share                |

| cifs_share_acl            |

| cluster                   |

| cluster_annotation        |

| cluster_license           |

| cluster_peer              |

| disk                      |

| disk_aggregate            |

| efficiency_policy         |

| export_policy             |

| export_rule               |

| failover_group            |

| fcp_adapter               |

| igroup                    |

| ipspace                   |

| logical_interface         |

| lun                       |

| lunmap                    |

| node                      |

| port                      |

| portset                   |

| portset_member            |

| qos_policy_group          |

| qtree                     |

| resource_group            |

| resource_group_member     |

| resource_pool             |

| resource_pool_member      |

| schedule                  |

| snapmirror                |

| snapmirror_policy         |

| snapmirror_policy_rule    |

| snapmirror_svm            |

| snapshot_policy           |

| snapshot_policy_schedule  |

| storage_pool              |

| storage_pool_aggregate    |

| storage_pool_available    |

| volume                    |

| volume_annotation         |

| vserver                   |

| vserver_allowed_aggregate |

| vserver_annotation        |

| vserver_association       |

| vserver_peer              |

+---------------------------+

Database: logs

mysql> use logs;

Database changed

mysql> show tables;

Empty set (0.00 sec)

Database: mysql

mysql> use mysql;

Database changed

mysql> show tables;

+---------------------------+

| Tables_in_mysql           |

+---------------------------+

| columns_priv              |

| db                        |

| event                     |

| func                      |

| general_log               |

| help_category             |

| help_keyword              |

| help_relation             |

| help_topic                |

| innodb_index_stats        |

| innodb_table_stats        |

| ndb_binlog_index          |

| plugin                    |

| proc                      |

| procs_priv                |

| proxies_priv              |

| servers                   |

| slave_master_info         |

| slave_relay_log_info      |

| slave_worker_info         |

| slow_log                  |

| tables_priv               |

| time_zone                 |

| time_zone_leap_second     |

| time_zone_name            |

| time_zone_transition      |

| time_zone_transition_type |

| user                      |

+---------------------------+

Database: performance

mysql> use performance;

Database changed

mysql> show tables;

+-----------------------+

| Tables_in_performance |

+-----------------------+

| aggregate_performance |

| array_performance     |

+-----------------------+

Database: performance_schema

mysql> use performance_schema;

Database changed

mysql> show tables;

+----------------------------------------------------+

| Tables_in_performance_schema                       |

+----------------------------------------------------+

| accounts                                           |

| cond_instances                                     |

| events_stages_current                              |

| events_stages_history                              |

| events_stages_history_long                         |

| events_stages_summary_by_account_by_event_name     |

| events_stages_summary_by_host_by_event_name        |

| events_stages_summary_by_thread_by_event_name      |

| events_stages_summary_by_user_by_event_name        |

| events_stages_summary_global_by_event_name         |

| events_statements_current                          |

| events_statements_history                          |

| events_statements_history_long                     |

| events_statements_summary_by_account_by_event_name |

| events_statements_summary_by_digest                |

| events_statements_summary_by_host_by_event_name    |

| events_statements_summary_by_thread_by_event_name  |

| events_statements_summary_by_user_by_event_name    |

| events_statements_summary_global_by_event_name     |

| events_waits_current                               |

| events_waits_history                               |

| events_waits_history_long                          |

| events_waits_summary_by_account_by_event_name      |

| events_waits_summary_by_host_by_event_name         |

| events_waits_summary_by_instance                   |

| events_waits_summary_by_thread_by_event_name       |

| events_waits_summary_by_user_by_event_name         |

| events_waits_summary_global_by_event_name          |

| file_instances                                     |

| file_summary_by_event_name                         |

| file_summary_by_instance                           |

| host_cache                                         |

| hosts                                              |

| mutex_instances                                    |

| objects_summary_global_by_type                     |

| performance_timers                                 |

| rwlock_instances                                   |

| session_account_connect_attrs                      |

| session_connect_attrs                              |

| setup_actors                                       |

| setup_consumers                                    |

| setup_instruments                                  |

| setup_objects                                      |

| setup_timers                                       |

| socket_instances                                   |

| socket_summary_by_event_name                       |

| socket_summary_by_instance                         |

| table_io_waits_summary_by_index_usage              |

| table_io_waits_summary_by_table                    |

| table_lock_waits_summary_by_table                  |

| threads                                            |

| users                                              |

+----------------------------------------------------+

Database: playground

mysql> use playground;

Database changed

mysql> show tables;

Empty set (0.00 sec)

Database: storage

mysql> use storage;

Database changed

mysql> show tables;

+-----------------------+

| Tables_in_storage     |

+-----------------------+

| aggregate             |

| array                 |

| array_license         |

| cifs_share            |

| cifs_share_acl        |

| dataset               |

| disk                  |

| igroup                |

| igroup_initiator      |

| interface             |

| lun                   |

| lunmap                |

| nfs_export            |

| object_comment        |

| qtree                 |

| quota                 |

| resource_group        |

| resource_group_member |

| resource_pool         |

| snapshot              |

| snapvault             |

| user_quota            |

| vfiler                |

| volume                |

| vsm                   |

+-----------------------+

Database: test

mysql> use test;

Database changed

mysql> show tables;

Empty set (0.00 sec)

Database: tmp

mysql> use tmp;

Database changed

mysql> show tables;

Empty set (0.00 sec)

Database: vc

mysql> use vc;

Database changed

mysql> show tables;

+-----------------+

| Tables_in_vc    |

+-----------------+

| data_store      |

| host            |

| lun             |

| nas_share       |

| virtual_disk    |

| virtual_machine |

+-----------------+

Database: wfa

mysql> use wfa;

Database changed

mysql> show tables;

+---------------------------------------+

| Tables_in_wfa                         |

+---------------------------------------+

| api_stats                             |

| cache_query                           |

| cache_query_data_provider_type        |

| category                              |

| category_ldap_group                   |

| category_user                         |

| category_workflow                     |

| child_workflow_user_input_value       |

| command_credential                    |

| command_definition                    |

| command_execution_progress            |

| command_implementation                |

| command_parameter_definition          |

| command_parameter_mapping             |

| connection_protocol_detail            |

| criteria                              |

| criterion                             |

| criterion_group                       |

| data_provider_type                    |

| data_source                           |

| data_source_connection                |

| dictionary_entry                      |

| dictionary_entry_policy               |

| dictionary_entry_policy_property      |

| dictionary_entry_property             |

| disabled_dictionary_entry             |

| execution_instance                    |

| execution_log_message                 |

| filter                                |

| filter_parameter                      |

| filter_returned_attribute             |

| find_chart                            |

| find_chart_node                       |

| find_chart_node_define_property       |

| find_chart_node_finder_parameters     |

| find_chart_node_return_attributes     |

| finder                                |

| finder_attribute                      |

| finder_filter                         |

| function_definition                   |

| global_config                         |

| job_committed                         |

| job_configuration                     |

| job_configuration_notification        |

| job_execution                         |

| job_history                           |

| job_schedule_info                     |

| job_workflow_user_input               |

| ldap_group                            |

| ldap_user_group                       |

| pack                                  |

| pack_entities                         |

| protocol_detail                       |

| remote_system_type                    |

| reservation                           |

| reservation_command_parameter         |

| schedule_association                  |

| schedule_association_user_input       |

| scheme                                |

| store_entity                          |

| store_pack                            |

| user                                  |

| user_role_to_ejb_role                 |

| version_upgrade_history               |

| workflow                              |

| workflow_command                      |

| workflow_command_details              |

| workflow_command_mapped_object        |

| workflow_command_parameter_value      |

| workflow_constant                     |

| workflow_define_object                |

| workflow_define_object_property_value |

| workflow_display_setting              |

| workflow_execution_breakpoint         |

| workflow_execution_condition          |

| workflow_execution_result             |

| workflow_execution_status             |

| workflow_filter_parameter_value       |

| workflow_incremental_naming_policy    |

| workflow_natural_key_value            |

| workflow_resource_selector            |

| workflow_return_parameter             |

| workflow_row                          |

| workflow_row_loop_info                |

| workflow_row_loop_info_variable       |

| workflow_user_input                   |

| workflow_user_input_group             |

| workflow_user_input_type              |

+---------------------------------------+

Database: wfa_proc

mysql> use wfa_proc;

Database changed

mysql> show tables;

Empty set (0.00 sec)

Database: wfa_staging

mysql> use wfa_staging;

Database changed

mysql> show tables;

+------------------------------+

| Tables_in_wfa_staging        |

+------------------------------+

| object_global_cm_performance |

| object_global_cm_storage     |

| object_global_performance    |

| object_global_storage        |

| object_global_vc             |

+------------------------------+