/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Report containing 3 kbs that haven't been installed

02/12/2020 68 views

Hello,

I know how to create a report listing a specific software or updates installed on devices, but can I create a report listing 3 kbs displaying which devices don't have the package?


Thank you in advance,

richard

0 Comments   [ + ] Show comments

Comments


All Answers

0

This is a smart label I created, but it should be the same as a report. You may just want to edit the select statement if you want more columns pulled for your report.


just replace the KBs with the ones you want in the where statement. (KBSYS.PATCH.PATCH_IDENTIFIER IN (...))


SELECT MACHINE_ID as TOPIC_ID,
KBSYS.PATCH.TITLE AS PATCH,
MACHINE.NAME AS MACHINE,
IP
FROM PATCH_MACHINE_STATUS
JOIN KBSYS.PATCH ON (KBSYS.PATCH.ID = PATCH_MACHINE_STATUS.PATCH_ID)
JOIN MACHINE ON (MACHINE.ID = PATCH_MACHINE_STATUS.MACHINE_ID)
WHERE
KBSYS.PATCH.PATCH_IDENTIFIER IN ('KB4534306','KB4534306','KB4534271','KB4534271','KB4534276','KB4534276','KB4534276','KB4534293','KB4534293','KB4534293','KB4534273','KB4534273','KB4534273','KB4528760','KB4528760','KB4528760','KB4528760','KB4528760','KB4528760','KB4534271','KB4534271','KB4534273','KB4534273','KB4534293','KB4528760','KB4528760')
AND
PATCH_MACHINE_STATUS.PATCH_INSTALLED = 0
AND
KBSYS.PATCH.IS_SUPERCEDED = 0
AND
PATCH_MACHINE_STATUS.PATCH_APPLICABLE = 1
GROUP BY MACHINE.ID
Answered 02/12/2020 by: ajones88
White Belt

  • Hello,
    I'm still considered a novice at this stuff. I do know how to create smart labels, but I'm not sure how to create a label with the information you provided. I was hoping that you could get me started.

    Thank you,
    Richard
    • Hey Richard,

      There are two ways to create a smart label, you are probably already familiar with the first way, which would be to use the Smart Label Wizard, which gives you dropdown boxes to select critera.
      The second way is through an advanced SQL query, which will allow you to paste the SQL code I posted into the query field.

      When you create a smart label it will open the smart label wizard by default (with the dropdown boxes). When you save the query and go back to edit it, one of the options will be "SQL Query" which will open a new screen with a field that you can paste the code into.

      There is a lot more information in the following course on Quests site as well. https://support.quest.com/kace-systems-management-appliance/training/271/kace-sma-course-3-appliance-fundamentals-free

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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