List active IP phones - NEC NEAX 2000

I have recently taken over managing an NEC NEAX 2000 IVS.
There are 200 Extensions setup on this system but nowhere near as many handsets.
I have tried to setup a couple of new phones (IP Dterm) on unused extensions but they are coming up as “double assignment”.

I know how to fix the double assignment issue, but is there a way to report on IP phones that are currently active or extension numbers that are configured but do not have an active IP phone associated?

I would like to mark all spare extensions for future use.

LVL 10
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Is this an NEC 2400 or an NEC 2000?  Different adminstration front ends.
APNFSSCAuthor Commented:
I am fairly sure that it is a NEC 2000 IVS.

Just realised that my title is incorrect, is it possible to edit my original post?
not sure about title, but it may not matter.
I am more familiar the 2400 than the 2000, but I am pretty sure the NEC 2000 IVS did not support IP phones (only digital) - is it possible that you have an NEC 2000 IPS?
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

APNFSSCAuthor Commented:
It is possible but I am unsure how to confirm, I definitely have IP phone connected to the system.
With the NEC 2000, the only way to run reports on what is programmed is with a software program called MATWorX that NEC provided in most cases.  Do you have this?  Do you have the command manual for it?
Otherwise, you are stuck with going through an entry at a time to look up what is in there and making hand written notes.  Ugh.
APNFSSCAuthor Commented:
I ended up using MATWorX to do an Office Data Listup on Stations.
The CSV that was created showed data for 1290, this field contains the MAC address of registered IP phones.
I then sorted it in Excel and found all of the extensions with no MAC address.

Worked for me, not sure if there was a better way to do it.

No - that is the only way to do it.  As I mentioed, MATWorX is the only method to get a report, and as you found out, the only way you can manipulate it is in a spreadsheet.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Voice Over IP

From novice to tech pro — start learning today.