SCCM Configmgr 2012 Report Get the Status of Software Update Scan results

In this blog post,I will show you ,how to know /monitor the clients with software update scan status results .

For patch management,all Configmgr Managed clients should do successful software update scan else,client will not be able to get updates from SCCM and thus ,SUP compliance go down the SLA.

I looked at the default reports to check if there is any such report to get count of clients that performed successful scan ,not successful scan and how many do not even report anything about scan.

I come up with nice SSRS Report gives you count of clients with success SU Scan,Failed and client that do not report anything.

All the counts in the report have linked report means,you can get list of clients for troubleshooting why they failed.

Software update scan results stored in v_updatescanstatus ,with LastErrorCode='0' considered as success and rest are considered as failed.

Download the RDL files from TechNet Gallary,uploaded all the reports to your SSRS Folder (make sure you uploaded all these files into same folder as they are linked) and change the data source before you run them.

Note:All these reports filtered with criteria DATEDIFF(dd,sys.Last_Logon_Timestamp0,GetDate()) <30 (computers did not logged into domain during last 30 days will not be reflected in this report ,I feel that ,no point looking at these computers since they are not on the network) and no other filters added like OU limitation /Server limitation etc. If at all you want,you can customize the RDL File.

Uploaded to your folder:

image

Software Update Scan Results:

image

Linked report- List of client SUScan Failed:

image

List of Client NoSUScan:

This report includes clients with no sccm client and you are required to get the client install on all computers with client=No.

image

Hope this report will help you to get some idea how the client are doing with respect to Soft update Scan  ,from this point,you can start troubleshooting the failed clients.

Feel Free to share your feedback via comments section .

8 Responses to "SCCM Configmgr 2012 Report Get the Status of Software Update Scan results"

  1. I do not understand very well the difference between your reports, and the OOTB report "Scan 1 - Last scan states by collection". Could you explain it further?

    Un saludo,

    Pablo

    Reply
    1. default reports do not provide any additional information like last software update scan,last hardware inventory etc. Did you run the reports available on the blog compared to default reports ?

      Reply
    1. i downloaded the zip file from Technet gallary,imported the reports into SSRS folder,change the data source and run the report.it works fine for me.
      No errors at all.
      you can edit the RDL,copy the sql code from app dataset and execute it to see if anything wrong.

      Reply
  2. Hi Eswar,

    Thank you for this !

    I was looking for this report specifically, unfortunately it is throwing me below error (both the reports).

    An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset 'App'. (rsErrorExecutingCommand)
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    I have changed the datasource as mentioned & still getting this error. When the query is ran individually, it is executing & displaying results.

    Any help around this will be much appreciated.

    Thanks,
    Abhijeet Manurkar...

    Reply

Leave a Reply