Document created by cdnadmin on Jan 24, 2014
Version 1Show Document
  • View in full screen mode
This document was generated from CDN thread

Created by: sameer danthurthy on 05-01-2010 05:19:08 PM
Hello, while reviewing the Uccx historical reporting, I found out that we weren't able to run reports with afilter criteria of a given resource name,. On further investigation, I found out that db_cra.dbo.getListOgAgents has the 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 = and
rg.profileid = r.profileid and
       ( = 1 or
r.dateinactive >= @starttime)

Now I am not sure why this would be commented out, could anyone please verify how this should be in a default installation of Cisco Unified CCX Historical Reports Version 7.0 (1.44)?