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 Unable to send to External Email
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 8:21:01 PM(UTC)
Lansweeper Lansweeper assets not being Scanned
by  Jordan  
Go to last post Go to first unread
Last post: Yesterday at 6:42:22 PM(UTC)
Lansweeper Database size growing too large
by  bladd   Go to last post Go to first unread
Last post: Yesterday at 4:26:44 PM(UTC)
Lansweeper Searching Specific File
by  mzipperer  
Go to last post Go to first unread
Last post: Yesterday at 4:23:29 PM(UTC)
Lansweeper Exchange 2010 information is not populating
by  Moe   Go to last post Go to first unread
Last post: Yesterday at 12:30:38 PM(UTC)
Lansweeper Routinely Exploited Vulnerabilities Query Report
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 12:25:31 PM(UTC)
Lansweeper Creating a report for new devices every 2 hours to alert
by  Moe   Go to last post Go to first unread
Last post: 6/4/2020 7:26:11 PM(UTC)
Lansweeper Changes in the licensing model
by  BullGates  
Go to last post Go to first unread
Last post: 6/4/2020 6:27:23 PM(UTC)