/build/static/layout/Breadcrumb_cap_w.png

Report Not Working: "Software Listing By Label"

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

Posted 10 years ago 4157 views

Comments

  • The report list software titles and the label names they have applied. Are you looking for something else?

    Also, you may get more responses if you post this as a question and not a blog. - chucksteel 10 years ago
    • Hi Chuck - basically I am looking to display a summary of the software installed on the machines that are apart of each label that I created. I don't need the machines displayed in the report - just the software.

      For example: LABEL: 2440 Accounting Workstations

      Installed Software Is:
      Adobe reader
      Microsoft Office
      Etc.........
      Etc........... - shandy4473 10 years ago
      • This query will give you the software installed on any machines that have the specified label applied:

        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
  • Perfect Checksteel. This is exactly what I need. Thank You - shandy4473 10 years ago
This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