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 Hyper-V guests dissapeared and reappeared
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 4:30:47 PM(UTC)
Lansweeper DB cleanup script
Belarus  William382  
Go to last post Go to first unread
Last post: Yesterday at 4:23:43 PM(UTC)
Lansweeper Installing MS KB with Deploy
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 4:01:45 PM(UTC)
Lansweeper Ticket Info Meter incorrect
by  pfalls  
Go to last post Go to first unread
Last post: Yesterday at 3:27:44 PM(UTC)
Lansweeper Asset Checkboxes in reports
by  ufficioced   Go to last post Go to first unread
Last post: Yesterday at 1:22:17 PM(UTC)
Lansweeper Silent "Run as logged in user" option
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 3:45:25 AM(UTC)
Lansweeper New ticket creation not emailing the user
by  MVMIC IT LANSWEEPER   Go to last post Go to first unread
Last post: 11/15/2019 5:36:23 PM(UTC)