what is this? .vbs, powershell, C++
can't run it from command prompt nor from powershell nor from cscript
how to list skype accounts with the lastlogon time in front end skype server 2015 ?
In order to retire Sfb 2015 (OnPrem), I wish to answer that question before all:
the lastlogon time in Skype for a csv users files(Not a question of AD lastlogon) and also if users have not logged in ever too, with powershell or may by doing a select in SQL Skype db if possible ?
Does anyone do this by the past ?
Thank you !
2 answers
Sort by: Newest
-
Willem Verwijs 11 Reputation points
2022-10-03T10:09:45.997+00:00 -
Sharon Zhao-MSFT 25,056 Reputation points Microsoft Vendor
2021-02-11T05:50:48.617+00:00 @PATMOY ,
You could execute the following scripts in Skype for Business back end server to get the LastLogIn Time of users:SELECT UserStatistics.UserId, Users.UserUri, UserStatistics.LastLogInTime From [LcsCDR].[dbo].[UserStatistics] Inner JOIN [LcsCDR].[dbo].[Users] ON [LcsCDR].[dbo].[Users].UserId = [LcsCDR].[dbo].[UserStatistics].UserId WHERE LastLogInTime IS NOT NULL ORDER BY [LcsCDR].[dbo].[UserStatistics].LastLogInTime Desc
If the user never log in Skype for Business client, it will show no record.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.