Report containing 3 kbs that haven't been installed
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
Answers (1)
Please log in to answer
Posted by:
ajones88
4 years ago
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
Comments:
-
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 - rrealejo 4 years ago-
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 - ajones88 4 years ago