Reddit reviews System Center Configuration Manager Reporting Unleashed

I recommend this book if you want to learn reporting,

https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/ref=sr_1_1?ie=UTF8&qid=1492794459&sr=8-1&keywords=sccm+reporting

You know, to save Garth from having to self-promote here I'll do it for him: https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789

Build a lab.

​

Build a lab.

​

Build a lab.

​

Build. A. Lab.

​

SCCM is a HUGE beast in and of itself...just learning the various ways to deploy applications/packages (and knowing the difference between the two and when to use one over the other) takes a bit of practice. Then understanding Task Sequences (a bunch of steps for completing a job...useful in imaging machines), and then finally going into learning Reporting...how to build queries and groups of users and pcs, based on certain parameters you define.

​

And that is just for the PC side. SCCM also can manage Macs as well as Mobile Devices.

​

And it has it's own Powershell module.

​

Intimidating? Yes.

​

Here are three tips, off the cuff I can give you (I am a current SCCM admin for a global firm).

​

1 - Build a lab. Make sure your pc has lots of processor cores, lots of RAM, and a decent size hard drive because all of your lab machines will be VMS. Plan on hosting about six to ten machines (with at least two being pc vms. You want to similate an environment.

​

2 - Take a video course from Udemy or another suitable online provider. I recommend this one. If you hop on the sale right now, it's $12 bucks. https://www.udemy.com/system-center-configuration-manager/

​

3 - Buy some SCCM books. Two that I recommend are:

System Configuration Manager Current Branch

System Configuration Manager Reporting Unleashed

Excellent to go over the basics of SCCM as well as more in depth stuff.

​

4 - Take your time, learn what you can, show it off...volunteer to take on SCCM tasks at your current place. If they don't want to let you in, because of security issues or protocols, dust off the resume and go to town!

​

​

Well first you never use tables you only use views.

Secondly, this book is a good starting point to learn reporting for SCCM.

https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789

Also MMSMOA is a great conference to learn SCCM and reporting.

https://mmsmoa.com/

System Center Configuration Manager Reporting Unleashed https://www.amazon.com/dp/0672337789?ref=yo_pop_ma_swf

I’ve always struggled with reporting stuff, since most sql specific things never focus on configmgr for obvious reasons. This book does a great job of focusing on legitimate things we actually do in sql. Highly recommended.

Anything is possible with enough case statements and/or subqueries ;)

Read the below linked book to obtain real world reporting skills you can apply to ANY reporting scenario or platform.

System Center Configuration Manager Reporting Unleashed https://www.amazon.com/dp/0672337789/ref=cm_sw_r_cp_apa_Ktc0Ab2RXXHK1