<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body dir="auto">
<div><br>
</div>
Depending on how quick (and repetitively) you need the information, you can likely export all phone details, import into excel and go to the column which contains the xml code and search in there. (Unix tools could help too).
<div><br>
</div>
<div>You might need to do a baseline to see what on and off look like. </div>
<div><br>
</div>
<div>I did this to find which phones have a Cisco support field filled out. </div>
<div><br>
</div>
<div>I’m guessing the information you’re looking for should be contained within that XML section as well. </div>
<div><br>
</div>
<div>Might be an option for you. <br>
<br>
<div dir="ltr">Sent from my iPhone</div>
<div dir="ltr"><br>
<blockquote type="cite">On Apr 2, 2021, at 11:12 AM, Nick Barnett <nick@barnett.email> wrote:<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr">
<title></title>
<p></p>
<div style="background-color:#FFEB9C; width:100%; border-style: solid; border-color:#9C6500; border-width:1pt; padding:2pt; font-size:10pt; line-height:12pt; font-family:'Calibri'; color:Black; text-align: left;">
<span style="font-weight:bold;">CAUTION:</span> This email originated from outside of the University of Guelph. Do not click links or open attachments unless you recognize the sender and know the content is safe. If in doubt, forward suspicious emails to IThelp@uoguelph.ca</div>
<br>
<p></p>
<div>Does anyone have a way to do this? This setting is stored in the device specific settings for the phone, so retrieving the entry in the device table isn't sufficient. There is also the advanceddeviceconfigparams table, but I can't figure out how to interract
with it properly. <br>
</div>
<div><br>
</div>
<div>Usually I start out with something simple like:<br>
</div>
<div>select * from device where name='SEPDEADBEEF1234'</div>
<div><br>
</div>
<div>and then I can drill down, my next attempt was:<br>
</div>
<div>select * from advanceddeviceconfigparams where fkdevice='PKID-OF-MY-PHONE'<br>
</div>
<div><br>
</div>
<div>which returned nothing<br>
</div>
<div><br>
</div>
<div>then I went to my lab cluster and did:<br>
</div>
<div>select * from advanceddeviceconfigparams</div>
<div><br>
</div>
<div>and nothing came back.<br>
</div>
<div><br>
</div>
<div>I was expecting a list of UUIDs and settings to come back that I would then continue to step through until I got the data I needed. So I guess I don't know how device table interracts with advanceddeviceconfigparams. What am i missing here?<br>
</div>
<div><br>
</div>
<div>Any help is appreciated.</div>
<div><br>
</div>
<div id="sig91721560">
<div class="signature">Thanks,<br>
</div>
<div class="signature">Nick<br>
</div>
</div>
<div><br>
</div>
<span>_______________________________________________</span><br>
<span>cisco-voip mailing list</span><br>
<span>cisco-voip@puck.nether.net</span><br>
<span>https://puck.nether.net/mailman/listinfo/cisco-voip</span><br>
</div>
</blockquote>
</div>
</body>
</html>