To discover Patch on the Windows servers

Suman21 · ‎04-27-2022

We have requirement to Discovery the Patches(cmdb_ci_patches) table. However, I would like to know

if the discovery will be able to give us the information like.. what is the patch installed, Patch version, last installed patch.

There are some postings in community regarding this but it's almost 3 years back.. I am expecting Servicenow might have upgraded it in new versions.

If not, what is the best way to scan the patches and update to CMDB.

Robin J_ · ‎12-14-2022

Hello Suman21,
Came across this thread and what you can do is create an extension for Windows* pattern to catch this using "win32_quickfixengineering" - for reference: https://powershell.one/wmi/root/cimv2/win32_quickfixengineering

Example from a demo environment we have:

We have created an extension for "Windows OS - Servers" pattern:

Step "Get HotFixID":

Step "Set HotFixID":

Also referring to the earlier link, there is a lot of other values from "win32_quickfixengineering" which probably cover your use case(s)/need(s):

Kind regards,
Robin

View solution in original post

Suman21 · ‎12-15-2022

Hi Robin,

Forget about that the previous screen shot. I mean to say that when I run the discovery, I am getting the payload error message.

The insert is not happening. When I try from Pattern to test it works and shows the output.

But when I run discovery... I am getting payload error. I have sync the Mid Servers with Patterns.

Check the attachment.

I am sure the SNOW Technical team will not help on this issue as it is customized one.

Suman21 · ‎12-16-2022

Hi Robin,

I was able to fix the payload error which I was getting yesterday. However,
I would like to know if I want to get the installDate, InstalledOn information.

How I can add that query in pattern? Can you please suggest with same kind of screen shots you provided for Hotfix ID.

Appreciate your help!!

Suman21 · ‎12-19-2022

Hi Robin,

I was able to fix the payload error which I was getting yesterday. However,
I would like to know if I want to get the installDate, InstalledOn information.

How I can add that query in pattern? Can you please suggest with same kind of screen shots you provided for Hotfix ID.

Appreciate your help!!

Robin J_ · ‎12-19-2022

I have not created for these fields, but with the same approach you should be able to create something. I have used same approach for different fields (for example BIOS install date etc.)

- Robin

Girija Sankar G · ‎05-01-2024

Hi @Suman21 ,

Have you extended your pattern to get InstallDate and InstalledOn information for Hotfix/patches ?

Thanks

Giri