cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
907
Views
7
Helpful
8
Replies

Accessing Finesse User List API without Admin user

Hi,

 

I want to get the users list of finesse but I can not use the administrator credentials.

Is there a way to create an application user with roles similar to admin but only readonly and with less privileges?

 

API that I want to access: https://developer.cisco.com/docs/finesse/#!user%e2%80%94get-list/userget-list

1 Accepted Solution

Accepted Solutions

You can use a SQL query against the CCE AW database, usually ucce_awdb or <instance_name>_awdb.

Here is an example of a SQL query using the Agent_Real_Time table/view - which you would need to tweak just a bit, i.e. filter by AgentPeripheral ID (in the Persons Table), Username or SkillTargetID etc.

https://orourke.tv/web/doku.php?id=vendors:cisco:uc:icm:sql&s[]=sql#agent_real_time

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/icm_enterprise/icm_enterprise_12_5_1/reference/guide/ucce_b_125-database-schema-handbook-for/ucce_b_125-database-schema-handbook-for_chapter_010.html#UCCE_RF_ACF58810_00

Gerry

View solution in original post

8 Replies 8

realexan
Cisco Employee
Cisco Employee

Hi @deepaksharmainnovaccer,

The API mentioned is designed to be used only by an administrator. Currently, there aren't ways to create administrative users with read-only privileges too.

Regards,

Renjith

Hi @realexan,

Thanks for replying. 

 

Is there any other way I can get the user details from the phone's extension in UCCE?

for example, if I have 6001, I need to know which agent is logged in at that extension in real time.

You can use a SQL query against the CCE AW database, usually ucce_awdb or <instance_name>_awdb.

Here is an example of a SQL query using the Agent_Real_Time table/view - which you would need to tweak just a bit, i.e. filter by AgentPeripheral ID (in the Persons Table), Username or SkillTargetID etc.

https://orourke.tv/web/doku.php?id=vendors:cisco:uc:icm:sql&s[]=sql#agent_real_time

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/icm_enterprise/icm_enterprise_12_5_1/reference/guide/ucce_b_125-database-schema-handbook-for/ucce_b_125-database-schema-handbook-for_chapter_010.html#UCCE_RF_ACF58810_00

Gerry

Hi @Gerry O'Rourke ,

Thanks for suggesting this. I guess this would work. 
Can you please tell me if there's another table like this that holds real-time information on the calls waiting in the queues?

It would be really grateful.

There is real time for Call Waiting in Queues.

There are some very good default CUIC Live Data Reports which can enable on Finesse to show you this info.

There are also CUIC Real time reports.

Have a look at below.

The CUIC reports can be made to be displayed in Finesse as well.

You can also view the SQL behind these reports if you launch them from CUIC.

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/icm_enterprise/icm_enterprise_12_6_1/User/guide/ucce_b_cisco-unified-contact-center-enterprise-1261/ucce_b_cisco-unified-contact-center-enterprise-1261_chapter_01010.html

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/icm_enterprise/icm_enterprise_12_6_1/User/guide/ucce_b_cisco-unified-contact-center-enterprise-1261/ucce_b_cisco-unified-contact-center-enterprise-1261_chapter_01110.html

Gerry

jozefnad
Level 1
Level 1

You can also use ugly way if you do not want to make your own API with supervisor account and more API calls:

1. get teams > https://FQDN/finesse/api/Teams
2. for each team get users and merge to one object> https://FQDN/finesse/api/Team/<TeamId>

@jozefnad I can see only two teams' API in finesse: https://developer.cisco.com/docs/finesse/#!team-apis

and neither of them gets me the list of teams.
Can you please share a doc or link where I can get all the parameters, authorization, etc for teams API that you have mentioned?

If you are not able to access get teams ( https://FQDN/finesse/api/Teams ) with your supervisor account, you can get your teams by User api  ( https://FQDN/finesse/api/User/<userId> ) and then call all teams included in that account.
You can use basic auth if you have non SSO account. If you use SSO account, you need to get Bearer token for authorization. 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: