EIM 4.3 - Route to Last Agent

[BarryMclellan72678_2]

Hello,

I have a requirement to have emails route to the last agent that worked on them. Using integrated EIM, I can't any way to do this.

On a previous Cisco TAC case, the engineer, mentioned something about Sticky Agents, but I couldn't find any documentation on this at all.

Has anyone here had to route to the last agent before? I do have the Data Adapter license, so was thinking of maybe some funky query in a work flow pass back to ICM the original agent ID?

Thanks for your help!

Barry

[geoff]

Barry,

I can certainly do the second part.

Create a Data Access Link and a Data Usage link and do the lookup in the worklfow (I guess the customer email address is the lookup key) and deposit the results of the query into the activity table, then pass this up to ICM in a call variable and use Queue to Agent to queue the activity. You can deal with the various options of no result, agent not logged in, queue for a while and overflow to the SG etc.

Now to the first part - how to write the agent into a database. You could get it by trolling the TCD in ICM - but you know how careful you need to be there. You could also get it in an ugly way - have a Link on the EIM desktop that writes to the database the email address and the agent peripheral number, but I think they may have to enter it.

Interesting idea. I'm willing to discuss this further.

Regards,

Geoff

[BarryMclellan72678_2]

Hmmm, I was thinking (no idea how yet), when an agent responds to an email, it must have their agent ID stored in one of the local EIM tables along with the case number. (I haven't found the EIM Database Schema documented)

Then, at the start of the workflow, check an EIM table for this case number. If the case number is found, return the last most recent Agent ID associated with that case and stuff it in a call variable.

When EIM routes up to IPCC, check and see if there is an agent ID in the call variable, and attempt to route to that agent, and keep the call queued with that agent for XXXX seconds before overflowing to an EIM queue.

What do you think?

Barry

[geoff]

Barry,

We are in agreement on part 2.

The schema for 4.3 is not published yet - I have requested it myself. But the 4.2 is published and worth checking out.

Since the PIM certainly passes down the agent ID in the DO_THIS_WITH_TASK event, it is most certainly in some EIM table, and I bet you can find it in the schema. It will be almost certainly matched on activity ID. I'm guessing you would have a few joins to do to get from the case ID to the previous agent, but maybe not.

Go to Cisco.com and download the schema doc.

If I get a little time this morning I'll have a quick look myself. It's interesting.

Regards,

Geoff

[BarryMclellan72678_2]

Well, I am getting close!

Have the cisco agent ID being passed back to a mapped call var in IPCC. Now just have to queue to the agent ID, and see how that affects reporting!

Let me know how you made out, if you are still interested, I can post what I have done so far.

Barry

[geoff]

Barry,

What does it look like? Is it a number like 5001, 5002 etc (primary key SkillTargetID in the Agent table) or is it the agent's Peripheral Number? If it came down from ICM in the DO_THIS_WITH_TASK it will be the SkillTargetID.

For Queue to Agent implicit you need the Peripheral Number.

Regards,

Geoff

[BarryMclellan72678_2]

Hey Geoff!

I wrote a nested SQL query so that I could get the case ID, and the last user who worked on it. I then take the user who worked on it (which is an EIM index), and hit the EIM agent table to get the login name.

Since I am using integrated the login name is prefilled which matches my IPCC agent login id exactly, I can send this data back in my call variables, and use the queue to agent node.

Barry

[geoff]

Since I am using integrated the login name is prefilled which matches my IPCC agent login id exactly, I can send this data back in my call variables, and use the queue to agent node.

Barry, as long as you send up the agent's peripheral number (what they would use to log in to CTIOS) you will be able to use the Queue to Agent in implicit mode. The name will not work - but that is what you select in explicit mode in a Queue to Agent node.

Regards,

Geoff

[BarryMclellan72678_2]

Yup, sending up the agent login number (same that they use for CTIOS).

So far it is working great, now on to yet another work flow that isn't in the product that should be!

[geoff]

Can I see your SQL query?

Regards,

Geoff

[BarryMclellan72678_2]

Sure, here is the query for my data access link.

My Data Usage Link passes in the case_id macro.

select USER_NAME
from egpl_user
where egpl_user.user_id IN
(
   select case when egpl_casemgmt_case.user_last_worked IS NOT NULL then
           egpl_casemgmt_case.user_last_worked
      else
            0
      end as New_Owner

   from egpl_casemgmt_case,
           egpl_casemgmt_customer
          where egpl_casemgmt_case.customer_id = egpl_casemgmt_customer.customer_id and
                    egpl_casemgmt_case.case_id = <%case_id%>
)

There is obviously a bit to setup in your workflow, data access links, adding new field to activity table, and all that good stuff. If you need more info, let me know.

Barry

[kimv]

Hi Barry,

It isn't actually called "Sticky Agent", its called "Preferred Agent".

The way you do it is to put a User node within the Inbound Workflow which has several options and is placed at the end of a workflow.  Of course the agent that is the Preferred (sticky) agent needs to be currently logged in.  Truthfully I haven't played around with it in my lab, but you can find it in the following document.

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/cisco_interaction_manager/cim_43/user/guide/cisco_im431_cce_userguide_administration_workflow.pdf

Hope this helps.

Kim

[geoff]

That's completely different to Barry's implementation.

That only works with non-integrated agents, and who wants those? Not me - and not Barry.

Regards,

Geoff

[kimv]

Kim Vogler

Customer Support Specialist IV

Unified Contact Center Products

kimv@cisco.com

Phone: +1 978 936 3356

Cisco Systems, Inc.

1414 Massachusetts Ave

Boxborough, MA. 01719

Cisco.com - http://www.cisco.com

Please note that my regular business hours are 8:00am to 5:00pm EDT. // If

you are contacting me in regards to a Service Request that we are working

together, and I am unavailable, please refrain from requeuing unless there

is an urgent need to speak to an engineer. If however you do need to work

with a TAC engineer urgently while I am unavailable, you may requeue this

Service Request to an available engineer by either calling the 800.553.2447

TAC Toll Free number or writing the tac@cisco.com address and requesting it.

This email may contain confidential and privileged material for the sole use

of the intended recipient. Any review, use, distribution or disclosure by

others is strictly prohibited. If you are not the intended recipient (or

authorized to receive for the recipient), please contact the sender by reply

email and delete all copies of this message.

For corporate legal information go to:

http://www.cisco.com/web/about/doing_business/legal/cri/index.html

[BarryMclellan72678_2]

Thanks for the attempt Kim, nice to know you guys are monitoring these thread's as well!

I'm sure by version 6, this should be all integreated

Barry