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
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.
https://snipboard.io/Z152qt.jpg
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 ——
Hello – Check the SQL report in the following thread by Mohan Kumar.
I think that will help you …