01-28-2015 08:13 AM - edited 03-19-2019 09:06 AM
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
Solved! Go to Solution.
01-28-2015 10:47 AM
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.
01-28-2015 10:20 AM
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.
01-28-2015 10:47 AM
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.
01-28-2015 12:52 PM
Thank you both for your answers, much appreciated.
01-29-2015 12:29 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide