Home » RDBMS Server » Performance Tuning » users not logged on last 30 days
users not logged on last 30 days [message #216086] Wed, 24 January 2007 23:27 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear all,
I want to determine the users not logon for the last 30 days
can anybody help me in this regard?

thanx in advance

Report message to a moderator

Re: users not logged on last 30 days [message #216094 is a reply to message #216086] Thu, 25 January 2007 00:21 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think that you won't be able to collect such an information unless auditing has been enabled, or you have created a database (ON LOGON DATABASE) trigger which inserts records into a table you have created for such a purpose.

Report message to a moderator

Previous Topic: Append hint, Truncate, Global Temp Table
Next Topic: Industry standard best practice for Primary keys..should they be meaningful or meaningless?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 10:38:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.