Lync User Last Login Time using SQL
In this Blog we will see Lync users last login time using Sql Query
SELECT u.UserUri
,us.[LastLogInTime]
FROM [LcsCDR].[dbo].[UserStatistics] us left join
[LcsCDR].[dbo].Users u on us.UserId = u.UserId
order by us.LastLogInTime desc
In this Blog we will see Lync users last login time using Sql Query
SELECT u.UserUri
,us.[LastLogInTime]
FROM [LcsCDR].[dbo].[UserStatistics] us left join
[LcsCDR].[dbo].Users u on us.UserId = u.UserId
order by us.LastLogInTime desc
good script ramesh.. its useful
ReplyDelete