Forum Discussion

dafo43's avatar
dafo43
Copper Contributor
Jun 13, 2020
Solved

Graph API and Powershell

I'm looking to use the Graph API to get some Teams stats using PowerShell - https://docs.microsoft.com/en-us/graph/api/reportroot-getteamsuseractivitycounts?view=graph-rest-1.0 . The content seems to...
developer
microsoft teams
  • Geetha63's avatar
    Geetha63
    Jun 15, 2020

    Hidafo43 

     

    Report only provides the Teams activities by activity type, we can't extract TeamsName from this

     

    Please use below lines to your script to export the data into csv 

    $resultarray = ConvertFrom-Csv -InputObject $result
    $resultarray | Export-Csv "C:\output.csv" -NoTypeInformation

     

Geetha63's avatar
Geetha63
Copper Contributor
Jun 15, 2020

Hidafo43 

 

Report only provides the Teams activities by activity type, we can't extract TeamsName from this

 

Please use below lines to your script to export the data into csv 

$resultarray = ConvertFrom-Csv -InputObject $result
$resultarray | Export-Csv "C:\output.csv" -NoTypeInformation

 

  • dafo43's avatar
    dafo43
    Copper Contributor
    Jun 15, 2020

    Thanks, I can see the column names with the exported CSV, so that's enough to work with.

Resources