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

1 comment:

  1. If you know the root login from when you installed WFA (testing here with a WFA 4.2 standard install), then it is simple to access the database:
    C:\Program Files\NetApp\WFA\mysql\bin>mysql -u root -p
    Enter password: ********

    ReplyDelete