moderated by:sponsored by: episode 5: how to use sccm to collect microsoft sql server editions,...
TRANSCRIPT
![Page 1: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/1.jpg)
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
![Page 2: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/2.jpg)
• 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
![Page 3: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/3.jpg)
• 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
![Page 4: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/4.jpg)
• How to identify software from Add/Remove
and EXEs
• How to identify software suites
• How to get ready for Windows 7 migration
Last Webcast
![Page 5: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/5.jpg)
•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
![Page 6: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/6.jpg)
Architecture
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
Inventory Process
DeploymentProcess
![Page 7: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/7.jpg)
Normalization
Normalization Process
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
• Add/Remove• File information
Inventory Process
DeploymentProcess
![Page 8: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/8.jpg)
From Data to Information
1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP
8
![Page 9: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/9.jpg)
• 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
![Page 10: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/10.jpg)
• 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
![Page 11: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/11.jpg)
• 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
![Page 12: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/12.jpg)
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
![Page 13: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/13.jpg)
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
![Page 14: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/14.jpg)
• 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
![Page 15: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/15.jpg)
From Data to Information
1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP
15
![Page 16: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/16.jpg)
• 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
![Page 17: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/17.jpg)
BDNA Normalize CM
Hardware and software inventory data
Normalized hardware and software information
![Page 18: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/18.jpg)
• 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
![Page 19: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/19.jpg)
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
![Page 20: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/20.jpg)
• Test it today
• Send us the list of wanted Fingerprints
• Email [email protected] with Fingerprints in the
subject line
Join the Beta Program
20
![Page 21: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/21.jpg)
• 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
![Page 22: 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,](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e2c5503460f94b1bb2c/html5/thumbnails/22.jpg)
Get It Now!
22
http://sccm.bdna.com