Phone number of the agent ?

[thierry.berwart_2]

Hi,

I need to know the phone number of the agent who accepts the call ?

In the select resource step, I can know the resource_id but I don't know what I can do with this id ?

Thanks you in advance,

Thierry

[yogeswar]

Hi,

If you need to get the agent extension of the selected resource, query the "Resource" table for the same. Check out the following database schemaa link...

Cisco Customer Response Applications Database Schema 3.1:

http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_1/english/admn_app/schema/index.htm

Query with ResourceLoginID and Active as "1".

Regards

Yogi

[thierry.berwart_2]

Hi Yogi,

I was looking in the database and I found the table resource in the db_cra database before you reply ;)

But Thanks you for the link because I didn't know the exact schema !

Best regards

Thierry