determine last login of a user / easy for Gurus :-

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

determine last login of a user / easy for Gurus :-

Author

Topic

Juergen_G
Starting Member

12 Posts

Posted - 2007-04-18 : 05:47:11

Hi,

I have a logon-table with the fields
- "User ID"
- "Logon Date"

I need a list from all User-Id's with their last Logon Date.

It would be great if you can help me

Thanks in advance

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-18 : 05:48:49

[code]Select
[User Id],
max([Logon Date]) as [Logon Date]
from
logon
Group by [User Id][/code]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Juergen_G
Starting Member

12 Posts

Posted - 2007-04-18 : 05:56:11

Hi Harsh Athalye,
thank you for your fast answer - works great :-)

nice regards from Austria

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources