How to list all KBs approved/declined in a date range?

CFA Jason 1 Reputation point
2020-09-17T17:05:05.097+00:00

I'd like to run a report that shows which KBs have been approved or declined within a data range. It's helpful to have this information at-hand when trying to diagnose an issue related to a particular windows update - such as "did this weird problem happen after installing this update? When did I approve that update?"

I've started poking around in the SUSDB database and come up with a query that seems reasonable.

But I wonder if there's a better way about it?

Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,564 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Aidan Johnson 1 Reputation point
    2020-09-17T21:37:34.393+00:00

    Are you wanting to do this per machine or when it was approved in wsus?

    0 comments
  2. Teemo Tang 11,366 Reputation points
    2020-09-18T04:33:16.66+00:00

    1.Generate a list of windows patches and the date they were installed on PC.
    2.Generate patch report from WSUS
    Which one do you want?
    Demand 1 can be meet by powershell command or wmic command
    Demand 2, you need to ask for help from scripting forum

    0 comments