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,933  
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 Physical Disk Size
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 5:18:38 PM(UTC)
Lansweeper AD User report
by  GMcCartney  
Go to last post Go to first unread
Last post: Yesterday at 12:07:22 PM(UTC)
Lansweeper PC Build Report Missing Software
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 10:28:40 AM(UTC)
Lansweeper Creat report ALL office (ms officce,libreoffice,openoffice)
by  RC62N  
Go to last post Go to first unread
Last post: 11/15/2019 9:58:33 PM(UTC)
Lansweeper How to Report on Dynamic Asset Groups
by  Rob-CD   Go to last post Go to first unread
Last post: 11/15/2019 11:49:22 AM(UTC)
Lansweeper Custom All Assets Report Help
by  Matt Fuhrman  
Go to last post Go to first unread
Last post: 11/14/2019 3:55:25 PM(UTC)
Report Center Calculate your network's computing power
by  GBInnovation   Go to last post Go to first unread
Last post: 11/13/2019 12:11:18 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  JacobH  
Go to last post Go to first unread
Last post: 11/12/2019 5:28:37 PM(UTC)