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
Also, you may get more responses if you post this as a question and not a blog. - chucksteel 10 years ago
For example: LABEL: 2440 Accounting Workstations
Installed Software Is:
Adobe reader
Microsoft Office
Etc.........
Etc........... - shandy4473 10 years ago
SELECT DISTINCT(SOFTWARE.DISPLAY_NAME)
FROM LABEL
JOIN MACHINE_LABEL_JT on MACHINE_LABEL_JT.LABEL_ID = LABEL.ID
JOIN MACHINE on MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE_LABEL_JT.MACHINE_ID
JOIN SOFTWARE on SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
WHERE LABEL.NAME = "Library Services"
AND NOT IS_PATCH
ORDER BY SOFTWARE.DISPLAY_NAME - chucksteel 10 years ago