Notification

Icon
Error

adding KB numbers - I want to edit the patch Tuesday report

Posted: Monday, October 14, 2019 9:55:00 PM(UTC)
Michael.schindler

Michael.schindler

Member Original PosterPosts: 1
0
Like
I would like to edit the patch Tuesday report to include other KB articles. so for example the October 2019 report of server 2012 has the following:

When tsysOS.OSname = 'Win 8.1' Or
tsysOS.OSname = 'Win 2012 R2' Then 'KB4519990 or KB4520005'

I would like to add KB numbers and change "or" to "and"

When tsysOS.OSname = 'Win 8.1' Or
tsysOS.OSname = 'Win 2012 R2' Then 'KB4519990 and KB4520005 and KB4519974 and KB4521864 and KB4524135'

Nothing seems to change the report output. I even put bobus numbers in and the report showed machines as being updated. Am I missing something

thanks

Mike
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 10/15/2019 8:51:54 AM(UTC)
The KB numbers in the report consist of 2 parts. Part 1 which is simply informational for the end-user, and part 2 which actually does the check if the KBs are installed.

The part that your editing is Part 1.

Further down the query you will see a list of KBs that are checked. You can add or change KBs to that as you like.

Code:
 Where tblQuickFixEngineeringUni.HotFixID In ('KB4520009', 'KB4520002',
        'KB4520003', 'KB4519976', 'KB4519985', 'KB4520007', 'KB4519990',
        'KB4520005', 'KB4520011', 'KB4093109', 'KB4519998', 'KB4520010',
        'KB4520004', 'KB4520008', 'KB4519338', 'KB4517389')) As SubQuery1 On
    tblAssets.AssetID = SubQuery1.AssetID

Active Discussions

Lansweeper NOT doesn't work as expected
by  KevinA-REJIS   Go to last post Go to first unread
Last post: Yesterday at 5:49:29 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  Leslie Stroobant  
Go to last post Go to first unread
Last post: Yesterday at 3:27:42 PM(UTC)
Lansweeper All Devices with WINS Service Running on the Network
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 2:44:56 PM(UTC)
Lansweeper Physical Laptops and Desktops Only
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 1:51:56 PM(UTC)
Lansweeper Assistance With AV & Bitlocker Report
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 12:50:47 PM(UTC)
Lansweeper Count of completed KB installation Report
by  jamie21  
Go to last post Go to first unread
Last post: 6/4/2020 11:49:57 AM(UTC)
Lansweeper local admin users of a specific device
by  Andy.S   Go to last post Go to first unread
Last post: 6/4/2020 10:42:23 AM(UTC)
Lansweeper Bitlocker Report not contain all computers
by  Andy.S  
Go to last post Go to first unread
Last post: 6/3/2020 6:20:53 PM(UTC)