Forum Discussion
Jamie Luce
Jul 07, 2020Copper Contributor
Powershell Get Members of a Team and the Date they Joined
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 th...
- Jul 07, 2020
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-compliance?view=o365-worldwide
HenryPhillipsNimbitech
Jul 07, 2020Bronze Contributor
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-find-user-join-date-for-o365-groups/db7d9ecc-1ce5-4e19-9bad-eaab82ba28ae
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