locked
Report to see what users are not logging into Skype for Business RRS feed

  • Question

  • Is there a way to run a report against all users to see who is not logging into Skype for Business. 

    Any help would be greatly appreciated

    Tuesday, May 15, 2018 8:11 AM

All replies

  • Hi  alanpeters80,

     

    Please open the SQL Server Management Studio,connect to SFB\RTCLOCAL database.run the following SQL

    select r.UserAtHost from rtc.dbo.Resource R where  R.ResourceId not in(select RE.OwnerId from rtcdyn.dbo.RegistrarEndpoint RE,rtc.dbo.Resource R where R.ResourceId = RE.OwnerId) and r.UserAtHost not like '%RtcApplication-%'


    Best Regards,
    Leon Lu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, May 16, 2018 6:19 AM
  • Hi,

     

    Are there any update for this issue, if the reply is helpful to you, please try to mark it as an answer, it will help others who has similar issue.


    Best Regards,
    Leon Lu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Thursday, May 17, 2018 7:59 AM
  • That's great thanks for your help.
    Thursday, May 17, 2018 8:14 AM
  • You could mark the answer (under the reply )like the following screenshot。


    Best Regards,
    Leon Lu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Thursday, May 17, 2018 9:12 AM
  • Hi ,

     

    Do you have some updates? If the reply help to you ,please mark the reply as answer.


    Best Regards,
    Leon Lu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, May 23, 2018 2:23 AM