Mirtapbx database

mysql> show tables;
+—————————–+
| Tables_in_asterisk |
+—————————–+
| ab_alarmsbinding |
| ac_autocharges |
| ag_agiscripts |
| al_alarms |
| al_autoprovisionlabels |
| aq_allowed_queue_member |
| ar_alarmsreceived |
| ar_autorefills |
| av_autoprovisionvalues |
| ba_backups |
| bi_billings |
| bl_blacklists |
| bl_buttonlayouts |
| bt_buttonlayouttemplates |
| ca_calleridmods |
| ca_campaigns |
| ca_cdranalyze |
| cc_callcosts |
| cc_cnamecache |
| cd_codecs |
| ce_conditions_extended |
| ce_customextensions |
| ce_customs_extended |
| cf_customfiles |
| cg_callgroups |
| cl_clientrates |
| cl_conferenceroomlogs |
| cn_campaignnumbers |
| co_conditions |
| co_countries |
| cp_clustersportal |
| cp_customextensionproviders |
| cr_calleridmodrules |
| cr_calleridregexs |
| cr_callreservations |
| cr_conferencerooms |
| cr_cronjobs |
| csv_importer |
| ct_customtypes |
| cu_customs |
| dc_donotcalls |
| de_destinations |
| de_devstateevents |
| df_default_fields |
| di_dids |
| dl_dialingrules |
| dl_dnc_numbers |
| dn_dialbyname |
| dp_didproviders |
| ds_disas |
| dt_datetimeformats |
| dv_default_values |
| ea_externalagents |
| ed_extensiondialings |
| ee_extensionevents |
| es_phonebookexternalsources |
| et_emailtemplates |
| ex_extensions |
| fa_faxes |
| fe_features |
| fl_flows |
| followme |
| followme_numbers |
| fs_fail2banstatus |
| ft_faxattempts |
| ge_geoip |
| gn_groupnames |
| gr_groupcounts |
| hu_huntlists |
| iaxfriends |
| ib_inboundrates |
| id_ipdatabase |
| il_ivr_logs |
| ir_internalroutings |
| iv_ivrs |
| la_languages |
| ld_lastnumbersdialed |
| me_mediafiles |
| meetme |
| mf_mailtofaxes |
| mm_messages |
| mm_mmsmedias |
| mu_managerusers |
| mu_musiconholds |
| musiconhold |
| no_nodes |
| od_outbounddids |
| pa_paginggroups |
| pb_phonebooks |
| pc_pincodes |
| pc_providercosts |
| pc_proxyapi_cache |
| pd_phonebookdetails |
| pe_phonebookentries |
| pf_phonefeedbacks |
| pfb_phonefeedbacks_binary |
| pg_pickupgroups |
| ph_phones |
| pi_phonebookitems |
| pk_parkinglots |
| pl_phonebooklayouts |
| pl_phonebuttonlayouts |
| pl_provisioninglogs |
| pm_phonemodels |
| pp_panelpositions |
| pp_phonephonebooks |
| pp_profileprivileges |
| pr_parkinglotsreturns |
| pr_privacy |
| pr_providers |
| ps_aors |
| ps_asterisk_publications |
| ps_auths |
| ps_contacts |
| ps_contacts_mirtapbx01 |
| ps_contacts_mirtapbx02 |
| ps_contacts_mirtapbx03 |
| ps_contacts_mirtapbx04 |
| ps_contacts_mirtapbx05 |
| ps_contacts_mirtapbx06 |
| ps_domain_aliases |
| ps_endpoint_id_ips |
| ps_endpoints |
| ps_globals |
| ps_inbound_publications |
| ps_outbound_publishes |
| ps_registrations |
| ps_resource_list |
| ps_subscription_persistence |
| ps_systems |
| ps_transports |
| qa_queueabandonednotified |
| qc_queuecallbacks |
| qu_queues |
| queue |
| queue_log |
| queue_member |
| ra_rates |
| rd_reportsdata |
| rd_reportsdata_bin |
| re_recordings |
| re_regions |
| re_reports |
| re_rtpanelextensions |
| ri_rings |
| rm_realtimemodules |
| rmc_realtimemodulecontent |
| rn_reservednumbers |
| rp_realtimepanels |
| rp_responsepaths |
| rp_routingprofiles |
| rpm_realtimepanelmodules |
| rr_calleridregex_rules |
| rr_conferenceroomsrates |
| rr_responsepathresponses |
| rt_rtpanelpositions |
| se_settings |
| se_settings_max |
| sessions2 |
| sipfriends |
| sipregs |
| sipregs_mirtapbx05 |
| sipregs_mirtapbx06 |
| sl_serverlogs |
| sm_smslogs |
| sn_shortnumbers |
| sp_specials |
| sp_specialsbackup |
| sr_sipratestatus |
| ss_smstobesent |
| st_speechtotexts |
| st_states |
| st_stats |
| tc_tenantconduits |
| te_tenants |
| te_texts |
| th_themes |
| tr_translations |
| tt_testit_ip |
| tv_tenantvariables |
| tz_timezones |
| uc_userclientrates |
| ug_userprivileges |
| ul_userlogs |
| up_userprofiles |
| ur_userroutingprofiles |
| us_users |
| ut_usertenants |
| uu_useruserprofiles |
| ve_versions |
| ve_virtualextensions |
| ve_voiceengines |
| vi_virtualextensionitems |
| vl_voicemaillog |
| vo_voices |
| voicemail |
| voicemail_data |
| voicemail_messages |
| wb_wallboards |
| wc_ip |
| we_wallboardelements |
| wh_webhooks |
| wi_wallboarditems |
| ws_wallboardstructures |
| xt_xmltemplates |
+—————————–+
205 rows in set (0.00 sec)

find a mac address, and delete it from relevant table. (maybe multiple db)

mysql> delete from ph_phones where ph_mac = ’00:0B:82:FA:F6:75′;
Query OK, 1 row affected (0.01 sec)

mysql> select di_te_id from di_dids limids where di_area = ‘514’ and di_number = ‘3099999’;

find the tenant name from a daily report email

select * from re_reports where re_email like ‘%malek%’;