[cisco-voip] phone model and quantity report...

[Anthony Holloway]

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 <
john.franklin at voipintegration.com> 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 * *John.Franklin at voipintegration.com*
> <John.Franklin at voipintegration.com>
>
> *VoIP*Integration *| **www.VoIPintegration.com*
> <http://www.voipintegration.com/>
>
> 201K Sand Creek Road
>
> Brentwood, CA, USA. 94513
>
>
>
> *From:* cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] *On Behalf
> Of *Lelio Fulgenzi
>
> *Sent:* Wednesday, November 29, 2017 1:04 PM
>
>
> *To:* voyp list, cisco-voip (cisco-voip at puck.nether.net) <
> cisco-voip at puck.nether.net>
> *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
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20171201/080b134a/attachment.html>