Organization of management of budget IP-phones in the local network. What software and methods to use?

Question

Telephony

There is a local network with budget IP phones Fanvill F52.
PBX - cloud.
The number of phones is growing and the question is how to administer all this. Now each phone is configured manually via the web interface, but there are difficulties in support:
1. When changing the general settings of the settings, you need to configure each one again.
2. There is no user (computer)-phone binding. If the user has problems, or when changing an employee, you need to go with your legs to the workplace and look at the IP of the phone in order to know which one to configure.
item 1. solved with autoprovisioning
But how to solve the second point? You need some kind of database, or software in which you can connect phones with some kind of jobs, monitor all this (for example, via SNMP). Plus, it is desirable that it skillfully work with the configuration files of the same Fanvill in order to configure it centrally.
There was an idea to correlate the IP addresses of workstations and telephones, for example, a computer xxx.xxx.0.25, a phone connected to the computer xxx.xxx.1.25, but I'm not sure that DHCP can be taught this.
How in general all this should be administered in a normal way?

Answer 1

View table:
| No. p / p | Internal number | MAC | IP-address| Login | Password | User | Where installed | Note |
In any form (csv, xls, dbf, Keepass). Naturally, to limit the availability of data from unauthorized persons. From personal experience, it's enough for a network of up to 500 phones; more than 500 - I don’t know, but I don’t think there will be a big difference.
The IP address must be fixed (either static, or reserved for DHCP) and recorded in a table. This will save you from running to the phones. I don’t know how it is in a cloudy PBX, but in the internal one you can usually see from which address the phone was registered or was last registered.
I see no point in linking the correspondence of the phone address and the computer address, if there are no scripts in which this would increase optimization.