User logs

Hi Thriveni, you can check K2 Management site -> Licenses for a list of all users that have logged into K2, and their last accessed date+time.

You can access this data by executing this SQL script and maybe building a Stored Procedure around it and generate a SmartObject from that:

DECLARE @ActiveOnly BIT
SET @ActiveOnly = 1

SELECT scc.[CredentialID]
,scc.[PrimaryCredential]
,scc.[IsPrimary]
,scc.[SecurityLabelID]
,COALESCE(id.[DisplayName], sl.[SecurityLabelName] + N':' + scc.[UserName]) AS [UserName]
,scc.[ExtraData]
,scc.[AllowCaching]
,scc.[PasswordCached]
,scc.[CreationDate]
,scc.[CustomUserID]
,scc.[IsActiveUser]
,scc.[LastAccessDateUtc]
,sl.[SecurityLabelName]
FROM [HostServer].[SecurityCredentialCache] AS scc
INNER JOIN [HostServer].[SecurityLabel] AS sl ON sl.[SecurityLabelID] = scc.[SecurityLabelID]
LEFT JOIN [Identity].[Identity] AS id ON id.[FQN] = sl.[SecurityLabelName] + N':' + scc.[UserName]
WHERE [IsPrimary] = 1 AND (@ActiveOnly = 0 OR [IsActiveUser] = 1)

ORDER BY [CredentialID] ASC;