cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
736
Views
0
Helpful
3
Comments
cdnadmin
Level 11
Level 11
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

dstaudt
Cisco Employee
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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Quick Links