180 likes | 635 Views
e=cm 2. Episode 1 : Introducing BDNA Normalize CM. Rod Trent, CEO, myITforum April 5, 2012. Agenda. SCCM Guru – The Genius Series ( e=cm 2 ) ConfigMgr Inventory Pain Points Community Involvement in the Solution BDNA Normalize CM for SCCM 2012 John Nelson, First Genius – Case Study
E N D
e=cm2 Episode 1: Introducing BDNA Normalize CM Rod Trent, CEO, myITforum April 5, 2012
Agenda • SCCM Guru – The Genius Series ( e=cm2 ) • ConfigMgr Inventory Pain Points • Community Involvement in the Solution • BDNA Normalize CM for SCCM 2012 • John Nelson, First Genius – Case Study • Wrap-up and !Contest!
ConfigMgr Pain Points Data Confusion • ConfigMgr 2007 (and CM2012) is pulling in an enormous amount of inventory data (it does it’s job) • Sifting through data and applying proper categories and taxonomies is time consuming and costly • Piecing the right information together is near impossible • Hardware revision/level/age, Software, Operating System, True-ups, Windows 7 migrations • A real world example • Office/Department data gathering
Community Requirements • Scalable: Processes millions of rows of SCCM data in minutes • Available: Available within ConfigMgr console • Actionable: Makes the data actionable (WQL) • Current: Daily catalog refreshes • Focused: Supports key initiatives: Windows 7 migration, Software asset management, Supportability/obsolescence
Community Driven Specifications • Normalizes and enriches millions of rows of SCCM data in minutes • Stores normalized data in ConfigMgr database • 2 new WMI classes created: BDNA_HARDWARE_DATA, BDNA_SOFTWARE_DATA • Uses the Microsoft SDK and the Management Point API • No SQL injection • Normalize CM doesn’t break the ConfigMgr support policy • Uses ConfigMgr hierarchy • Support n-level of Primary Servers • Extract raw data from Central Server, send normalized data to each Primary Server. • Provides Queries / Collections / SSRS Reports • 150 Queries, 30 Collections, 100 SSRS Reports • Refreshes catalog • Daily updates for missing entries • Download and install new catalog automatically
BDNA Normalize CM Normalized hardware and software information Hardware and software inventory data
From Data to Information 1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP
John Nelson, First Genius Case Study • Project: Windows 7 Migration, Software Management • 350,000 machines • Impact on ConfigMgr: • Installation of an ISV certificate • Update of the SMS_DEF.MOF • Database: 1 kb for hardware, 10 kb for software per machine. • Installation time: 40 min
The Genius Series - bdna.com/genius April 12th • How to identify software from Add/Removes and EXEs. April 26th • How to identify software suites. May 3rd • How to get ready for Windows 7 migration. May 10th • Use SCCM to collect Microsoft SQL Server Editions, Oracle applications and many more.
Can You Solve e=cm2 ? • Are you an SCCM genius? Are you a WQL wizard, are you SQL savvy? Test your SCCM skills now! • Enter the BDNA Normalize CM Genius Contest and win a new unlocked Nokia Lumia 900 Windows phone or a Microsoft Xbox Kinect Sports bundle. • Go to http://www.bdna.com/contest and start solving the questions now! Official rules listed there. • Contest ends on April 30, 2012 at 11:59pm Pacific Time • Winners will be announced by Brad Anderson on his SCCM GURU Webcast on May 2, 2012 www.bdna.com/sccm-guru
Come See Us at MMS • Booth #551 – next to the myITforum booth • Wear your SCCM GURU tshirt and win! • Get your SCCM JUICE energy shot • Don’t miss us in the Microsoft Sponsor Theater, Expo Hall Booth #450 on Thursday, April 19 at 11:00am
Get It Now! http://sccm.bdna.com