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

Current Users, Session Counts & Authentication Type Expand / Collapse
Author
Message
Posted Tuesday, May 18, 2010 4:03 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, November 14, 2012 12:39 PM
Points: 443, Visits: 130
Comments posted to this topic are about the item Current Users, Session Counts & Authentication Type

http://www.sdtslmn.com
Post #923951
Posted Tuesday, May 25, 2010 6:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 12, 2014 6:55 AM
Points: 2, Visits: 550
The nt_user_name also can be empty for 'SQL Authentication' .


SELECT 'Authentication Method'=(
CASE
WHEN nt_user_name IS not null And nt_user_name <> '' THEN 'Windows Authentication'
ELSE 'SQL Authentication'
END), nt_user_name,
login_name AS 'Login Name', ISNULL(nt_user_name,'-') AS 'Windows Login Name',
COUNT(session_id) AS 'Session Count'
FROM sys.dm_exec_sessions
GROUP BY login_name,nt_user_name
Post #927400
Posted Thursday, May 27, 2010 7:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 9:26 AM
Points: 1, Visits: 58
I don't understanda the date of the post (2010/06/17) !!!
Post #928967
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse