cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

EMCC Remotely Logged In User ID

311
Views
0
Helpful
3
Comments
This document was generated from CDN thread

Created by: JAMES DEPHILLIP II on 28-12-2012 11:16:27 PM
Anyone have a good SQL query to determine the remotely logged in user to an EMCC profile based on the Device MAC? I see how the fkdevice field of emccdynamic points to the pkid for the emcc profile but how can I find the user of that profile? If you know a query that I could run that would be great!
 
Thanks,
Jim
Comments

anyone found a solution for this?

We are actually faced wih the exact same problem.

Eike

Cisco Employee

I don't have an EMCC setup handy to test, but I would assume there is a record in the table 'enduserdevicemap' which connects the device from emccdynamic::fkdevice to the 'enduser' table

Hi David,

thanks for your answer. Unfortunately there is no mapping.

In emccdynamic we have a fkdevice which does not exist in the enduserdevicemap. This probably related to the temporary phone from the visiting cluster which does not really exist on the homecluster.

What we are looking for is a way to get the loggedin user (or user profile) from the device MAC. Since the MAC is a phone from the other cluster we run into the problem that the device MAC does not really exist in the DB except in the emccdynamic table.

We have a LAB deployed here with EMCC if you need something.

Eike

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here