Windows Security Update Report


I have gone through all software update reports in sccm. All say different out come. What is the best way to get the best results of which devices got the updates and it got installed, also which did not get the updates, which are the one one that are pending and lastly they got the errors

Answers ( 5 )


    Thanks for the answers and these are all valid answers … I like to know … which devices got restarted or pending restart as well… Mohan Kumar the error on the SQL server is as below … what syntax shall i change to
    The error i am getting is as below

    Msg 102, Level 15, State 1, Line 2
    Incorrect syntax near ‘‘’.


    One of the things you can do is go to the Monitoring node, then click on Deployments, look for the particular software update deployment and then do a View Status, which will give you the data you need.


    Hi Anoop, I have run that query on the sql server

    I am getting erorr message as below

    Msg 102, level 15, State 1 , line 2
    Incorrect syntax near


      Hi Imran,

      The query once you pasted in SQL, the single quotation are need to update which is showing red color in query which is copy paste error.

      you can see the error in here in result panel – Incorrect syntax near ——

      Best answer

    Hello – Check the SQL report in the following thread by Mohan Kumar.

    I think that will help you …

    Report for windows update for business patching

Leave an answer

Sorry, you do not have permission to answer to this question .