Forum Discussion
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
Its not perfect, but the query will do the job.
securityresources
| where type == "microsoft.security/softwareinventories"
| extend software = tostring(todynamic(properties).software)
securityresources
| where type == "microsoft.security/softwareinventories"
| extend software = tostring(todynamic(properties).software)