report or sql query to get all software releases with packages
or any other way to target all software releases resources that have packages and not the whole software catalog.
Trying to get a target for exporting software releases from workflow but bit stuck with this problem. actually can get all software releases items and all packages items in workflow, then filter the software resource collection against the packages by name. But first its dead slow and secondly it runs on one system and crashes on the next. so might be better to go the direct sql query way, but so far I didnt get were the Item table and the swdpackage table are linked.
thanks for suggestions..