Solved

How do I get SCCM 2012 Software Update Reports?

Posted on 2015-02-08
3
322 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 23

Assisted Solution

by:Nagendra Pratap Singh
Nagendra Pratap Singh earned 250 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 16

Accepted Solution

by:
Mike T earned 250 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now