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

2017-12-01 Thread 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 
> 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*
> 
>
> *VoIP*Integration *| **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] UCCX adding ring before hold music

2017-12-01 Thread Anthony Holloway 
What you need to make a menu selection first in order to determine the
queue?

I would go with Brian's recommendation or alternatively don't hold the call
at all and just use the Play Prompt step to play an audio file which
contains a ringing sound in it.

On Fri, Dec 1, 2017 at 11:55 AM Carlo Calabrese via cisco-voip <
cisco-voip@puck.nether.net> wrote:

> Before you accept the call, Check to see if all agents are busy, if so,
> add a delay of 1 or 2 seconds before you accept the call.
>
>
> --
> *From:* ccie collan 
> *To:* cisco-voip@puck.nether.net
> *Sent:* Friday, December 1, 2017 8:29 AM
> *Subject:* [cisco-voip] UCCX adding ring before hold music
>
> Hello ,
>
> when all of the agents are busy on the calls, when calls come into UCCX
> customers here music on hold , can you please advise how i can rings before
> the call enters the hold cycle ?
>
> Thank you .
> ___
> 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
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] SIP Video Calls - CUCM or VCS

2017-12-01 Thread Brian Meade 
# is going to be the difficult character for CUCM probable.  VCS may be
able to handle that better.

On Wed, Nov 29, 2017 at 10:42 AM, Anderson D'Assunção <
anderdassun...@gmail.com> wrote:

> I know that CUCM can support 1.1.1.1@ip or 1*1*1*1, but
>
> Do the CUCM or VCS supports SIP Video calls dialing like this?
>
> 1.1.1.1##2562
> 1.1.1.1#1420
> 1916568@10.10.10.10
> 191.191.191.191@10.10.10.10
>
>
> Is there any way to solve this kind of dialing to policom equipments?
>
> i'm not able to make sip trunks because they are Polycom standalone.
>
>
>
> I just would like to confirm if it's possible or not
>
> thanks and regards
>
>
>
>
>
> ___
> 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] Outage tracking

2017-12-01 Thread Brian Meade 
There was a lot of discussion of it on the outages list-
https://puck.nether.net/mailman/listinfo/outages

On Fri, Dec 1, 2017 at 1:17 PM, Ben Amick  wrote:

> Do you guys have any good way to track provider outages? Our CenturyLink
> SIP circuit just got hit with what the provider describes as a “major
> system outage” and it’d be nice to have somewhere to get that information
> without waiting a half hour for the ticket update
>
> Ben Amick
> Telecom Support Analyst
>
>
>
> Confidentiality Note: This message is intended for use only by the
> individual or entity to which it is addressed and may contain information
> that is privileged, confidential, and exempt from disclosure under
> applicable law. If the reader of this message is not the intended recipient
> or the employee or agent responsible for delivering the message to the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited. If
> you have received this communication in error, please contact the sender
> immediately and destroy the material in its entirety, whether electronic or
> hard copy. Thank you
> ___
> 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] Outage tracking

2017-12-01 Thread Lelio Fulgenzi 
http://downdetector.com/status/centurylink

From: cisco-voip [mailto:cisco-voip-boun...@puck.nether.net] On Behalf Of Ben 
Amick
Sent: Friday, December 1, 2017 1:17 PM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] Outage tracking

Do you guys have any good way to track provider outages? Our CenturyLink SIP 
circuit just got hit with what the provider describes as a “major system 
outage” and it’d be nice to have somewhere to get that information without 
waiting a half hour for the ticket update
Ben Amick
Telecom Support Analyst


Confidentiality Note: This message is intended for use only by the individual 
or entity to which it is addressed and may contain information that is 
privileged, confidential, and exempt from disclosure under applicable law. If 
the reader of this message is not the intended recipient or the employee or 
agent responsible for delivering the message to the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you have received this communication 
in error, please contact the sender immediately and destroy the material in its 
entirety, whether electronic or hard copy. Thank you
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] Outage tracking

