none
Patching Reports RRS feed

  • Question

  • Hi All,

    Just now my windows patching was completed, how to pull reports which system completed pathing or not. please suggest me in SCCM.


    subu

    Saturday, September 21, 2019 11:07 AM

All replies

  • have you looked at the builtin reports.

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Saturday, September 21, 2019 12:18 PM
    Moderator
  • Hi,

    As said by Garth, there is a lot of reports already available by default on SCCM., in the console, go to Monitoring>Overview>Reporting>Expand Reports folder:

    Regards,

    SAAD Youssef

    _____

    Please remember to mark the replies as answer if they help, thank you!

    Saturday, September 21, 2019 4:26 PM
  • Hello,
     
    Thanks for posting in TechNet.
     
    Using reports, check: \Monitoring\Overview\Reporting\Reports\Software Updates - C Deployment States\States 1 - Enforcement states for a deployment.
     
    Using console, check: \Monitoring\Overview\Deployments, find your deployment, double click on it, run summarization and then check the status.
     
    Hope my answer could help you and look forward to your feedback.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, September 23, 2019 2:24 AM
  • Hi Team,

    I have chekced report- Software update A,B,C,D,E these are updated on last year only what should i do please suggest me.


    subu

    Monday, September 23, 2019 12:47 PM
  • If you want Sql query use the below one

    Select * from v_CIAssignment order by AssignmentID --use this to grab proper AssignmentID and replace below


    SELECT DISTINCT v_R_System.Name0, 
    v_R_System.User_Name0,
    v_R_System.Operating_System_Name_and0,
    v_R_System.Build01,
    REPLACE
    (REPLACE
    (REPLACE
      (REPLACE
       (REPLACE
        (REPLACE
         (REPLACE
          (REPLACE
           (REPLACE
            (REPLACE(v_AssignmentState_Combined.StateID,'0','enf state unknown')
            ,'1','Compliant')
            ,'2','Non compliant')
            ,'4','Succesfully installed updates')
            ,'5','Pending restart')
            ,'6','Failed to install updates')
            ,'7','Downloading updates')
            ,'8','Downloaded updates')
            ,'9','Failed to download updates')
            ,'10','Waiting for maintenance window before installing') as [State]
    from v_R_System,v_AssignmentState_Combined
    where v_R_System.ResourceID = v_AssignmentState_Combined.ResourceID and
    v_AssignmentState_Combined.AssignmentID = ('629') --Change it with proper assigment ID

    Monday, September 23, 2019 1:44 PM
  • Hello,
     
    > I have chekced report- Software update A,B,C,D,E these are updated on last year only what should i do please suggest me.
     
    Are you talking about the "Date Modified" of the reports? Don't worry about it, it is irrelevant to the results it brings. Just run it and check if the result is what you want.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, September 24, 2019 8:50 AM