SOLVED

Powershell Get Members of a Team and the Date they Joined

%3CLINGO-SUB%20id%3D%22lingo-sub-1506239%22%20slang%3D%22en-US%22%3EPowershell%20Get%20Members%20of%20a%20Team%20and%20the%20Date%20they%20Joined%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506239%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20a%20script%20that%20will%20get%20all%20the%20members%20of%20a%20Team%20and%20list%20the%20date%20they%20joined.%26nbsp%3B%20We%20have%20a%20community%20team%20that%20is%20open%20and%20we%20are%20looking%20to%20pull%20a%20report%20each%20month%20that%20includes%20the%20Joined%20Date.%26nbsp%3B%20I've%20tried%20some%20exchange%20commands%20and%20some%20teams%20commands%20but%20when%20I%20pipe%20any%20of%20them%20to%20FL%20there%20is%20no%20dates%20that%20can%20be%20attributed%20to%20joined.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECommands%20I%20have%20tried%20thus%20far%3A%3C%2FP%3E%3CP%3EGet-UnifiedGroupLinks%26nbsp%3B%3C%2FP%3E%3CP%3EGet-Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1506239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Elist%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMembers%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

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 Replies
Highlighted
Best Response confirmed by ThereseSolimeno (Microsoft)
Highlighted

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