Moderated by: Sponsored by:
Episode 5: How to Use SCCM to Collect Microsoft SQL Server Editions, Oracle Applications and Many More
e= cm 2
Rod Trent, CEO, myITforumMay 24, 2012
• SCCM Guru – The Genius Series ( e=cm2 )
• ConfigMgr inventory pain points• How to collect additional information• Join the Beta program• Wrap-up and contest
Agenda
2
• ConfigMgr 2007 (and CM2012) pulls in an enormous amount of inventory data (it does it’s job)– In most cases
• 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
• <seinfeld mode on> Adobe! </seinfeld mode off>
ConfigMgr Pain Points Data Confusion
• How to identify software from Add/Remove
and EXEs
• How to identify software suites
• How to get ready for Windows 7 migration
Last Webcast
•SCCM is a great operational solution
•But enterprises want to do more:– Software Asset Management– License Compliance– Supporting True-ups
• Did I mention Adobe?
Challenges
Architecture
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
Inventory Process
DeploymentProcess
Normalization
Normalization Process
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
Inventory Process
DeploymentProcess
From Data to Information
1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP
8
• Normalize CM is able to identify all software data captured by SCCM
• But, Normalize CM is limited by the data collected by SCCM
• What about the data missed by SCCM?
Normalize Dependencies
• Everything leaves a “Fingerprint”– Data Sleuthing
• For example:– SQL Server Edition
• Edition not collected• Not in Add/Remove or .EXE• Available to WMI / MSSQL queries
– Oracle Database• Not identified• No Add/Remove, no .EXE• Available to XML file / Oracle SQL queries
What is Missed
• Search, Read:– Open and Close XML Files– WMI Key/Value– Registry Key/Value– Windows Services– Running Processes– Open Ports
• Open, Execute, and Close SQL
SCCM Required Capabilities
Extending Discovery (Step 1)
Normalization Process
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
• Extended data • Extended data • Extended data
Inventory Process
DeploymentProcess
New recurring advertisement
Extending Collection (Step 2)
• Add/Remove• File information
Normalization Process
Inventory Process
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
DeploymentProcess
New recurring advertisement
• Extended data • Extended data • Extended data
• Extended data
• Extended data
• Recurring advertisement– 1 package: Python scripts, OS independent, no .Net/Java
dependencies– 1 configuration file containing rules for each fingerprint– Schedulable– Size ~2MB– No agent. Zero footprint. No Win Services. No external
communication.– Run by CM agent within the CM cached folder– Results stored in the WMI space
• Results collected by the standard SCCM Hardware Inventory collection– Requires MOF file extension
Low Impact Collection Engine
From Data to Information
1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP
15
• Uses existing SCCM infrastructure• Extends the depth of SCCM inventory
collections• Now you can use SCCM for:
– Software Asset Management– License Compliance– Supporting True-ups
Benefits
BDNA Normalize CM
Hardware and software inventory data
Normalized hardware and software information
• BDNA has developed more than 150,000 fingerprints over 11 years– Multi-platform: Windows, Unix, Linux, Mac...
• BDNA is bringing this knowledge to the SCCM community– Increasing the value of customers’ investment
in SCCM and BDNA Normalize CM
Normalize CM: Technopedia
Fingerprint – Priorities
Manufacturer Product Name Attribute 1Microsoft SQL Server, Office, Windows, Visual,… Installed with MSDN ?Microsoft BizTalk EditionMicrosoft Exchange Server EditionMicrosoft Forefront Server Microsoft ISA Server EditionMicrosoft Lync Server EditionMicrosoft Office Multi Language Pack Microsoft SharePoint Server EditionMicrosoft SQL Server Edition / Windows Auth or Mix Mode / SA account
Microsoft System Center Configuration Manager Server w/SQL
Microsoft System Center Data Protection Manager Server Edition
Microsoft System Center Management Suite Edition
Microsoft System Center Operations Manager Server Edition
Microsoft Visual Studio w/MSDN EditionMicrosoft Windows Terminal Server Administration mode or Application mode ?
Oracle All Products Oracle Database Edition / ComponentQuest Toad for Oracle Edition / Components / Trial
• Test it today
• Send us the list of wanted Fingerprints
• Email [email protected] with Fingerprints in the
subject line
Join the Beta Program
20
• 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 June 10, 2012 at 11:59pm Pacific Time
Can You Solve e=cm2 ?
21
Get It Now!
22
http://sccm.bdna.com