The Kace K1000 comes with a default software report called - "Software Listing By Label". This report was installed by default when purchased. The report is suppose to list the various software installed on machines that are associated with a particular label.

 

The output of the report is blank:

Title: Software Listing By Label

Description: This report lists all software titles organized by all K1000 labels.

Category: Software

Server Hostname: hchikace1000.hinda.local

Generated: 03/18/2014 15:40:39

#Display Name   Display Version   Publisher

 

Here is the SQL code that Dell installed on the Kace K1000:

SELECT LABEL.NAME AS LNAME, DISPLAY_NAME, DISPLAY_VERSION, PUBLISHER FROM (SOFTWARE, SOFTWARE_LABEL_JT, LABEL) WHERE SOFTWARE.ID = SOFTWARE_LABEL_JT.SOFTWARE_ID AND SOFTWARE_LABEL_JT.LABEL_ID = LABEL.ID AND NOT IS_PATCH AND LABEL.TYPE !='hidden'

ORDER BY LNAME

 

Can someone assist with the code?

 

Thanks

Steve