Is it possible...

Question

Post reply

Is it possible...

krypto69

SSChampion

Points: 13604
More actions
March 12, 2010 at 1:58 pm

#138636

Is it possible to see when my user accounts were last used?

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

How do you have login auditing configured? By default it only catches failed logins.. What traces do you have running?

CEWII

Johan Bijnens SSC Guru Points: 135373 More actions · Answer 2

LOGINPROPERTY doesn't show that (bol ref http://msdn.microsoft.com/en-us/library/ms345412.aspx)

Off course you can enable login recording to sqlservers errorlog file, but you'll have to process that yourself and off cours, depending on the number of login actions, that may cause this errorlog file go grow ...

However, you could subscribe to sqlserver login events and keep track of it yourself.

cfr http://www.sqlservercentral.com/articles/Administration/64974/

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 3

I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

One option would be to enable a logon trigger and capture the logon information out to a table with a datestamp.

.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

homebrew01 SSC Guru Points: 55548 More actions · Answer 5

Steve Jones - Editor (3/12/2010)
I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.

And hope it's not your boss, or your boss's boss !

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 6

Steve Jones - Editor (3/12/2010)
I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.

Heh... disable the logins and let them complain... individual users shouldn't have access to the production system.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Jeff Moden (3/12/2010)
Steve Jones - Editor (3/12/2010)
I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.
Heh... disable the logins and let them complain... individual users shouldn't have access to the production system.

Besides you have to do something to remind people that you are there keeping their systems running. They tend to forget unless something goes wrong.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 8

Put out a general note, we are auditing access, etc. If your login doesn't work, let us know. It's an easy way to find out who is using systems, and the disable will allow you to retain permissions. It's seconds to reactivate someone's account.

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 9

Steve Jones - Editor (3/14/2010)
Put out a general note, we are auditing access, etc. If your login doesn't work, let us know. It's an easy way to find out who is using systems, and the disable will allow you to retain permissions. It's seconds to reactivate someone's account.

Heh... I thought that was monthly maintenance... disable all logins... re-enable only if they email you twice in the same day or they call once. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eoin The Forge SSCrazy Points: 2932 More actions · Answer 10

That's what's known in the business as a "Scream Test"

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 11

Eoin (3/15/2010)
That's what's known in the business as a "Scream Test"

Heh... I didn't have a name for it but that'll do perfectly. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eoin The Forge SSCrazy Points: 2932 More actions · Answer 12

Jeff Moden (3/15/2010)
Eoin (3/15/2010)
That's what's known in the business as a "Scream Test"
Heh... I didn't have a name for it but that'll do perfectly. 🙂

Glad to be of assistance:-D

John McC Hall of Fame Points: 3410 More actions · Answer 13

What logins?

It's my data, mine all mine do you hear! 😀

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:

robert.mcleod SSChasing Mays Points: 618 More actions · Answer 14

I read the error log into a temp table and get my information from there.