SQL Query to select Server and Workstation assets Operating System, OS Service packs installed (i.e. KBxxxxx) and the associated KBxx Installed On date.

SQL Query to select Server and Workstation assets Operating System, OS Service packs installed (i.e. KBxxxxx) and the associated KBxx Installed On date.

Within SDP, I am able to view server and workstation OS, KBs installed and the date the KBs were installed on.  See attached picture for reference.  Could you please provide me a SQL query that will pull back this information for each asset?

                New to ADSelfService Plus?