Need expanded digital goods report

[mfreeze]

One of my clients wants a report on digital goods that details which product(s) or variant(s) a digital good is attached to. Has anybody done this or have an idea how to produce such a report. It does not need to be within Able, a standalone SQL query would work.

[mazhar]

I think you need to have a look at Administration > Catalog > Digital Goods > Manage Digital Goods page
You will see the information about number of products associated with a digital good and if you click that count it will take you to the Administration > Catalog > Digital Goods > Manage Digital Goods > View Products page where it will show all products associated with that digital good. This may provide you a basic idea about your report and how to accomplish this.