1 / 22

Episode 5: How to Use SCCM to Collect Microsoft SQL Server Editions, Oracle Applications and Many More

e=cm 2. Episode 5: How to Use SCCM to Collect Microsoft SQL Server Editions, Oracle Applications and Many More. Rod Trent, CEO, myITforum May 24, 2012. Agenda. SCCM Guru – The Genius Series ( e=cm 2 ) ConfigMgr inventory pain points How to collect additional information

kendis
Download Presentation

Episode 5: How to Use SCCM to Collect Microsoft SQL Server Editions, Oracle Applications and Many More

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. e=cm2 Episode 5: How to Use SCCM to Collect Microsoft SQL Server Editions, Oracle Applications and Many More Rod Trent, CEO, myITforum May 24, 2012

  2. Agenda • SCCM Guru – The Genius Series ( e=cm2 ) • ConfigMgr inventory pain points • How to collect additional information • Join the Beta program • Wrap-up and contest

  3. ConfigMgr Pain Points Data Confusion • 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>

  4. Last Webcast • How to identify software from Add/Remove and EXEs • How to identify software suites • How to get ready for Windows 7 migration

  5. Challenges • SCCM is a great operational solution • But enterprises want to do more: • Software Asset Management • License Compliance • Supporting True-ups • Did I mention Adobe?

  6. Architecture Inventory Process Deployment Process • Add/Remove • File information • Add/Remove • File information • Add/Remove • File information

  7. Normalization Inventory Process Normalization Process • Add/Remove • File information Deployment Process • Add/Remove • File information • Add/Remove • File information • Add/Remove • File information

  8. From Data to Information 1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP

  9. Normalize Dependencies • 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?

  10. What is Missed • 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

  11. SCCM Required Capabilities • Search, Read: • Open and Close XML Files • WMI Key/Value • Registry Key/Value • Windows Services • Running Processes • Open Ports • Open, Execute, and Close SQL

  12. Extending Discovery (Step 1) Inventory Process Normalization Process • Add/Remove • File information Deployment Process New recurring advertisement • Add/Remove • File information • Add/Remove • File information • Add/Remove • File information • Extended data • Extended data • Extended data

  13. Extending Collection (Step 2) Inventory Process Normalization Process • Extended data • Add/Remove • File information Deployment Process • Extended data New recurring advertisement • Add/Remove • File information • Add/Remove • File information • Add/Remove • File information • Extended data • Extended data • Extended data

  14. Low Impact Collection Engine • 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

  15. From Data to Information 1 Machine - Machine Name: ACME480, Machine ID: 480, Serial Number: 3Z8UCB1, OS: Windows XP

  16. Benefits • 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

  17. BDNA Normalize CM Hardware and software inventory data Normalized hardware and software information

  18. Normalize CM: Technopedia • 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

  19. Fingerprint – Priorities

  20. Join the Beta Program • Test it today • Send us the list of wanted Fingerprints • Email sccm@bdna.comwith Fingerprints in the subject line

  21. 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 June 10, 2012 at 11:59pm Pacific Time

  22. Get It Now! http://sccm.bdna.com

More Related