Set SIP Server Provisioning

08-25-2026 21:52:45 SQL Statement: SELECT id, account_number, company_name, first_name, last_name, status, auto_inactive_enable, inactivation, billing_type, parent, wholesale, child, credit_card_failure, account_manager FROM customer WHERE id = '42'

08-25-2026 21:52:45 SQL Statement: SELECT id, customer_id, sipserver_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id = '42'

08-25-2026 21:52:45 SQL Statement: SELECT COUNT(*) AS quantity FROM sipServers WHERE serverID = ''

08-25-2026 21:52:45 SQL Statement: SELECT t.id, t.childId, t.parentId, t.childAccountNum, t.childStatus, t.childDeactive, t.childFirstName, t.childLastName, t.childCompany, t.parentAccountNum, t.parentWholesale, t.parentFirstName, t.parentLastName, t.parentCompany FROM (SELECT pair.id AS id, pair.child_id AS childId, pair.parent_id AS parentId, c.account_number AS childAccountNum, c.status AS childStatus, c.inactivation AS childDeactive, c.first_name AS childFirstName, c.last_name AS childLastName, c.company_name AS childCompany, p.account_number AS parentAccountNum, p.wholesale AS parentWholesale, p.first_name AS parentFirstName, p.last_name AS parentLastName, p.company_name AS parentCompany FROM customer_parent_child pair LEFT JOIN customer c ON pair.child_id = c.id LEFT JOIN customer p ON pair.parent_id = p.id) AS t WHERE t.parentId = '42' ORDER BY t.parentId

08-25-2026 21:52:45 SQL Statement: SELECT COUNT(*) AS quantity FROM customer_device_info WHERE customer_id = '42'

08-25-2026 21:52:45 SQL Statement: SELECT customer_device_id, device_info_id, customer_id, account_number, first_name, last_name, company_name, status, inactivation, box_num, mac_address, ip_address, port_number, allow_changing_port, follow_changing_port, canreinvite, admin_email, notes, type, typeName, box_serial, software_serial, extension_count, acd_extension_count, support_end_date, update_end_date, http_address, lan_ip, ssh_port, web_port, require_vlan, ssl_enable, voip_pw, pbxadmin_pw, eula_agreement, eula_addendum1_agreement, support_agreement FROM customer_device_info WHERE customer_id = '42'

08-25-2026 21:52:45 SQL Statement: SELECT id, name, host, accountcode, priorityDomestic, priorityInternational, priorityE911, priorityE411, dialstringDomestic, dialstringInternational, dialstringSpecial, addressStyle, tcp_enable, port FROM carriersOutbound ORDER BY name

08-25-2026 21:52:45 SQL Statement: SELECT id, name, tcp_enable FROM carriersInbound ORDER BY name

08-25-2026 21:52:45 SQL Statement: SELECT trunk_id, customer_id, trunk_number, secret, callForward, down_forward_trunkid, down_forward_trunknumber, ipAddress, callerID, caller_id_name, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, allow_g711, default_carriers_also, serverID, server_name, server_url, active, master FROM sip_provisioning WHERE status = '1' AND inactivation = '0' AND serverID = '' ORDER BY trunk_number

08-25-2026 21:52:45 SQL Statement: SELECT id, customer_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id IN (NULL) ORDER BY trunk_number

08-25-2026 21:52:45 SQL Statement: SELECT serverID, server_name, server_url, db_name, user, pass, active, master FROM sipServers WHERE active = '1' AND master = '0' ORDER BY server_name

08-25-2026 21:52:45 SQL Statement: SELECT id, typeName, status FROM device_type ORDER BY typeName