EMCC Remotely Logged In User ID

Version 1
    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!