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?