Normally when you create a software based report and try to filter on a Label you are filtering on the labels that are assigned to the software item and not the labels that are associated with the Computer.
This report is very similar to the "Software on Computer" report that is included with your KACE SMA appliance except that it adds in a filter based on the membership of computers in a label called "complabel". You can replace that value with whatever is relevant for your environment.
Click Reporting | Select Action | Add New Report (SQL).
Enter your report Title, Category, and Description fields and add the following SQL:
SELECT CONCAT(MACHINE. NAME , "\\" , MACHINE.SYSTEM_DESCRIPTION) AS MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION, 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 MACHINE_LABEL_JT.LABEL_ID = LABEL.ID AND LABEL. NAME in ( 'complabel' ) /*specify the full name of the machine label here*/ AND NOT IS_PATCH ORDER BY MACHINE_NAME, DISPLAY_NAME |
*NOTE - The above report is for a Label with the title complabel, change the line that reads AND LABEL.NAME in('complabel') to match your label title.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center