getListOfAgents

Version 1
    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 = sn.name and
                     
    rg.profileid = r.profileid and
               
           (r.active = 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)?
     
    Thanks
    Sameer