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
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
Messages: 21131
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.
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:

Current Time: Thu Jul 27 17:55:49 CDT 2017

Total time taken to generate the page: 0.13771 seconds