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.
For perspective the host is a wireless access point with fixed clients. A
host that hasn't logged in somewhere else we can (somewhat) safely assume is
still pointed at the AP in question but is power off, or has its connection
interrupted for some other reason. If they have logged in somewhere else we
assume that the hardware was moved to a new location and installed there.
The query I came up with for some reason doesn't seem to correctly order the
dates so if they have logged into the host in question the information is
returned. This produces too many results as some of those users have since
migrated to a different access point.
From: Andrew Wallo [mailto:TheMechE@stripped]
Sent: Tuesday, February 10, 2009 12:05 PM
To: Ben Wiechman
Subject: Re: Query Help
Select login, SQL MAX(DateTime) from Log groupby Log.Login ( Gives you the
most recent login for a user - on any host. )
Select login, SQLMax(DateTime) from Log groupby Log.Login, Host ORDER BY
HOST ASC, DATETIME DESC
(Should give you the largest, i.e. most recent, date for each user on each
host, oganized by host, in descending login order..... I think... )
----- Original Message -----
From: "Ben Wiechman" <benw@stripped>
Sent: Tuesday, February 10, 2009 12:31 PM
Subject: Query Help
>I keep hacking at this but haven't been able to get it right yet.
> I have two tables
> Userinfo contains a login, User's Name, Group Name
> Log contains login, host, datetime of last login
> What I need to do is return user information (userinfo.name/groupname) of
> users that have logged into a particular host last. i.e. A user can log
> any of the hosts but I want to know which one they were on last. Each time
> they log the username, host and datetime of login are recorded in the log
> table. I've been able to return the last login to the host but I'm at a
> to get the list of all users that used the host last or all users that
> ever logged into that host.