The way I would do it would be using Rest API.
Personally I use command line with a VPS server.
Get all products in a collection, using the collection ID.
Then you iterate through the results and can group stock by product/variant or whatever you need to do with it.
Finally send results back, email, csv, etc.
Here is a link.
Development help: jcebellc.com