"Ben Wiechman" <[email protected]> wrote on 02/10/2009 01:30:14 PM:
> Thanks for the input! That is close to what I need, however not exactly.
It
> will give me the last time a user logged into the host in question but I
> want to prune users who have since logged into a different host.
Basically
> find out how many users are logged into a given host or who are not
> currently logged in but have not logged into a different host since they
> logged out of the target.
Figure out the last time each user logged in to any host:
SELECT login, MAX(datetime)as lastlogindate
FROM Log
GROUP BY login
So use that query as a derived table to get the rest of the info (untested
SQL):
SELECT Userinfo.Username, Userinfo.GroupName, Log.hostname, Log.datetime
FROM Userinfo
INNER JOIN
(SELECT login, MAX(datetime)as lastlogindate
FROM Log
GROUP BY login) AS lastlogin
ON Userinfo.login=lastlogin.login
INNER JOIN Log ON lastlogin.login=Log.login AND
lastlogin.lastlogindate=Log.datetime
Hope that helps.
Donna
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
