Re: [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.frank...@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.frank...@voipintegration.com*
> <john.frank...@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-boun...@puck.nether.net] *On Behalf
> Of *Lelio Fulgenzi
>
> *Sent:* Wednesday, November 29, 2017 1:04 PM
>
>
> *To:* voyp list, cisco-voip (cisco-voip@puck.nether.net) <
> cisco-voip@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@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Lelio Fulgenzi]

Another thanks.

I completely forgot about this reporting tool. Will need to review to see if 
there’s other things in there that can save me time.

Lelio

From: bmead...@gmail.com [mailto:bmead...@gmail.com] On Behalf Of Brian Meade
Sent: Friday, December 1, 2017 12:15 PM
To: Lelio Fulgenzi <le...@uoguelph.ca>
Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
<cisco-voip@puck.nether.net>
Subject: Re: [cisco-voip] phone model and quantity report...

Under Unified Reporting in top right dropdown then run Device Count Summary.

On Wed, Nov 29, 2017 at 4:04 PM, Lelio Fulgenzi 
<le...@uoguelph.ca<mailto:le...@uoguelph.ca>> wrote:

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@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Lelio Fulgenzi]

Omg. Thank you.


-Original Message-
From: NateCCIE [mailto:natec...@gmail.com] 
Sent: Friday, December 1, 2017 11:46 AM
To: Lelio Fulgenzi <le...@uoguelph.ca>; 'voyp list, cisco-voip' 
<cisco-voip@puck.nether.net>
Subject: RE: [cisco-voip] phone model and quantity report...

There is a report in cisco unified reporting, I think device counts summary.

-Original Message-
From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Lelio 
Fulgenzi
Sent: Wednesday, November 29, 2017 2:04 PM
To: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
<cisco-voip@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@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Brian Meade]

Under Unified Reporting in top right dropdown then run Device Count Summary.

On Wed, Nov 29, 2017 at 4:04 PM, Lelio Fulgenzi  wrote:

>
> 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@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[John Franklin]

You could get your desired output with a RUL SQL command

run sql select count(tkmodel),  typemodel.name from device  inner join 
typemodel on enum = tkmodel  where typemodel.tkclass = 1 group by tkmodel, 
typemodel.name order by typemodel.name


Regards,

John Franklin  
john.frank...@voipintegration.com<mailto:john.frank...@voipintegration.com>
VoIPIntegration | www.VoIPintegration.com<http://www.voipintegration.com/>
201K Sand Creek Road
Brentwood, CA, USA. 94513

From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Lelio 
Fulgenzi
Sent: Wednesday, November 29, 2017 1:04 PM
To: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
<cisco-voip@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@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[NateCCIE]

There is a report in cisco unified reporting, I think device counts summary.

-Original Message-
From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of
Lelio Fulgenzi
Sent: Wednesday, November 29, 2017 2:04 PM
To: voyp list, cisco-voip (cisco-voip@puck.nether.net)
<cisco-voip@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@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

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

[Lelio Fulgenzi]

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@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip