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

Question

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.

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

Thanks,
Ram

Answer 1

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.