Forum Discussion

Dean_Gross's avatar
Dean_Gross
Silver Contributor
Oct 13, 2022

Application inventory rollup

Is there a way to pivot the inventory list around so that it shows all of the applications instead of all of the servers? When I export the CSV it does not include the applications

1 Reply

  • askvpb's avatar
    askvpb
    Brass Contributor
    Its not perfect, but the query will do the job.

    securityresources
    | where type == "microsoft.security/softwareinventories"
    | extend software = tostring(todynamic(properties).software)

Resources