Hi
From CLI:
run sql select dd.name as device,pd.name as loggedinudp,ce.userid as currentuser,le.userid as lastuser from extensionmobilitydynamic emd left join device dd on emd.fkdevice = dd.pkid left join device pd on emd.fkdevice_currentloginprofile = pd.pkid left join enduser le on emd.fkenduser_lastlogin = le.pkid left join enduser ce on emd.fkenduser = ce.pkid
Log the output to a text file using putty or whatever, then read it with Excel as a fixed column width file.
Be aware that this isn't a 'historical' table - it shows the last logged in user, and the current logged in user. That's alll...
Regards
Please rate helpful posts...
Aaron
Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
