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 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
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
- HenryPhillipsNimbitechBronze 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-eaab82ba28aeAnd possibly as to the PowerShell requirement:
https://docs.microsoft.com/en-us/powershell/module/exchange/search-unifiedauditlog?view=exchange-psIt is worth noting that unfortunately the Audit log is not enabled by default but it can easily be turned on at compliance.microsoft.com
ThanksHenry
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