There are instances (you might want to get list of required patches by server ,so can download and install in DMZ who do not have internet or for patch compliance checking for specific computer and many) , where you might be searching for list patches of required by specific computer/computers and generally ,we look at default reports if there is any report which can give me the required information.
If you look at default reports,there is no exact report give you the list of patches required by specific computer with targeted,required,when was it released and other information.
You can use below SQL Query to run from SQL SERVER MANAGEMENT STUDIO or use this in your SSRS Reports with parameter for computer name.
This query has been customized to present the Month posted,Title of the patch,Targeted to the client,Required ,KB URL,Date posted and deadline if there is any.
Note: This Query is filtered with Severity (Security and critical) from view v_UpdateInfo.
select CAST(DATEPART(yyyy,ui.DatePosted) AS varchar(255)) + '-' + RIGHT('0' + CAST(DATEPART(mm, ui.DatePosted) AS VARCHAR(255)), 2) AS MonthPosted,
ui.bulletinid [BulletinID],ui.articleid [ArticleID], ui.Title,
Targeted=(case when ctm.ResourceID is not null then '*' else '' end),
IsRequired=(case when css.Status=2 then '*' else '' end),
ui.InfoURL as InformationURL,
ui.dateposted [Date Posted] ,
from V_UpdateComplianceStatus css
join v_UpdateInfo ui on ui.CI_ID=css.CI_ID
left join v_CITargetedMachines ctm on ctm.CI_ID=css.CI_ID and ctm.ResourceID = css.ResourceID
INNER join v_CICategories_All catall2 on catall2.CI_ID=css.CI_ID
INNER join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID
JOIN dbo.v_R_System AS vrs ON vrs.ResourceID = css.ResourceID
outer apply (
from v_CIAssignment a
join v_CIAssignmentToCI atc on atc.AssignmentID=a.AssignmentID and atc.CI_ID=css.CI_ID
WHERE vrs.Name0='Win7X64-001' and
ui.Severity IN (8, 10) --this is for security and critical updates
AND css.Status=2 --for required
ORDER BY 1
I posted the same query on TechNet forums ,more info https://social.technet.microsoft.com/Forums/en-US/8fe96532-d9ef-48f2-a356-6e1195d9273e/report-of-what-updates-are-needed-by-server?forum=configmanagergeneral#7185a84e-afab-47d2-82bd-7418e02dd75f