Windows Updates Installed On date
I've duplicated and altered one of the report scripts under patching and I cannot seem to find one field in the DB. I thought it would have been the "SOFTWARE.INSTALL_DATE" that would tell me when an update was installed on a particular computer, but the contents do not match what "Add Remove Programs" > "View Installed Updates" shows for an "Installed On" date. Could someone point me in the direction of where to find this field and what table it's in? I've posted my code below if anyone wants to see it. We did find some of the info under Asset_History, but that doesn't tell me if a particular update is installed on the computer.
SELECT MACHINE.NAME, MACHINE.LAST_USER, SOFTWARE.DISPLAY_NAME, SOFTWARE.PUBLISHER, SOFTWARE.INSTALL_DATE
,str_to_date(SOFTWARE.INSTALL_DATE,'%m/%d/%Y') as InstDate
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE IS_PATCH = 1
and MACHINE.NAME = "NCPC06TVHS"
ORDER BY InstDate DESC