Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I get SCCM 2012 Software Update Reports?

Posted on 2015-02-08
3
Medium Priority
?
2,171 Views
Last Modified: 2015-02-10
Points of My Scenario:
1. Compliance requires reports on Windows software updates.
2. I am replacing WSUS with SCCM 2012's Software Update Point - as required by management, hoping to achieve a more efficient way of managing Windows updates.
3. WSUS reports were great (or at least, quite adequate) for Compliance purposes.

QUESTION: How can I get similar reports from SCCM 2012 with Software Update Point? Reports need to show server listing and outstanding patches (zero, when 100% patched) - similarly to WSUS. If not possible, just please advise me on what's the best I can do with SCCM 2012 with SUP - on reporting updates status.
0
Comment
Question by:waltforbes
3 Comments
 
LVL 24

Assisted Solution

by:Nagendra Pratap Singh
Nagendra Pratap Singh earned 1000 total points
ID: 40597640
Open the reporting section SCCM console and search for "Update". You will find all the reports.

SCCM reports are more advanced than WSUS reports. You can have multiple update lists etc and create report for them separately.
0
 
LVL 19

Accepted Solution

by:
Mike T earned 1000 total points
ID: 40598056
Hi,

Nagendra is correct - SCCM has far better reports than WSUS. Reporting needs to be configured though.
Go to the Monitoring node and you will see Reporting. Expand it and click Reports and wait. If you have it configured and working there will be a delay whilst SCCM queries the Reporting database - note reports are setup and live in a smaller, separate SQL database to the main site database.

If you eventually have "No items found" then you need to do a little work. Go to the Startmenu and open SQL group under Configuration Tools and start Reporting Services Configuration Manager.

This tool needs to be configured for reporting to work. It will tell you the name of the website portal it is using, under Report Manager URL. The default is http:\\yoursQLserver:80\Reports.

Open that and you will see your site code. Click the link to see all report groups. There are five whole groups for updates.

Software Updates  - A Compliance
Software Updates  - B Deployment
Software Updates  - C Deployment states
Software Updates  - D Scan
Software Updates  - E Troubleshooting

You probably want "C" or "A".

Note the web interface is not friendly at all, so you need to get those reports appearing in the console which is much easier to use.

Check first and let us know. SQL reports (aka SSRS) is a whole book all of its own!

Mike
0
 

Author Closing Comment

by:waltforbes
ID: 40602112
Excellent, Nagendra & Mike! I had to:
1. Install Reporting Services Point
2. Access Monitoring\Overview\Reporting\Reports: there is the GOLD! :-)
3. "Compliance 1 - Overall compliance" (Software Updates - A Compliance) is my pick, like Mike T suggested.

I am much grateful to you both!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question