2017-12-01 Thread Ben Amick 
Do you guys have any good way to track provider outages? Our CenturyLink SIP 
circuit just got hit with what the provider describes as a “major system 
outage” and it’d be nice to have somewhere to get that information without 
waiting a half hour for the ticket update

Ben Amick
Telecom Support Analyst




Confidentiality Note: This message is intended for use only by the individual 
or entity to which it is addressed and may contain information that is 
privileged, confidential, and exempt from disclosure under applicable law. If 
the reader of this message is not the intended recipient or the employee or 
agent responsible for delivering the message to the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you have received this communication 
in error, please contact the sender immediately and destroy the material in its 
entirety, whether electronic or hard copy. Thank you___
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...

2017-12-01 Thread 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 
Cc: voyp list, cisco-voip (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 
> 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] UCCX adding ring before hold music

2017-12-01 Thread Carlo Calabrese via cisco-voip 
Before you accept the call, Check to see if all agents are busy, if so, add a 
delay of 1 or 2 seconds before you accept the call.

  From: ccie collan 
 To: cisco-voip@puck.nether.net 
 Sent: Friday, December 1, 2017 8:29 AM
 Subject: [cisco-voip] UCCX adding ring before hold music
   
Hello , 

when all of the agents are busy on the calls, when calls come into UCCX 
customers here music on hold , can you please advise how i can rings before the 
call enters the hold cycle ?

Thank you .
___
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] SIP Video Calls - CUCM or VCS

2017-12-01 Thread Matt Jacobson 
You can register your Polycom endpoints on the VCS with SIP or H323 with
whatever SIP URI or H323 ID of choice. Unless there are other requirements
you didn't mention, this should let you more easily connect calls to these
Polycoms by putting them on the VCS.

On Wed, Nov 29, 2017 at 9:42 AM, Anderson D'Assunção <
anderdassun...@gmail.com> wrote:

> I know that CUCM can support 1.1.1.1@ip or 1*1*1*1, but
>
> Do the CUCM or VCS supports SIP Video calls dialing like this?
>
> 1.1.1.1##2562
> 1.1.1.1#1420
> 1916568@10.10.10.10
> 191.191.191.191@10.10.10.10
>
>
> Is there any way to solve this kind of dialing to policom equipments?
>
> i'm not able to make sip trunks because they are Polycom standalone.
>
>
>
> I just would like to confirm if it's possible or not
>
> thanks and regards
>
>
>
>
>
> ___
> 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] UCCX adding ring before hold music

2017-12-01 Thread Brian Meade 
Change music on hold to a file that plays ringback.

On Wed, Nov 29, 2017 at 1:54 PM, ccie collan 
wrote:

> Hello ,
>
> when all of the agents are busy on the calls, when calls come into UCCX
> customers here music on hold , can you please advise how i can rings before
> the call enters the hold cycle ?
>
> Thank you .
>
> ___
> 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...

2017-12-01 Thread Lelio Fulgenzi 
Omg. Thank you.


-Original Message-
From: NateCCIE [mailto:natec...@gmail.com] 
Sent: Friday, December 1, 2017 11:46 AM
To: Lelio Fulgenzi ; 'voyp list, cisco-voip' 

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) 

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] test 1-2-3

2017-12-01 Thread Lelio Fulgenzi 
test
<>___
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...

2017-12-01 Thread 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...

2017-12-01 Thread 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
VoIPIntegration | 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) 

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...

2017-12-01 Thread 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)

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] UCCX adding ring before hold music

2017-12-01 Thread ccie collan 
Hello ,

when all of the agents are busy on the calls, when calls come into UCCX
customers here music on hold , can you please advise how i can rings before
the call enters the hold cycle ?

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

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

2017-12-01 Thread 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

[cisco-voip] SIP Video Calls - CUCM or VCS

2017-12-01 Thread Anderson D'Assunção 
I know that CUCM can support 1.1.1.1@ip or 1*1*1*1, but

Do the CUCM or VCS supports SIP Video calls dialing like this?

1.1.1.1##2562
1.1.1.1#1420
1916568@10.10.10.10
191.191.191.191@10.10.10.10


