Windows Security Update Report

Question

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

solved 0
Imran Awan 2020-05-02T19:56:04+05:30 5 Answers 210 views Beginner
0

Answers ( 5 )

  2. Imran Awan
    0
    2020-05-03T08:28:21+05:30
    Reply

    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 ‘‘’.

  4. harjit
    0
    2020-05-02T23:01:44+05:30
    Reply

    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.
    https://snipboard.io/Z152qt.jpg

  6. Imran Awan
    0
    2020-05-02T22:46:16+05:30
    Reply

    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

    • Mohan Kumar
      0
      2020-05-03T01:19:09+05:30
      Reply

      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
  8. Anoop C Nair
    1
    2020-05-02T20:52:56+05:30
    Reply

    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 .