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

PATMOY 1 Reputation point

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 !

Skype for Business
Skype for Business
A Microsoft communications service that provides communications capabilities across presence, instant messaging, audio/video calling, and an online meeting experience that includes audio, video, and web conferencing.
610 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Sharon Zhao-MSFT 25,071 Reputation points Microsoft Vendor

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

    1 person found this answer helpful.

  2. Willem Verwijs 21 Reputation points

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

    0 comments No comments