bluebunny72 icon

Current Users List

bluebunny72 | PRO | 04/29/15 08:52:32 PM UTC | 0 ⭐ | 583 👁️ | Never ⏰ | []
T-SQL |

460 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
SELECT ci.UserName
,ISNULL(un.UserDesc,'') AS UserDesc
,'YOURDB'       AS Configuration
,ci.CreateDate AS CreateDate
,SUBSTRING(ci.CreationContext, CHARINDEX('ClientHost=',ci.CreationContext)+11 , CHARINDEX(';',ci.CreationContext,CHARINDEX('ClientHost=',ci.CreationContext)+11) - (CHARINDEX('ClientHost=',ci.CreationContext)+11)) AS ComputerName 
FROM        [YOURDB].dbo.connectioninformation ci
JOIN        UserNames un
ON          un.UserName     = ci.UserName
WHERE ci.SessionType = 1

Comments