06-10-2011 12:06 PM - last edited on 03-25-2019 07:17 PM by ciscomoderator
I have had good luck modifying most existing wallboard and or custom report to work with 8.x I am creating a select statement to return some needed agent data for a wallboard. To do this I am using the informix driver and the uccxhruser. I am able to retrieve data from the agentstatedetal and agentconnectiondetail tables. Unfortunately I am not able to retrieve data from the resource table. I believe I should have read access to this table with the uccxhruser correct? This is the error from my visual studio.
In order to make my statement work I need data from resourceid, resourcetype, resourcename, and assignedteamid. Is there another database user that would have read access to this table?
Thanks for any help you can provide.
06-13-2011 07:42 AM
I believe I figured out my issue, it seems that the uccxhruser does not have access to the "resource" table. I also have tried the uccxworkforce user but neither had access to that table. The main reason I need the resource table is to map the first and last name to the resourceid. I believe this is the only table where I can get this mapping.
Anyone have a better way to map the resource first and last name with the resourceid?
Thanks,
06-21-2011 11:16 AM
I'm real new to this but I was able to use the uccxhruser to access the resource table. I am using the IBM Informix Client-SDK 3.50. I have attached photos of the setup. Also I am using IBM Data Studio 2.2 Stand-alone (free) and this is also using the same uccxhruser. Hope this helps! I'm running UCCX version 8.0.2.
07-15-2011 10:42 AM
The uccxhruser has limited access to the tables in UCCX 8.0. The SU2 update gives the uccxhruser full read access to all the tables in db_cra and db_cra_replication
Regards
Graham
02-25-2022 02:29 AM
hruser for historical stats and wallboarduser for real time stats.
Resource, ACD, AgentStateDetail, ContactCallDetail - these are the tables from where you can consolidate almost all kind of statistics regarding Call, Agent, Skill Group.
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