1 / 36

A Deep Dive into SCCM Data - Bring Your Snorkel!

A Deep Dive into SCCM Data - Bring Your Snorkel!. Garth Jones March 14, 2012. Agenda. Welcome : Ron Crumbaker, CTO, myITforum Overview : BDNA & myITforum Garth Jones A Deep Dive into SCCM Data! Bring Your Snorkel! Wrap Up : Rod Trent, CEO, myITforum Tshirts & MMS Conference Pass Winner.

heaton
Download Presentation

A Deep Dive into SCCM Data - Bring Your Snorkel!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Deep Dive into SCCM Data - Bring Your Snorkel! Garth Jones March 14, 2012

  2. Agenda • Welcome: Ron Crumbaker, CTO, myITforum • Overview: BDNA & myITforum • Garth Jones • A Deep Dive into SCCM Data! Bring Your Snorkel! • Wrap Up: Rod Trent, CEO, myITforum • Tshirts & MMS Conference Pass Winner

  3. Google+ Hangouts & Forums • Reed Porter’s Hangout: http://tinychat.com/reedracer password: welcome • myITforum SCCM GURU webcast live forum http://myITforum.com/SCCMguru • #sccmguruhashtag on twitter

  4. BDNA Normalize for ConfigMgr™ • NEW PRODUCT: BDNA Normalize CM™ • Extracts ConfigMgr inventory data • New native classes to use in console • Create queries, collections and reports • Demo on website: http://sccm.bdna.com • Download trial version, free for 60 days Pradeep Bhanot Product Marketing BDNA Normalize for ConfigMgr™

  5. myITforum • Ron Crumbaker, myITforum • All things “System Center” • Since 1999 • Large and growing community (over 120,000 visitors a day) • Huge storehouse of System Center knowledge • Noobies to experts

  6. About Garth Jones • Chief Architect of Enhansoft • SCCM MVP since 2007 • Current President of SMSUG.ca • Past President of OWSUG.ca

  7. Do You Want Reports Like This?

  8. How About This One? Diving Deep in the SCCM data!

  9. How About This One? Diving Deep in the SCCM data!

  10. You Need 3 Reports! Diving Deep in the SCCM data! • What is a Bad Report? • What is a Good Report? • Count of Whatever • List of PCs with Whatever • PC details for Whatever

  11. What is a Bad Report?

  12. What is a Good Report?

  13. Drill Down Diving Deep in the SCCM data!

  14. 3 Reports Demo • Count Report • List Report • Computer Details Report

  15. What To Do with a Bad Report!

  16. Just Say NO!

  17. When a Manager Says: • I MUST have a list of all software installed on all PCs • Just Say No! • I need this report to have 50 columns • Just Say No!

  18. All Software for All PCs • Assuming 80 lines of text / page • Each page is double sided • There are 500 sheets of paper in a bundle of paper! (((# of PCs) * (average # of rows within ARP)) / 80 lines ) / 2 (double sided) = total number of pages for the report.

  19. I Feel Like an Accountant! Let’s Do Math! • 80 lines of text / page • Each page is double sided • 500 sheets of paper in a bundle of paper! • My test lab has 41 PC • Ave 134 ARP entries / PC (((41) * (134)) / 80 lines ) / 2 = 34.3 Pages

  20. When Management Asks for a RIDICULOUS Report (and they will!): • Ask them why they need it? • Who will read it? • How is it going to be used? • What EXACTLY do they need each column? • How often is this report likely to be used? • What decision will be make with the data?

  21. Things to Consider When Creating a Report • Will all columns of data fit on one page? • Does it contain data that will cause duplicate rows? • IP Address • Hard Drives • CPU • Does it have too many Columns? • Is this a one off Report? • Is the report “doable” • You are the Technical Expert!

  22. KISS • Keep it simple & stupid • One table per report • Don’t for get about Charts! • No more that 8 columns

  23. SSRS Tools • Report Builder 1.0, 2.0, and 3.0 • SQL Server Business Intelligence Development Studio 2005 & 2008 • Which do I use?

  24. Where is the MEAT? Ribs from the Foolish Chicken! www.FoolishChicken.ca

  25. How Do I Make Them Look Pretty? Demo

  26. What Did We Learn? • How to recreate reports for all version of SSRS • Creating template reports • How to have alternating row colors within • How to add a chart to a report • How to add a link to a web page • How to add a drill down to another report

  27. Resources for Attendees Diving Deep in the SCCM data! • Create 3 Base templates for SSRS • 8.5 x 11, 11 x 8.5, & 14 x 8.5 • Set the printed page size to match the layout • Add your Company’s logo to the reports. • Take a T-SQL course • Take a SSRS design course

  28. Wrap Up with Rod Trent • Questions for Garth?  Please write them in your Q&A box on the right column of your screen

  29. Next SCCM GURU Webcast • Wednesday, March 28, 2012 • Nick Moseley  www.bdna.com/sccm-guru

  30. SCCM GURU Community Group http://myitforum.com/myitforumwp/groups/bdna/

  31. iTunes Podcasts & Videos SCCM Guru Webcast Series under Technology – Software How-To http://itunes.apple.com/us/podcast/sccm-guru-webcast-series/id491938468

  32. SCCM GURU YouTube Channel http://www.youtube.com/BDNAcorp All SCCM GURU webcast replays posted here!

  33. SCCM GURU Swag Store http://www.cafepress.com/BDNA

  34. Thanks for attending! To thank you for participating in our SCCM GURU webcast, we’d like to offer EVERYONE on the webcast a super cool SCCM GURU Webcast T-shirt. Please register here:  www.bdna.com/garth

  35. MMS Conference Pass Winner • Scott Ewing, Unum See you in Vegas, Scott!

  36. Questions, Contact Info For more information… BDNA Normalize for ConfigMgr™ http://sccm.bdna.com sccm@bdna.com myITforum Rod Trent rodtrent@myitforum.com +1 (513) 217-7122

More Related