How to expand {[@odata.type, #microsoft.graph.applicationSignInSummary]} to be exported as .CSV file or readeable?

EnterpriseArchitect 4,466 Reputation points
2024-01-31T14:11:10.6733333+00:00

How to expand {[@odata.type, #microsoft.graph.applicationSignInSummary]} to be exported as .CSV file or readable? https://learn.microsoft.com/en-us/powershell/module/Microsoft.Graph.Beta.Reports/get-mgbetareportazureadapplicationsigninsummary?view=graph-powershell-beta

Get-MgBetaReportAzureAdApplicationSignInSummary -Period D7 -Property * | ft -AutoSize

Thank you,

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
9,940 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
1,853 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
18,637 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vasil Michev 90,881 Reputation points MVP
    2024-01-31T17:13:56.4+00:00

    Why do you need this field, it only shows you the type of object returned? Simple:

    Get-MgBetaReportAzureAdApplicationSignInSummary -Period D7 -Property * | Export-CSV -nti blabla.csv 
    

    should give you all the relevant details. If that doesn't work for you, please include a screenshot of what you're seeing.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Rich Matheisen 43,931 Reputation points
    2024-01-31T19:52:02.0733333+00:00

    If I'm not mistaken, that data type has these properties:

    • appDisplayName
    • appId
    • signInCount
    • status