Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Query to locate Queue that the last call came from

Status
Not open for further replies.

Billz66

Technical User
Feb 21, 2010
2,094
AU
MIVB 8 , MICC 8.1.4 ( version not really applicable)

I am trying to create a half decent post call survey

I have menus With questions and emailed report when bad entry is entered
I am using Call Coverage Post call Destination to hunt group .
I can get ANI of caller , redirect number (agent extension)
I can do SQL query of ccmdata to obtain firstname lastname matching extension

select [FirstName],[Lastname] from [tblConfig_Employee] where [Reporting] ='@PostCallAgentExtension'

Does anyone know if its possible to obtain the Queue that this call was delivered from ?

is there a way to look up the details of the last call an agent received?
Just trying to add more value to the email

If I never did anything I'd never done before , I'd never do anything.....

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top