Solved

SCCM Report on Specific Collections Totals

Posted on 2013-11-22
2
162 Views
Last Modified: 2014-10-30
Our Project Managers want to track the progress of our Windows 7 x64 upgrades by SCCM site. I'm trying to find or create a report that will show them the following 4 columns:

Site Code | All Windows Workstations Total | All W7 x64 Total | % Machines Upgraded

The request seems simple enough and we have collections set up by Site Code already that contain these totals. I just need to collect the totals and pull them into one report.

Is there an existing report I can use as a template, or one I could copy and modify that is similar to this request? The closest I could find was "Count Operating System Versions", but this report doesn't break down by Site Code or Collection (just OS).

My skills are also limited in Report Builder, but if someone can point me in the right direction, I've been pretty good at getting these custom reports to work.

Thanks again!

mnat
0
Comment
Question by:mnat1201
  • 2
2 Comments
 
LVL 31

Expert Comment

by:merowinger
ID: 39850437
Maybe this helps? Just replace Collection X and Collection Y with the real Collection names
It just combines the Count of specific Collections in on Report:
Select (
select COUNT(*) 
from v_FullCollectionMembership FULLC
INNER JOIN v_Collection COLL ON COLL.CollectionID = FULLC.CollectionID
WHERE COLL.Name = 'Collection X') as 'All Windows Workstations Total'
,
(select COUNT(*) 
from v_FullCollectionMembership FULLC
INNER JOIN v_Collection COLL ON COLL.CollectionID = FULLC.CollectionID
WHERE COLL.Name = 'Collection Y') as 'All W7 x64 Total'

Open in new window

0
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 39859019
any update?
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

When you are trying to access the server, have you ever encountered "The terminal server has exceeded the maximum number of allowed connection" error?  or "The user is attempting to log on to a Terminal Server in Remote Administration mode, but the …
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

809 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