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?
bsarahimAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.