To list all software for all machines in a specific label.
SQL:
SELECT MACHINE.NAME AS MACHINE_NAME,
DISPLAY_NAME AS SOFTWARE_NAME,
DISPLAY_VERSION AS SOFTWARE_VERSION,
SOFTWARE.PUBLISHER
FROM (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE, MACHINE_LABEL_JT, LABEL)
WHERE MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
AND MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID
AND LABEL.ID = MACHINE_LABEL_JT.LABEL_ID
AND NOT IS_PATCH AND LABEL.NAME like ('PUT_MACHINE_LABEL_HERE%')
order by MACHINE_NAME
Replace the word 'PUT_MACHINE_LABEL_HERE' with actual Machine label.