473,394 Members | 1,889 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Users last logon

2
Can any one tell me if SQL stores the last logon dat for a user and where. I would like to pull reports re users last logings to the server and then database.
Nov 9 '07 #1
1 2417
iburyak
1,017 Expert 512MB
I don't think there is a system table that holds this information.
You can get current login users but not the once who logged off.

Try:
Expand|Select|Wrap|Line Numbers
  1. sp_who
I think it can be maintained by code and update some table with users login information. In my system I keep someting like this but with programming involved.

Good Luck.
Nov 9 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Josh Armstrong | last post by:
I would like to setup a form that will log the users logging in to a db. The form and the Db will currently log the users if they complete the logon and get in. It will then log the entry, but...
2
by: Raimund Taschler | last post by:
Hi all, I'm implementing a windows service (running with local system account) which has to do some tasks when users logon/logoff. How can the service register to those logon/logoff-events? I'm...
6
by: google | last post by:
I have a few general questions. I am working on a new database to be used within my company. I would like to give a couple of people, particularly HR, the ability to add and delete Access users,...
12
by: (PeteCresswell) | last post by:
Does his sound legal? Somebody brought it up as an alternative to creating my temp DB under Documents and Settings\User Name. Sure seems simpler - conceptually identical to using C:\Temp in...
12
by: chris.thomson | last post by:
Hi, Thanks in advance for any assistance regarding my question. I have setup a database with a WIF containing the usernames and p/words of several unique data entry operators who will be...
5
by: Mike P | last post by:
I am trying to get at different users inboxes programmatically (see code below). It works fine, except for the fact that the logon line seems to always logon to my local account rather than...
2
by: =?Utf-8?B?SVNE?= | last post by:
Question: How do I refresh on the local computer the users AD( LDAP ) credentials without having them re-log our re-boot their system? Scenario: Users A is denied access to folder Z. Admin on...
2
by: rick | last post by:
Hi friends What is the best way to keep track of number of users logged into database everyday. Where does db2 store user connection information ? does it keep a log of user connections? ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.