Need to on Script that generates list of installed updates from remote computers

Ramanjaneyulu Butharaju 421 Reputation points
2021-07-14T02:32:31.587+00:00

Hello All,

Hope you are doing good.

I'm trying to export the list of monthly installed patches in remote computers using WMIC, This actually exporting all installed updates in HTML format.

but I just want only this month's installed patches report. Can we customize this script to get only report updates installed in particular month or within dates ( From 01-July-2021 to 31-July-2021)

Here is the script i am using to export all installed updates from remote computers.

wmic /node:ADC qfe list full /format:htable > E:\Updates\ADCJulyReport.html
wmic /node:ADC1 qfe list full /format:htable > E:\Updates\ADC1JulyReport.html
wmic /node:ADC2 qfe list full /format:htable > E:\Updates\ADC2JulyReport.html
wmic /node:ADC3 qfe list full /format:htable >E:\Updates\ADC3JulyReport.html
wmic /node:ADC4 qfe list full /format:htable > E:\Updates\ADC4JulyReport.html
wmic /node:ADC5 qfe list full /format:htable > E:\Updates\ADC5JulyReport.html
wmic /node:ADC6 qfe list full /format:htable > E:\Updates\ADC6JulyReport.html

here is the SAMPLE output which I am getting now.

114402-image.png

But I am looking for a particular month of installed updates in HTML format.

Thanks,
Ram

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,044 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,344 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ian Xue (Shanghai Wicresoft Co., Ltd.) 29,311 Reputation points Microsoft Vendor
    2021-07-14T05:57:05.523+00:00

    Hi,

    Please try this

    wmic /node:ADC qfe where "InstalledOn like '7/%/2020'" list full /format:htable > E:\Updates\ADCJulyReport.html  
    

    Best Regards,
    Ian Xue

    ============================================

    If the Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful