• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 24
  • Last Modified:

missing patches difference between windows update and scan file of SASS

we are using MBSA Scan SAss file to identify the missing patches in windows 2008 r2 std and


 and this missing patches list is different from windows update. attached the screenshot
Im not sure, which one should I follow..correctly to install the patches

and also
what is the difference between Quality Rollup and Quality update (have a look in the screenshot)? Do I need to install both? Pls suggest

Attached for the Ref:
sass file outputwindows update screenshot
and also in another Server windows 2008 r2 std, we have sql server installed, how can i identify the missing patches for SQL server 2012/14 any scan recommend?
0
bsarahim
Asked:
bsarahim
1 Solution
 
Adam BrownSr Solutions ArchitectCommented:
A rollup includes all updates for a specific period. In this case, the KB4074598 rollup includes all updates for the month, including the KB4074587 update, which is the one missing from your WIndows update list. The MBSA utility doesn't take superseded updates into account, and the second update in your top picture is superseded by the first listed update (Rollups include all updates, so installing the update and the rollup is redundant).

The Microsoft Update list should include updates for Microsoft SQL Server, and MBSA will scan for missing SQL server security updates as well. Note, here, that SQL server security updates are less common, and SQL server generally follows a quarterly rollup schedule, rather than issuing individual updates. This is because SQL server requires more availability than Windows Server, and changes to SQL server will always require SQL services to shut down.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now