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.
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?