EMCC Remotely Logged In User ID

[cdnadmin]

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

[Eike Scholz-Janotte]

anyone found a solution for this?

We are actually faced wih the exact same problem.

Eike

[dstaudt]

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

[Eike Scholz-Janotte]

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