This content has been marked as final.
Show 1 reply
-
1. Re: How to get session and most recent activity information from the database in V9?
Glauber Ribeiro Oct 21, 2015 12:11 PM (in response to Glauber Ribeiro)I'm getting closer... the only thing i still don't have is the IP address for the session
select b.user_ip, c.name, c.friendly_name, a.updated_at
from _sessions a
left outer join _http_requests b on b.session_id = a.session_id -- doesn't work
join _users c on c.id = a.user_id
order by a.updated_at descI left the _http_requests as an left outer join, because it doesn't work. If it were a join, the SQL would return nothing. As it is, the IP address is always null. In real life, i'd probably just get _http_requests out of the join.
I'm noticing that the admin views in V9 don't include the IP address, so maybe it's not possible to tell, in the current design. Which is a bummer, because it tells me where the user is coming from (internal in my company, or external).