When running the Cisoc Agent Detail Report I am seeing the following SQL commented out:
INSERT #selected_agents(agentID, profileid)
SELECT DISTINCT r.resourceID, r.profileid
FROM db_cra.dbo.ResourceGroup rg, db_cra.dbo.Resource r, #selected_names sn
WHERE rg.resourceGroupID = r.resourceGroupID AND
rg.resourceGroupName = sn.name and
rg.profileid = r.profileid and
(r.active = 1 or
r.dateinactive >= @starttime)
which is making it difficult to report by Resource Group. My question is has anyone run into the root cause that this has been commented out? My concern is that it was commented out becuase it caused some undesirable outcome. Thank you in advance.
My version of UCCX Historical Reports is 7.0(1.9). I wouldn't think that there would be that much of a difference between the two. Deconstructing the stored procedure that the XML file uses I get the following:
This populates a couple temporary tables that are used to get your results and return them so the crystal reports templates can give you a report. How did you get to the point that you were looking at the getListofAgents stored procedure?
which then calls getListOfAgents which takes in the resourcegroup passed and does parse2 [ so far so good ].
* Parse2 in turn calls ParSeString which inserts the each token ( rather resource name ) in a temporary table selected_names
Then irrespective of the resourcegroup passed, it does select on resource table to get a list of agents and inserts into the temp table #selected_agents.
So both temporary table selected_names and selected_agents are now populated.
Back @ sp_agent_call_summary immediately following exec of getListOfAgents, it does not touch selected_names again, selected_agents is touched only for joins with other tables in my version. I would think that even for most sloppiest code, selected_names would be used to delete agents from "selected_agents" who do not belong to any resourcegroup in the selected_names table before using it for joins.
In some of the other reports I see how parse2 and selected_names and selected_agents is used to get the right list of agents, however not on this one.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...