12Knocksinna / Office365itpros

Office 365 for IT Pros PowerShell examples
MIT License
1.24k stars 559 forks source link

TeamsGroupsActivityReportV5.PS1 --> "getTeamsTeamActivityDetail" not work #89

Closed LHBL2003 closed 11 months ago

LHBL2003 commented 11 months ago

https://github.com/12Knocksinna/Office365itpros/blob/master/TeamsGroupsActivityReportV5.PS1

I am trying to use this script. The token works so far. However, it seems that line 155 does not work anymore.

Triggered is the Uri: https://graph.microsoft.com/beta/reports/getTeamsTeamActivityDetail(period='D180')?$format=application/json

This does not return any result on the developer page either: https://developer.microsoft.com/en-us/graph/graph-explorer

It seems that the beta GET request no longer exists. I can't find it in V1.0 either.

Script error: Get-GraphData : System.Net.WebException: The remote server returned an error: (403) Illegal. at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) for Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() In C:\Users\my.name\xyz\Desktop\PS Teams\TeamsGroupsActivityReportV5.PS1:156 characters:21

Translated with www.DeepL.com/Translator (free version)

LHBL2003 commented 11 months ago

OK I understand, you have to search under Cesources in Graph Explorer:

https://graph.microsoft.com/v1.0/reports/microsoft.graph.getTeamsTeamActivityDetail(period='{period}')

But I would argue that the script needs to be adjusted.

LHBL2003 commented 11 months ago

https://graph.microsoft.com/beta/reports/getTeamsTeamActivityDetail(period='D180')?$format=application/json

Works in Explorer, you have to log in there and give yourself rights.

Apparently you need rights for Reports.Read.All

My token has them, but it does not work yet. I have to search for the reason.