Current Users, Session Counts & Authentication Type

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by sedat salman » Current Users, Session Counts &...

Current Users, Session Counts & Authentication Type

Rate Topic

Display Mode

Topic Options

Author

Message

sedat salman

Posted Tuesday, May 18, 2010 4:03 PM

SSC-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

fausto-1057143

Posted Tuesday, May 25, 2010 6:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:51 AM
Points: 2, Visits: 321

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

Giorgio Conte

Posted Thursday, May 27, 2010 7:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 10:52 AM
Points: 1, Visits: 49

I don't understanda the date of the post (2010/06/17) !!!

Post #928967

« Prev Topic | Next Topic »

Permissions