UCCX 8 Wallboard Queries and Permissions

Unanswered Question
May 28th, 2010

Hi

Not sure if anyone is activly using UCCX 8 yet but i have a question.

When trying to access the AgentStateDetail and Resource tables all i get is a permissions error. This is using the uccxwallboard user.

You can still access the RT tables as before with no issues.

I am guessing cisco have limited this and i need to know how to add select permisions on all tables for the uccxwallboard user.

Is this possible?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Average Rating: 4.6 (5 ratings)
Anthony Holloway Wed, 06/02/2010 - 15:02

The only way you had access to those tables pre-8.0 is that you (or someone else) manually change SQL permissions, which is not supported.  Given that 8.0 is on linux/informix, this is no longer possible to do, and therefore you lost access to these tables.

Here is one way of changing access for a user in 7.0 and lower, for the curious:

osql -E -S IPCCSRV\CRSSQL -Q "USE db_cra EXEC sp_addrolemember 'db_datareader', 'IPCCSRV\CiscoWbUsr'"

Replace you server name and user account as required.

Also, your UCCX questions will gain more visibility in the Contact Center forum:

https://supportforums.cisco.com/community/netpro/collaboration-voice-video/contact-center?view=discussions

jeroen1964 Fri, 07/02/2010 - 02:40

When you user the uccxhruser account as specified in the historical reporting guide you gain access to the other t

ables you need...procedure as below.... good luck !

 

 

 

1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Select the Connection tab. In the sever name field, enter the instance name of Informix server of the set up. The instance name is ‘the host name of UCCX ‘ + ‘underscore’ + ‘uccx’. For example, if the host name of UCCX server is ‘Uccx_n1’ then the IDS instance name will be ‘Uccx_n1_uccx’. In the host name field, enter either host name or IP address of UCCX server. In service field, enter 1504 which is the TCP port number. In the ‘Protocol’ field, choose ‘onsoctcp’. In the database field, enter ‘db_cra’ which is the database name that stores historical data. In the userId field, enter ‘uccxhruser’ which is the default Historical Reporting user. The password for this user can be set at ‘Password Management’ page of the Unified CCX Administration web interface. The password 4-3 Cisco Unified Contact Center Express Historical Reporting Administrator and Developer Guide, Release 8.0(1) Chapter 4 Creating Custom Historical Reports for Cisco Unified CCX Creating a Report

 

 

 

management page appears under ‘tools’ menu of appadmin. In the password field of ODBC Driver set up page, enter the password which is set at ‘Password management page’ by administrator. Click

Apply & Test connection.

Select the Environment tab. Select the Use Server Database locale check box. Ensure that the entry for Fetch Buffer size field is 32767. If default entry is other than 32767, then manually change it to 32767. Click Apply.
The ODBC Driver Setup window is displayed. Enter a unique DSN name. Enter a suitable description. Click Apply.
The Create New Data Source window is displayed. From the list of available data sources, select IBM INFORMIX ODBC DRIVER. Click Finish.
Click on Add to create a new dsn.
Select the System DSN tab. ODBC Data Source Administrator window is displayed.
Go to Control Panel > Administrative Tools > Data Sources.

Step 8

Ensure that the Test Connection was successful message is displayed. You can view the newly created DSN in the list of DSNs. Close the window.

lohjintiam Thu, 07/22/2010 - 11:33

Hi,

Is there a way to find out which tables are still accessible for queries and which are not (need extra permission which is no longer allowed in v8)?

Thanks!

-JT-

madarasz@tcc.hu Thu, 09/23/2010 - 07:10

Hi JT,

I hope this sheet bellow will help you:

db_cra table

Selectable

agentconnectiondetail

ok

agentroutingsetting

agentstatedetail

ok

application

ok

areacode

ok

campaign

ok

campaigncsqmap

ok

configlog

configschema

configschemacolumn

configseed

contactcalldetail

ok

contactqueuedetail

ok

contactroutingdetail

ok

contactservicequeue

ok

crapublicationarticles

crareplicationretentionping

crareplicationstate

crsapplication

crsgroup

crsproperties

crstrigger

crsuser

currentactiveprofile

dbinfo

debugflag

ok

dialinglist

ok

dtproperties

eemactiveemail

ok

eemcontactemaildetail

ok

eememailagentstatedetail

ok

eememailstatusdescription

ok

eemqueueagentdetail

ok

eemqueueemaildetail

eemreasoncodedescription

ok

eemstatedescription

ok

eemtablesversion

ok

enginestatus

historicalusers

latestsynchedtime

migrationinfo

migrationstatusdetail

monitoredresourcedetail

ok

nextcsqid

nextcsqrecordid

nextresourcegroupid

nextresourceid

nextresourceskillmapid

nextrmonuserid

nextskillgroupid

nextskillid

nextsupervisorid

nextteamcsqmapid

nextteamid

productinfo

profileidmapping

purgeconfig

remotemonitoringdetail

ok

resource

ok

resourcegroup

ok

resourceskillmapping

ok

rmoncsqconfig

rmonresconfig

rmonuser

ok

rtcsqssummary

ok

rticdstatistics

ok

skill

ok

skillgroup

ok

spokenname

sqllogging

supervisor

ok

systemconfig

systemconfigcolumn

team

ok

teamcsqmapping

workflowtask

ausjustin Thu, 09/30/2010 - 00:59

looks great ...

but how can you selected the table from db_cra ????

as this is uccx8 not 7 . and for uccx7 you select all of the table from sql .. so how can can you do that on UCCx8 ?

thanks

madarasz@tcc.hu Thu, 09/30/2010 - 05:11

Unfortunately there is no such builtin possibility to browse the tables like with MSSQL Enterprise Manager or Query Browser was comming with MSSQL Enterprise that was comming with a Premium licensed UCCX 7.x or prior. Morover, the programatical access trough ODBC from a windows host was given as the  Windows operating system comes with MSSQL odbc driver by default.

In case of UCCX 8 the used db system is Informix.

If you want to access it you have to install the proper driver on the accessing PC.

You can download it from here an AP for the proper operating system:

http://www14.software.ibm.com/webapp/download/search.jsp?rs=ifxdl

The package contains ODBC driver for informix, and c++ library for native access as I remember. The package is free.

Unfortunately the JDBC driver for informix is not free.

You can setup an ODBC connection for example, and trough that you can query the table from your application.

If you just want to browse the tables, there are a bunch of sql tools on the market supporting informix. I am sure you can find the proper one.

Hope this helps you.

Lorant

chrismanuh Fri, 10/08/2010 - 12:51

I've used AGS Server studio to connect to informix: http://www.serverstudio.com/  You can use it to view the permissions on each object and also create stored procedures and other database objects.  This has a 30day limit.

Another option is IBM Data Studio which is based on eclipse and it's free.  This too will let you connect and manage the informix database: http://www.ibm.com/developerworks/downloads/im/data/

dynacare1 Thu, 05/05/2011 - 14:23

Hello,

First thanks a lot for the post and instructions. I spend few hours but I am able to make the connection.

Now the problem I am having is refreshing the page. I have set "RefreshTime = 10" and in "Real Time Snapshot Writing Configuration for Wallboard" its set to 10 seconds.

First time the page shows fine but then after 10 seconds I get

The page cannot be found

The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Please try the following:

  • If you typed the page address in the Address bar, make sure that it is spelled correctly.
  • Open the                 192.168.13.238 home page, and then look for links to the information you want.
  • Click the Back button to try another link.

HTTP 404 - File not found
Internet Information Services

Technical Information (for support personnel)

We have UCCX 8.0.2 and I used IBM Informix in ODS System DSN.

Thanks for the help.

ausjustin Thu, 09/01/2011 - 06:15

Hi Dynacare1

I had same issue cannot get agent table display ..

so can you share your agent .asp file to me ?

Thanks

dynacare1 Fri, 05/06/2011 - 09:54

Got it working now, I had wrong data source for Agent and ICD stats.

Thanks for the post.

nkobayashi123 Wed, 05/11/2011 - 13:24

Hi  dynacare1,

I just found your message that  your wallboard is working with UCCX 8 server.   I have UCCX8.02 and try to use Symon board.   We can get connection between UCCX8 and Symon board but we received "The parameter is incorrect" and "Login failed. Catalog information cannot be retrieved" error message.

Can you advise what we can do to Symon board to be working?  We use uccxwallboard as the user ID.... 

Thank you,

Nana

kiarash.kazemi Thu, 09/01/2011 - 02:56

Hi all,

My customer is using UCCX 8.5.1 in HA>

We are trying to map reason codes to reason code descriptions to display them on a Wallboard and we are looking in the table:

eemreasoncodedescription

We have managed to connect to the database to get reporting statsistics. However whenever we run the following query, we get 0 results back:

Select * from EEMReasonCodeDescription

The user we are using is: uccxhruser  as per the “Cisco Unified Contact Center Express 8.5(1) Historical Reporting Administrator and Developer Guide"

However when I look at the "Cisco Unified CCX Administration Guide, Release 8.5(1)", this guide mentions that we should be using uccxwallboard on page 491.

My question is has anyone used either of these users to successfully retrieve data from a UCCX 8.0 or 8.5? If so which user did you use and was there anything else required to gain access to the eemreasoncodedescription table?

Any assistance with this would be greatly appreciated.

Thanks,

Kiarash

.

jeroen1964 Thu, 09/01/2011 - 03:03

Kiarash, The EEM part of the table refers to the optional email tables and is not the table used for the reasoncodes…..

Jeroen

marks@lynxtec.com Thu, 09/01/2011 - 03:03

Hi

You need to use the user UCCXHRUSER and this will allow access to the stats you need.

Cisco do not promote the use of this user as it is also used for the HR tool

You will need to change the HR user password on both nodes as you did for the wallboard user.

Mark

kiarash.kazemi Thu, 09/01/2011 - 03:25

Thanks Mark -We are using the UCCXHRUSER and have established a connection. We get stats about the CSQ etc.

@Jeroen - Do you know what is the correct table if this not the correct one to get the Reason code to Reason code description?

Cisco's schema definition below for EEMReasonCodeDescription is very misleading:

EEMReasonCodeDescription: The EEMReasonCodeDescription table contains descriptive text (in English only) for each possible reason code.

This thread seemed to indicate that this was the correct table but no one seems to have got it to work:

https://supportforums.cisco.com/message/1052884#1052884

Many thanks,

Kiarash

Aaron Harrison Thu, 09/01/2011 - 04:17

Hi

There is no table in the DB with reason code descriptions. The reason codes are stored only as ints.

When I've worked with reports etc that use these codes, I've had to map them to static strings in whatever app I'm querying the DB with (e.g. wallboard, crystal etc). It's not ideal, but changing reason codes is generally not done frequently.

'EEM' is the clue in that table name, it refers to the email subsystem.

Regards

Aaron

Please rate helpful posts...

jeroen1964 Thu, 09/01/2011 - 04:25

That’s right Aaron, in the older versions there was. The reasoncode numbers can be found in the CAD admin tool. The standard reason codes are explained in the historical reports user guide (search for uccx85hrug)

Jeroen

kiarash.kazemi Thu, 09/01/2011 - 06:40

Thanks so much for your help gents.  I can't see how Cisco can take functionality away and provide no new method attaining this information.

There must be a way of attaining the mapping between the Reason Code and the Definition as CAD does it in Desktop Admin. Has anyone actually asked Cisco directly with regards to this?

jeroen1964 Thu, 09/01/2011 - 07:40

I just tried with my lab setup, and the table stays empty. I have never asked Cisco as to why they choose not to use this table at all, or in which case this table does get filled…..

Jeroen

Aaron Harrison Thu, 09/01/2011 - 08:07

Hi

Me neither - since the functionality doesn't exist now, I'm sure TAC would say it was 'working as designed' and we should submit a feature request/usage case etc. I've never needed it enough to go through such pain.

CAD does it easy enough, as the DB that CAD and the other desktop apps connects to is (I believe) the LDAP db that the Calabrio half of the system uses. That's where the codes are stored, and it's not easy to get at the information programatically.

Aaron

kiarash.kazemi Thu, 09/01/2011 - 08:08

Thanks Jeroen,

I have put a question into a friend at Calabrio. If I don't get a response I will escalate this to TAC to pose the question and will update this thread with what they say.

Regards,

Kiarash

Actions

Login or Register to take actions

This Discussion

Posted May 28, 2010 at 6:20 AM
Stats:
Replies:22 Avg. Rating:4.6
Views:21905 Votes:0
Shares:0

Related Content

Discussions Leaderboard