Powershell Get Members of a Team and the Date they Joined

[Jamie Luce]

I am looking for a script that will get all the members of a Team and list the date they joined.  We have a community team that is open and we are looking to pull a report each month that includes the Joined Date.  I've tried some exchange commands and some teams commands but when I pipe any of them to FL there is no dates that can be attributed to joined.  

Commands I have tried thus far:

Get-UnifiedGroupLinks 

Get-Team

[#2 · Accepted solution]

The only way to get the date is to crawl the Unified audit log: https://docs.microsoft.com/en-us/microsoft-365/compliance/search-the-audit-log-in-security-and-compl...

[#3]

Hi @Jamie Luce ,

Could you make use of the Audit logs as suggested here:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_o365admin-mso_exchon-mso_o365b/how-to-fi...

And possibly as to the PowerShell requirement:

https://docs.microsoft.com/en-us/powershell/module/exchange/search-unifiedauditlog?view=exchange-ps

It is worth noting that unfortunately the Audit log is not enabled by default but it can easily be turned on at compliance.microsoft.com

Thanks

Henry