Query:
Note: Before run this query has to be enabled QUICK_FIX_ENGINEERING Class on Hardware Inventory from SCCM Primary site.
select Hostname, LastPatchInstallDate, LastHotfix, [Operating System] from (
Select ROW_NUMBER() OVER (PARTITION BY sys.Netbios_Name0 ORDER BY (cast(InstalledOn0 as date)) desc) ID, sys.Netbios_Name0 'Hostname',
upd.HotFixID0 'LastHotfix', gos.Caption0 'Operating System', upd.Description0 'Description' ,(cast(InstalledOn0 as date)) as LastPatchInstallDate,
sys.ResourceID
FROM v_R_System sys
JOIN v_GS_QUICK_FIX_ENGINEERING upd
ON sys.ResourceID = upd.ResourceID
join v_GS_OPERATING_SYSTEM gos
on sys.ResourceID = gos.ResourceID
) sel
where ID =1
--order by LastPatchInstallDate desc
Result:
Thank You!