Application inventory rollup

[Dean Gross]

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

[#2]

Its not perfect, but the query will do the job.

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