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

EnterpriseArchitect 4,466 Reputation points

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

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
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

    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

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

    • appDisplayName
    • appId
    • signInCount
    • status