Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auditing to fetch the details of lastlogin date of user in SQL server Expand / Collapse
Author
Message
Posted Wednesday, December 11, 2013 10:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 3:56 AM
Points: 14, Visits: 64
How to use auditing to get the lastlogin date of the user in SQL??
or is there any other way to fetch the result?
Post #1521971
Posted Thursday, December 12, 2013 4:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 15,558, Visits: 27,932
You can set up extended events to capture logins. That's the one sure way to get it. But if you haven't set that up, I'm not sure there is a way.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1522230
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse