moderated by:sponsored by: episode 1: introducing bdna normalize cm e=cm 2 rod trent, ceo, myitforum...
TRANSCRIPT
Moderated by: Sponsored by:
Episode 1: Introducing BDNA Normalize CM
e = c m 2
Rod Trent, CEO, myITforumApril 5, 2012
• 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!
Agenda
2
• 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
ConfigMgr Pain Points Data Confusion
3
• 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 Requirements
4
• 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
Community Driven Specifications
5
BDNA Normalize CM
Hardware and software inventory data
Normalized hardware and software information
6
From Data to Information
1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP
7
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
John Nelson, First Genius
14
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.
The Genius Series - bdna.com/genius
15
• 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
Can You Solve e=cm2 ?
16
• 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
Come See Us at MMS
17