Carrier DID Audit

08-25-2026 20:21:09 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 20:21:09 SQL Statement: SELECT t.billing_did, t.carrier_did, t.carrier_id, t.DIDID, t.DID, t.id, t.name FROM (SELECT cd.billing_did AS billing_did, cd.carrier_did AS carrier_did, cd.carrier_id AS carrier_id, did.DIDID AS DIDID, did.DID AS DID, c.id AS id, c.name AS name FROM carrier_dids cd LEFT JOIN DID did ON cd.billing_did = did.DID LEFT JOIN carriersInbound c ON cd.carrier_id = c.id) AS t WHERE t.DIDID IS NULL ORDER BY t.carrier_did

08-25-2026 20:21:09 SQL Statement: SELECT t.DIDID, t.DID, t.customer_id, t.providerID, t.E911_ON, t.description, t.account_number, t.first_name, t.last_name, t.company_name, t.status, t.inactivation, t.id, t.name, t.billing_did, t.carrier_id FROM (SELECT did.DIDID AS DIDID, did.DID AS DID, did.customer_id AS customer_id, did.providerID AS providerID, did.E911_ON AS E911_ON, did.description AS description, cu.account_number AS account_number, cu.first_name AS first_name, cu.last_name AS last_name, cu.company_name AS company_name, cu.status AS status, cu.inactivation AS inactivation, ca.id AS id, ca.name AS name, cd.billing_did AS billing_did, cd.carrier_id AS carrier_id FROM DID did LEFT JOIN customer cu ON did.customer_id = cu.id LEFT JOIN carriersInbound ca ON did.providerID = ca.id LEFT JOIN carrier_dids cd ON did.DID = cd.billing_did) AS t WHERE t.carrier_id IS NULL ORDER BY t.DID

08-25-2026 20:21:09 SQL Statement: SELECT t.DIDID, t.DID, t.customer_id, t.providerID, t.E911_ON, t.description, t.account_number, t.first_name, t.last_name, t.company_name, t.status, t.inactivation, t.id, t.name, t.billing_did, t.carrier_id FROM (SELECT did.DIDID AS DIDID, did.DID AS DID, did.customer_id AS customer_id, did.providerID AS providerID, did.E911_ON AS E911_ON, did.description AS description, cu.account_number AS account_number, cu.first_name AS first_name, cu.last_name AS last_name, cu.company_name AS company_name, cu.status AS status, cu.inactivation AS inactivation, ca.id AS id, ca.name AS name, cd.billing_did AS billing_did, cd.carrier_id AS carrier_id FROM DID did LEFT JOIN customer cu ON did.customer_id = cu.id LEFT JOIN carriersInbound ca ON did.providerID = ca.id LEFT JOIN carrier_dids cd ON did.DID = cd.billing_did) AS t WHERE id <> carrier_id ORDER BY t.DID