locked
Last Log-on Date for SharePoint Online (O365) Users RRS feed

  • Question

  • Hi,

    We have identified 100+ inactive users who never accessed their individual O365 Exchange MailBox last 1 year(using https://gallery.technet.microsoft.com/scriptcenter/Export-Office-365-User-7fc0b73f Script); we wanted to ensure they have not accessed any SharePoint online site during that time so we can delete them to release license cost.

    We need to understand,

    Does Last log on date for O365 Exchange MailBox users mean the user has not accessed SharePoint Online and other O365 components since the last log on or is it only applicable to Exchange Mail accounts?

    If not, Is there any script available to extract the user last log-on date to SharePoint online sites only?

    I am available for a discussion on this.

    Kind regards,


    srikrushna patro



    Tuesday, March 29, 2016 2:42 PM

Answers

  • Hi srikrushna,

    Per my knowledge, there is no such OOTB feature for recording user accessing SharePoint Online site currently.

    Moreover, O365 Exchange MailBox and SharePoint Online are two different services, the last log on date for the two services have nothing to do with each other.

    For this kind of requirement, I would prefer deploying server side solution to monitor the user requests at the IIS side. However, when comes to SharePoint Online, no server side solution is allowed.

    A thought is that, maybe we can do it from client side. For example, applying custom JavaScript into the welcome pages of the SharePoint Online sites, then when users log on a site, the script will be triggered to add a record in a SharePoint list. The last log on date will be able to be queried in this SharePoint list.

    Also, I would suggest you submit a feedback to the SharePoint UserVoice Platform if there any expectation about the future version of SharePoint:

    http://sharepoint.uservoice.com/

    It is a place for customers provide feedback about Microsoft Office products. What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

    You can also keep tracking the updates(for products and APIs) that are currently planned in Office 365 Roadmap:

    http://fasttrack.microsoft.com/roadmap     

    Best regards,

    Patrick

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Dennis Guo Tuesday, April 5, 2016 3:01 AM
    • Marked as answer by Dennis Guo Wednesday, April 6, 2016 9:34 AM
    Thursday, March 31, 2016 7:55 AM

All replies

  • May be I am wrong but as per my knowledge, such information (last login time) is not stored or managed by SharePoint at all.

    However, you can find the information when the user was last logon to the domain. Please check this earlier discussion if it helps you to resolve your asked concern : http://sharepoint.stackexchange.com/questions/74598/powershell-to-view-last-login-date-for-users

    I can also suggest you a free tool named Lepide last logon reporter which also helps to fetch such reports within few clicks.


    Carlo

    Wednesday, March 30, 2016 9:49 AM
  • Hi srikrushna,

    Per my knowledge, there is no such OOTB feature for recording user accessing SharePoint Online site currently.

    Moreover, O365 Exchange MailBox and SharePoint Online are two different services, the last log on date for the two services have nothing to do with each other.

    For this kind of requirement, I would prefer deploying server side solution to monitor the user requests at the IIS side. However, when comes to SharePoint Online, no server side solution is allowed.

    A thought is that, maybe we can do it from client side. For example, applying custom JavaScript into the welcome pages of the SharePoint Online sites, then when users log on a site, the script will be triggered to add a record in a SharePoint list. The last log on date will be able to be queried in this SharePoint list.

    Also, I would suggest you submit a feedback to the SharePoint UserVoice Platform if there any expectation about the future version of SharePoint:

    http://sharepoint.uservoice.com/

    It is a place for customers provide feedback about Microsoft Office products. What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

    You can also keep tracking the updates(for products and APIs) that are currently planned in Office 365 Roadmap:

    http://fasttrack.microsoft.com/roadmap     

    Best regards,

    Patrick

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Dennis Guo Tuesday, April 5, 2016 3:01 AM
    • Marked as answer by Dennis Guo Wednesday, April 6, 2016 9:34 AM
    Thursday, March 31, 2016 7:55 AM
  • Dear May be I am wrong, but you can check the activities of each user from audit logs.

    Check the below article.

    https://support.office.com/en-us/article/View-audit-log-reports-b37c5869-1b47-4a82-a30d-ea20070fe527


    http://www.abdulazizfarooqi.wordpress.com Abdul Aziz Farooqi [BizTalk & SharePoint Consultant] MCPD Web & MCPD SharePoint 2010

    Thursday, March 31, 2016 5:30 PM