how to list skype accounts with the lastlogon time in front end skype server 2015 ?

Question

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 !

Answer 1

@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.

Answer 2

what is this? .vbs, powershell, C++
can't run it from command prompt nor from powershell nor from cscript