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.
run sql select m.name, count(m.name) as count from device as d left join typemodel as m on d.tkmodel = m.enum where m.tkclass = 1 group by m.name order by count(m.name) desc On Fri, Dec 1, 2017 at 11:52 AM John Franklin < [email protected]> wrote: > You could get your desired output with a RUL SQL command > > > > *run sql select count(tkmodel), typemodel.name <http://typemodel.name> > from device inner join typemodel on enum = tkmodel where > typemodel.tkclass = 1 group by tkmodel, typemodel.name > <http://typemodel.name> order by typemodel.name <http://typemodel.name>* > > > > > > Regards, > > > > *John Franklin * *[email protected]* > <[email protected]> > > *VoIP*Integration *| **www.VoIPintegration.com* > <http://www.voipintegration.com/> > > 201K Sand Creek Road > > Brentwood, CA, USA. 94513 > > > > *From:* cisco-voip [mailto:[email protected]] *On Behalf > Of *Lelio Fulgenzi > > *Sent:* Wednesday, November 29, 2017 1:04 PM > > > *To:* voyp list, cisco-voip ([email protected]) < > [email protected]> > *Subject:* [cisco-voip] phone model and quantity report... > > > > > > 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. > > > > I’d rather not have to do a screen scrape. > > > > Thoughts? > > > _______________________________________________ > cisco-voip mailing list > [email protected] > https://puck.nether.net/mailman/listinfo/cisco-voip >
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
