I need to update the field eapAuthentication in all ip phones by sql. But I'm not able to found the table of eapAuthentication field is presented.
Could you know what is the table?
Looking at the UI and Data Dictionary, it appears:
- device.fkwirelesslanprofilegroup indicates the device's 'Wireless LAN Profile Group'. If the WLAN group/profiles have already been configured, then you probably only need to update this field
- wirelesslanprofilegroupmember.fkwirelesslanprofile points to the individual profile
- wirelesslanprofile.tkwifiauthenticationmethod indicates the type of auth, i.e. one of:
select * from typewifiauthenticationmethod
enum name moniker displayorder
==== ============= ======================================== ============
0 None WIFI_AUTHENTICATION_METHOD_NONE 6
1 WEP WIFI_AUTHENTICATION_METHOD_WEP 5
2 PSK WIFI_AUTHENTICATION_METHOD_PSK 4
3 EAP-FAST WIFI_AUTHENTICATION_METHOD_EAP_FAST 1
4 PEAP-MSCHAPv2 WIFI_AUTHENTICATION_METHOD_PEAP_MSCHAPV2 2
5 PEAP-GTC WIFI_AUTHENTICATION_METHOD_PEAP_GTC 3
Note, to set the reverse password for a Wireless Lan Profile, you will likely need to use the <updateWLANProfile> request, which will properly hash the password into the table.
I forgot to say that I'm talking about Cisco IP Phone, sorry