06-04-2018 01:53 PM - edited 03-14-2019 06:13 PM
Hello Experts,
Is there any kind of reports/tool that we can use to see Call Control Groups (CCG) associated with uccx applications? We would like to know how many applications are associated with a given CCG.
A SQL query displaying this info would be very interesting option.
Thanks,
MK
Solved! Go to Solution.
06-05-2018 12:09 PM - edited 11-08-2019 02:22 PM
I don't think there's a report and the SQL is stored in a binary format, so it's kind of hard to read. Here is a PowerShell script which prints the Trigger Number and the CCG using the Admin API.
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 $Cred = Get-Credential $Url = "https://uccxpub.company.com/adminapi/trigger" $resp = Invoke-RestMethod -Uri $url -Credential $Cred $resp.triggers.trigger | Format-Table -AutoSize -Property directoryNumber, @{ Name = 'callControlGroup'; Expression = {$_.callControlGroup.name}}
Sample Output
directoryNumber callControlGroup --------------- ---------------- +16125551212 0 +16125551313 0 +16125551414 1
Note: You must be able to trust the server's certificate, and be running PowerShell v3+ for this to work.
EDIT: Added a new line in the in powershell script to support TLSv1.2
06-15-2018 07:47 AM
06-05-2018 12:09 PM - edited 11-08-2019 02:22 PM
I don't think there's a report and the SQL is stored in a binary format, so it's kind of hard to read. Here is a PowerShell script which prints the Trigger Number and the CCG using the Admin API.
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 $Cred = Get-Credential $Url = "https://uccxpub.company.com/adminapi/trigger" $resp = Invoke-RestMethod -Uri $url -Credential $Cred $resp.triggers.trigger | Format-Table -AutoSize -Property directoryNumber, @{ Name = 'callControlGroup'; Expression = {$_.callControlGroup.name}}
Sample Output
directoryNumber callControlGroup --------------- ---------------- +16125551212 0 +16125551313 0 +16125551414 1
Note: You must be able to trust the server's certificate, and be running PowerShell v3+ for this to work.
EDIT: Added a new line in the in powershell script to support TLSv1.2
06-05-2018 08:58 PM
Hello Anthony,
Thank you for taking the time and replying.
When I copy your script into the PowerShell, a credential window gets displayed which asks for the username and password. What kind of credentioal does this window require? Is it the UCCX admin username and password? I tried the admin credential as well as the one for Windows but none of them worked.
Please see the attached screenshot.
Thanks,
Mk
06-07-2018 08:29 AM
Hi Anthony,
Did you get the chance and see why the authentication with PowerShell fails?
Thanks,
MK
06-07-2018 08:40 AM
No worries Anthony, it worked!
Thanks,
MK
06-07-2018 08:46 AM
Sorry I was late to reply, but I'm happy you got it working. Yes, it is the UCCX Admin username and password (any admin account on UCCX will do). What ended up being your issue, and how did you resolve it?
06-07-2018 08:56 AM
I was using an old PW which is no longer valid.
Thanks again,
MK
06-07-2018 09:29 AM
06-14-2018 01:04 AM
URL which U mentioned, it be UCCX IP?
06-14-2018 07:22 AM
Yes, it's the IP of UCCX.
Thanks,
MK
06-15-2018 12:02 AM
Looks Good....Thanks
06-15-2018 07:47 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide