Monday, 10 July 2017

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             |
+------------------------------+

No comments:

Post a Comment