Phone Firmware report for hard coded devices

[Emad Wahba]

To roll out new phone firmware in UCM 9.1.2, we opted as first step after lab test to update some individual phones in production by hard coding the "Phone Load Name" field for several beta users.  We also have some vpn phones that we hard coded with specific firmware load value that resolves some vulnerability.  What I'm looking to do is figure out a query to report on all the phones that have been hard coded, and a way to bulk change these values or remove it.

Thank you

[Jaime Valencia]

You would need to use BAT for all that, pull a report and you'll find out whether something is in that field or no, and you would need to use the same to then change the values updating your config.

[Rolando Valenzuela · Accepted solution]

Like Jaime said, BAT is going to be the easier :) take this video as an example, it can help you.

https://www.youtube.com/watch?v=v1vNe_90Tuo

Regards.

Rolando Valenzuela.

[Emad Wahba]

Thank you both for your answers, much appreciated.

[Gordon Ross]

Unified Reporting -> System Reports -> Unified CM Phones With Mismatched Load will tell you what phones have an explicit phone load specified.

You can also use the command line to get the information too:

admin: run sql SELECT name, description, specialloadinformation FROM device WHERE specialloadinformation IS NOT NULL AND len(specialloadinformation)>0

You could use the SQL command line to update the firmware information, but BAT is a lot easier in this case.

GTG