-
Title
Report - Software on Computers for a given Machine Label -
Description
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.
-
Cause
CODE WRITTEN BY QUEST KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY AND NOT SUPPORTED BY KACE TECHNICAL SUPPORT. CLIENT CONFIRMS THE NEED FOR TESTING AND ACCEPTS ALL RESPONSIBILITY FOR USE AND MISUSE OF CODE. QUEST KACE SHALL NOT BE HELD LIABLE FOR DAMAGE OR DOWN TIME RESULTING FROM USE OF THIS OR ANY CODE PRESENTED FOR PURPOSES OF TROUBLESHOOTING OR DEMONSTRATION -
Resolution
Click Reporting | Select Action | Add New Report (SQL).
Enter your report Title, Category, and Description fields and add the following SQL:
SELECTCONCAT(MACHINE.NAME,"\\", MACHINE.SYSTEM_DESCRIPTION)ASMACHINE_NAME,DISPLAY_NAME,DISPLAY_VERSION,PUBLISHERFROMSOFTWARE,MACHINE_SOFTWARE_JT,MACHINE ,MACHINE_LABEL_JT,LABELWHEREMACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_IDANDSOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_IDANDMACHINE.ID=MACHINE_LABEL_JT.MACHINE_IDANDMACHINE_LABEL_JT.LABEL_ID = LABEL.IDANDLABEL.NAMEin('complabel')/*specify thefullnameofthe machine label here*/ANDNOTIS_PATCHORDERBYMACHINE_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.