mysql> show tables;
+—————————–+
| Tables_in_pbxconf |
+—————————–+
| activity_log |
| address |
| agent_pause_reasons |
| agents |
| ast_static_config |
| call_outcomes |
| call_ratings |
| channel_to_did_map |
| conferences |
| contact_group |
| contact_source |
| contact_source_attr |
| country_t |
| device_buttons |
| device_variables |
| devices |
| dialing_permissions |
| dialplan |
| dids |
| directory |
| dispatcher |
| domains |
| eventhooks |
| extensions |
| global_counts_view |
| global_defaults |
| group_contact |
| hints |
| huntlist_items |
| huntlists |
| iax_users |
| iceservers |
| inbound_source |
| inbound_source_actions |
| location |
| location_attrs |
| locations |
| meetme |
| menu_source |
| musiconhold |
| outbound_conference_members |
| outbound_conferences |
| parking_spaces |
| pbxconf_version |
| perms_entities |
| perms_feature_groups |
| perms_features |
| perms_group_roles |
| perms_group_users |
| perms_groups |
| perms_role_permissions |
| perms_roles |
| phone_templates |
| phone_templates_buttons |
| phone_templates_variables |
| pickupgroups |
| prosody |
| prosodyarchive |
| provisioning_maps |
| queue_dmembers |
| queue_members |
| queues |
| rtpengine |
| schedules |
| server_groups |
| servers |
| services |
| services_conferences |
| services_parking |
| services_queues |
| sip_users |
| sipregs |
| special_lines_iceservers |
| src_white_list |
| telephony_workers |
| telephony_workers_reversed |
| tenant_defaults |
| tenants |
| tenants_advanced_view |
| tl_dids |
| tl_extensions |
| tl_tenant_locations |
| tl_tenants |
| tl_trunks |
| tl_trunks_reversed |
| trunks |
| trusted |
| user_app_settings |
| user_crmlinks |
| user_extensions |
| user_extensions_iceservers |
| user_fax_settings |
| user_oauth |
| user_settings |
| user_settings_items |
| user_tenant |
| version |
| voicemail_users |
| webhooks |
| webmin_group |
| webmin_group_acl |
| webmin_group_attr |
| webmin_user |
| webmin_user_acl |
| webmin_user_attr |
| widgets |
+—————————–+
106 rows in set (0.00 sec)
| extensions | select * from sip_users (user_extensions); select * from sip_users where name like ‘%match%’ limit 1 \G |
| device | select * from devices where mac = ‘001565C7C33F’; |