<div dir="ltr">The Unified Report really is the easiest/best way for the average person, but since I see you're a CLI/SQL kind of guy, like myself, here is the SQL query I use, which is similar to yours, but slightly different syntax, and I use LEFT JOIN versus INNER JOIN, table name aliases, column aliases, and sort by count, largest value on top.<div><br></div><div>run sql select <a href="http://m.name">m.name</a>, count(<a href="http://m.name">m.name</a>) as count from device as d left join typemodel as m on d.tkmodel = m.enum where m.tkclass = 1 group by <a href="http://m.name">m.name</a> order by count(<a href="http://m.name">m.name</a>) desc<br><br><div class="gmail_quote"><div dir="ltr">On Fri, Dec 1, 2017 at 11:52 AM John Franklin <<a href="mailto:john.franklin@voipintegration.com">john.franklin@voipintegration.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="m_-2566466178408930816WordSection1">
<p class="MsoNormal">You could get your desired output with a RUL SQL command<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b>run sql select count(tkmodel), <a href="http://typemodel.name" target="_blank">typemodel.name</a> from device inner join typemodel on enum = tkmodel where typemodel.tkclass = 1 group by tkmodel, <a href="http://typemodel.name" target="_blank">typemodel.name</a> order by <a href="http://typemodel.name" target="_blank">typemodel.name</a><u></u><u></u></b></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-AU" style="font-size:9.0pt;color:#0070c0">Regards,</span><span lang="EN-AU" style="font-size:4.0pt;color:#0070c0"><u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:4.0pt;font-family:"Cambria",serif;font-variant:small-caps;color:#1f497d"><u></u> <u></u></span></b></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;font-variant:small-caps;color:#1f497d">John Franklin
</span></b><b><span style="font-family:"Century Gothic",sans-serif;color:#1f497d"> </span></b><a href="mailto:John.Franklin@voipintegration.com" target="_blank"><i><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:#0070c0">John.Franklin@voipintegration.com</span></i></a><i><u><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:#0070c0"><u></u><u></u></span></u></i></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#0070c0">VoIP</span></b><span style="font-family:"Century Gothic",sans-serif;color:black">Integration</span><span style="color:#1f497d"> <b>|
</b></span><a href="http://www.voipintegration.com/" title="http://www.enpointe.com/" target="_blank"><i><span style="font-size:10.0pt;font-family:"Cambria",serif;color:#0070c0">www.VoIPintegration.com</span></i></a><b><span style="color:#1f497d"><u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black">201K Sand Creek Road
</span><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black">Brentwood, CA, USA. 94513
<u></u><u></u></span></p>
<p class="MsoNormal"><b><i><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black"><u></u> <u></u></span></i></b></p>
</div>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"></p></div></div></div></div><div lang="EN-US" link="#0563C1" vlink="#954F72"><div class="m_-2566466178408930816WordSection1"><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b>From:</b> cisco-voip [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Lelio Fulgenzi<br>
</p></div></div></div></div><div lang="EN-US" link="#0563C1" vlink="#954F72"><div class="m_-2566466178408930816WordSection1"><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b>Sent:</b> Wednesday, November 29, 2017 1:04 PM</p></div></div></div></div><div lang="EN-US" link="#0563C1" vlink="#954F72"><div class="m_-2566466178408930816WordSection1"><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><br>
<b>To:</b> voyp list, cisco-voip (<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>) <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>
<b>Subject:</b> [cisco-voip] phone model and quantity report...<u></u><u></u></p></div></div></div></div><div lang="EN-US" link="#0563C1" vlink="#954F72"><div class="m_-2566466178408930816WordSection1"><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Is there any way to get a dump of phone models and the quantity of each. No Bulk admin report has this information and I can’t copy/paste from RTMT.<u></u><u></u></p></div></div><div lang="EN-US" link="#0563C1" vlink="#954F72"><div class="m_-2566466178408930816WordSection1">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I’d rather not have to do a screen scrape.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thoughts?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div></div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote></div></div></div>