locked
Office 365 is there a powershell to export all Distribution Lists and Sharedmailboxes with Last accessed or mail usage date? RRS feed

  • Question

  • These forums have changed from last time I have asked questions. Where is the office 365?

    Anywoo, we have a client which they want a list of Distribution Lists and Shared mailboxes, no problem, admin portal, exchange, export cool, but what Microsoft should have is a field that states last access so if its old we can get rid of it. I have not seen any promising powershell scripts to retrieve much info and to export it to a spread sheet.

    Any suggestions appreciated.

    thanks


    Best regards,<br/> <br/> <strong>Joe C<br/> </strong>Partner Online Technical Community<br/> -----------------------------------------------------------------------------------------<br/> We hope you get value from our new forums platform! Tell us what you think:<br/> <a href="http://social.microsoft.com/Forums/en-US/partnerfdbk/threads"><span style="color:#0033cc">http://social.microsoft.com/Forums/en-US/partnerfdbk/threads<br/> </span></a>------------------------------------------------------------------------------------------<br/> This posting is provided &quot;AS IS&quot; with no warranties, and confers no rights <hr>

    Thursday, October 15, 2020 3:38 PM

Answers

  • Not what im looking for as it doesn't pull all DL or Shared mailboxes, i was able to pull office groups which is teams.  ANyway I think this powershell will do the trick.

    https://office365itpros.com/2018/11/15/finding-inactive-distribution-lists/

    MS support couldn;t give me a direct answer as well.


    Best regards,<br/> <br/> <strong>Joe C<br/> </strong>Partner Online Technical Community<br/> -----------------------------------------------------------------------------------------<br/> We hope you get value from our new forums platform! Tell us what you think:<br/> <a href="http://social.microsoft.com/Forums/en-US/partnerfdbk/threads"><span style="color:#0033cc">http://social.microsoft.com/Forums/en-US/partnerfdbk/threads<br/> </span></a>------------------------------------------------------------------------------------------<br/> This posting is provided &quot;AS IS&quot; with no warranties, and confers no rights <hr>

    • Marked as answer by Joe-ker Monday, November 2, 2020 2:56 PM
    Monday, November 2, 2020 2:56 PM

All replies

  • Audit logs https://docs.microsoft.com/en-us/microsoft-365/compliance/enable-mailbox-auditing?view=o365-worldwide should tell you who/if a Shared Mailbox is being accessed and the Message Trace Logs will tell you if a distribution list is being used or not.

    Cheers
    Glen

    Thursday, October 15, 2020 11:04 PM
  • Not what im looking for as it doesn't pull all DL or Shared mailboxes, i was able to pull office groups which is teams.  ANyway I think this powershell will do the trick.

    https://office365itpros.com/2018/11/15/finding-inactive-distribution-lists/

    MS support couldn;t give me a direct answer as well.


    Best regards,<br/> <br/> <strong>Joe C<br/> </strong>Partner Online Technical Community<br/> -----------------------------------------------------------------------------------------<br/> We hope you get value from our new forums platform! Tell us what you think:<br/> <a href="http://social.microsoft.com/Forums/en-US/partnerfdbk/threads"><span style="color:#0033cc">http://social.microsoft.com/Forums/en-US/partnerfdbk/threads<br/> </span></a>------------------------------------------------------------------------------------------<br/> This posting is provided &quot;AS IS&quot; with no warranties, and confers no rights <hr>

    • Marked as answer by Joe-ker Monday, November 2, 2020 2:56 PM
    Monday, November 2, 2020 2:56 PM