Is there any way to solve this kind of dialing to policom equipments?

i'm not able to make sip trunks because they are Polycom standalone.



I just would like to confirm if it's possible or not

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

[cisco-voip] moving/upgrading Expressway VMs

2017-12-01 Thread Lelio Fulgenzi 

I'm new to the Expressway world, so new, we had a partner come in and help us 
set them up. :O

We had a weird experience with the licensing with one host, which needed manual 
intervention, but for the most things went ok.

This raises the question, however, of how I can plan to move these VMs to 
another host, upgrade them, then move them again.

As far as I can tell, the serial number to which the license is tied is 
generated at installation time and is not changed when a VM is moved, but I'm 
not sure this holds when the expressway o/s is upgraded.

My goal is to upgrade the 4 vm cluster (2C+2E) offline then move them to the 
online network, rebalancing our ESXi hosts as we do this.

I understand that even if we are successful in moving the VMs without rehosting 
the license, if we ever encounter a situation where we need to recover from 
backup, we need to consider if this will fail because of the licenses or is 
there a way around that?

Thoughts?

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

[cisco-voip] Licensing - CUWL 9/10

2017-12-01 Thread Jon Fox 
Hi All 

Please can you assist. Cisco Licensing as always been a enigma to me.

A new customer has a  Unity Connection Version 9 and a CUCM Version 10.5 How 
does the CUWL Licensing work when you have different version applications. 

Say we needed x25 new CUWL Standard licenses for new users. 

Do we order version 10 or version 9 CUWL standard licensing.


Many thanks


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

Re: [cisco-voip] Cisco Voice Operating System-Based Products Unauthorized Access Vulnerability

2017-12-01 Thread Erick Bergquist 
Looking at doing the same, pushing the cop file.

"file search install system-history.log Upgrade"  will show just the
Upgrade entries. Can look to see if a nornal upgrade was done after a
refresh entry.


On Wed, Nov 22, 2017 at 8:08 AM, Brian Meade  wrote:
> We've got a team doing some scripting to check the system-history.log.  It
> looks like there is no harm to running the COP on a non-affected system as
> well so we may just push it in bulk.
>
> On Wed, Nov 22, 2017 at 9:01 AM, Ryan Ratliff (rratliff)
>  wrote:
>>
>> I’d rather you take the approach of telling all of your customers to
>> install the COP file rather than pen-testing on a live system :)
>>
>> If you want to see if they are exposed get the system-history.log and
>> install.log and upload them to a TAC SR or manually inspect them to
>> determine the timeline of install & upgrade types. All the info you need is
>> in the advisory.
>> PCD Migration -> exposed
>> RU Upgrade -> exposed
>> L2 Upgrade -> not exposed
>>
>> -Ryan
>>
>> On Nov 20, 2017, at 11:25 AM, Brian Meade  wrote:
>>
>> Anyone got some ideas on trying to crack this UCOS password?  Should help
>> us out in scanning our customers to see if they are affected, but we
>> wouldn't want this password to end up indexed by google and make the issue
>> even worse.
>>
>> On Fri, Nov 17, 2017 at 4:46 PM, Anthony Holloway
>>  wrote:
>>>
>>> Bwahaha! I just logged in to your CUCM Tim.
>>>
>>> On a serious note, I think it’s interesting how this “flag” issue is such
>>> a big deal, when back in the old days of UCCX, Cisco was creating an
>>> intentional back-door in all installs, using the same username and password
>>> on all of them.
>>>
>>> For the curious, it was :
>>>
>>> Username: CRSAdministrator
>>> Password: NwY.t9g(f'L9[3C
>>>
>>> If you have access to a UCCX 7x or lower, try logging in to Windows with
>>> that account and report back if it worked.
>>>
>>> If it does work, check the MADM logs on the C: for the clear text AXL
>>> username and password, so you can compromise CUCM too!
>>> On Fri, Nov 17, 2017 at 1:46 PM Tim Frazee  wrote:

 heads up


 https://tools.cisco.com/security/center/content/CiscoSecurityAdvisory/cisco-sa-20171115-vos


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