Im performing an audit for one of our larger clients where I am tasked with cross referencing the DID inventory for each trunk with what is on-file with each provider. I am fully aware of how to import/export using inbound rules however this wont work in this situation because the list is incomplete.
1 provider (Provider A) has an excess of 1200 DIDs and others are smaller, around 100 (Provider B).
Export from providers sites: A = 1250 and B = 100
Export from Inbound Rules: 1080 records, 1010 from A and 70 from B
When I go to "Add DID Rule" under inbound rules I have probably 200 unused DIDs that are ready for assignment. Its too much to count so I cant use this info in any way.
I need to some spreadsheet magic so that I can come up with the following lists:
DIDs on Provider X that dont exist in 3CX
DIDs in 3CX that dont exist on Provider X (numbers ported away)
DIDs on Provider X that exist on 3CX but with no Inbound Rule (I would create a rule to go to their internal "number not assigned" DR or "end call")
DIDs mismatched providers or other errors I encounter while scrubbing the data.
I know this could have been solved by proper procedures being followed when setting up DIDs but I didnt set this system up. Its a hodge podge of unnamed inbound rules and fairly unorganized. My other large sites that I spun up I can easily pull these reports because I keep the inbound rules accurate and there are never any unassigned DIDs in the system.
Does anybody have ideas on this? Am I missing anything?
1 provider (Provider A) has an excess of 1200 DIDs and others are smaller, around 100 (Provider B).
Export from providers sites: A = 1250 and B = 100
Export from Inbound Rules: 1080 records, 1010 from A and 70 from B
When I go to "Add DID Rule" under inbound rules I have probably 200 unused DIDs that are ready for assignment. Its too much to count so I cant use this info in any way.
I need to some spreadsheet magic so that I can come up with the following lists:
DIDs on Provider X that dont exist in 3CX
DIDs in 3CX that dont exist on Provider X (numbers ported away)
DIDs on Provider X that exist on 3CX but with no Inbound Rule (I would create a rule to go to their internal "number not assigned" DR or "end call")
DIDs mismatched providers or other errors I encounter while scrubbing the data.
I know this could have been solved by proper procedures being followed when setting up DIDs but I didnt set this system up. Its a hodge podge of unnamed inbound rules and fairly unorganized. My other large sites that I spun up I can easily pull these reports because I keep the inbound rules accurate and there are never any unassigned DIDs in the system.
Does anybody have ideas on this? Am I missing anything?
