Automated Windows Hotfix Discovery

stormy 12
Tera Contributor

Hello Community,

 

I am working on a requirement to discover Windows Server hotfixes for specific OS versions and store them in a dedicated custom table (u_cmdb_ci_hotfixes).

While I have successfully configured the WMI query in a pattern extension and can see the data in the execution payload, the records are not importing into the target table and I am stuck here.

 

1)Created custome table name "u_cmdb_ci_hotfixes".

2)Added step in extension section of "Windows OS - server" named Collect Hotfixes

3)I am getting payload in at collect the hotfixes step but importing is not happning

4)Also Insert to table step is not throwing any error.I am getting payload there as well.

 

getHotfix1.pnginserTotable.png

insert to table.pnghotfixes log.png

 
 

Any insights on  "Insert to Table" configuration for this use case would be greatly appreciated!

 

Thank You in advance!

1 REPLY 1

Vishnu-K
Tera Guru

Hi  @stormy 12 ,

 

Try updating the Target table name in Step 1 Example : cmdb_ci_temp_hostfixes, and then use the same updated name in the Source table field in Step 2. After making these changes, run the discovery again.

 

Hope this helps you, Please do mark it as helpful . And accept the solution.


Regards,
Vishnu