How can I pull a list of all software installed in environment?

[Megan Barber]

We are trying to pull a list of all software installed in our environment and are having difficulties. Is there a way to pull this list without it pulling each install instance? We have tried exporting the software installations and manually removing the duplicates, but SNOW only exports 32001 rows maximum.

[Sulabh Garg]

Hi Megan,

One way is you can increase the  Export Limits properties.

you can apply the filter in the list views and exclude what you don't want to export and then export the installed softwares.

If you have Large number of records and exporting a huge data ta once will cause performance issues in the instance. Please visit this link for best practices to export huge data on the platform. 

Break up large export data

Hope it helps!!

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 
Regards
Sulabh Garg

[Joe Ryder]

This is why services such as SnowMirror were stood up. It's why a lot of orgs are looking at Snowflake to replicate data lakes. You're talking often about millions of rows which are not visible in Excel due to data limits there too.

If you really want to export all software installation records, you'll need to do data replication into an external database so that you don't cause performance issues querying directly to the production database. This is on purpose because the value of exporting every software installation, regardless of licensability, category, and asset risk, has very little value. Not sure the use case, but after 8 years in SAM, I would never again look for a way to export the entire raw data set to do what the tool already does. Exporting targeted, contextual data is so much more accessible, relevant, and efficient. This is as long as you trust the work done by the system before your reporting.

Perhaps you can share what your goal with exporting is and we in the community can help with achieving that goal without the process and residual issues of exporting raw data...