Microsoft System Center Operations Manager 2007 R2: Service Levels, Reports, Dashboards, Report Authoring, and More!

1. SESSION CODE: MGT311 Microsoft System Center Operations Manager 2007 R2: Service Levels, Reports, Dashboards, Report Authoring, and More! Chris Harris Program Manager Microsoft Corporation

2. Agenda • Overview • What’s new since R2? • Report Authoring Scenarios • Demos, Demos, Demos, Demos • (and samples!) • Questions and Answers

3. Overview Data Warehouse and Reporting • Near zero latency data available for reporting • Data warehouse optimized for fast query access • Indexed, Partitioned, Aggregated, Groomed • Rich out of the box reporting • View, Publish, Export, Schedule, Print, Favorites • Data warehouse consolidation • Multiple Management Group support • Report/Data customization and extensibility • Report Models, SQL View access, Visual Studio Support Get access to your data easily with minimal effort

4. What’s new since R2? Daniel Savage Senior Program Manager Microsoft demo

5. Operational Data Reporting (ODR) • Call to Action: Enable ODR and help us make MPs better For more information: http://blogs.technet.com/momteam/archive/2010/03/15/help-us-help-you-operational-data-reporting.aspx

6. What’s NewRecap • MP’s now shipping with Filters • SQL • Exchange • Windows • Operations Manager MP Reports – blog link • Data volume by Management Pack • Data volume by Workflow Instance • ODR (Operational Data Reporting) • Alerts per day • Instances

7. What we heard…… • “I need to report on how often my servers were in maintenance mode” • “Why does Visual Studio seem the only option for creating the reports I need?” • “Can we use operations manager for capacity planning?” • “Dashboard reports that show a lot of general info…..” • “How do I make reports pretty….”

8. Reporting Lifecycle

9. Authoring Resources • Authoring Options, Walkthroughs, Sample Queries and Schema Reference: • http://technet.microsoft.com/en-us/library/dd362600.aspx • Samples, Guidance and New Updates • http://blogs.technet.com/momteam/archive/tags/Reporting/default.aspx Reducing the cost of getting information to key stake holders

10. Performance Reporting – Easy as 1,2,3 • “I need to produce a report that shows the processor, memory, logical disk performance for my 100 servers and I need to see the average performance over multiple time ranges.”

11. Performance Reporting – Easy as 1,2,3 demo

12. Performance Reporting – Easy as 1,2,3Recap • Use service level objectives to target appropriate performance counters • Group servers by OS to match performance rule targeting • Server 2008 , Server 2003 to match MP rules • Service Level dashboard becomes a self service portal for performance reporting

13. Outage Analysis • “How do I build a report showing detailed information about how much time servers spent in maintenance mode and what happened during that time?”

14. Outage Analysis demo

15. Outage AnalysisRecap • Write your SQL query • Create a new report in Report Builder • Add a DataSource • Create a new DataSet based on your SQL query • Create a matrix to show the data • Update the design and formatting • Upload the report

16. Virtualization Candidates • “My manager wants a report showing physical servers in the environment that are the most suitable candidates for virtualization over a period of time.”

17. Virtualization Candidates demo

18. Virtualization CandidatesRecap • Group servers by OS and properties • # of Procs, Memory etc. • Create rules around virtualization criteria • Create SLOs to target performance rules with virtualization criteria • Publish report to enable on-going evaluation

19. Forecasting Report • “I desperately need a report I can show management that will justify my request to purchase new hardware. Specifically, I need to show which servers may need additional SAN storage in the next 6 months.”

20. Forecasting Report demo

21. Forecasting ReportRecap • SQL forecasting algorithms readily available • http://www.sqlservercentral.com/articles/T-SQL/69334/ • Create stored procedure to tie performance data to forecast • Create report in Visual Studio from stored procedure • Package in MP

22. Q&A

23. Call To Action and Resources • Evaluate & Deploy Operations Manager 2007 R2 • Hosted labs • Download 180-day Evaluation Versionhttp://www.microsoft.com/systemcenter/en/us/operations-manager/om-try-it.aspx#downloads • Get Trained - Microsoft Courseware • Learning Resources at http://technet.microsoft.com/en-us/systemcenter/om/bb499676.aspx • Find certifications and training at http://bit.ly/bgpQl1 • Get Involved in the Community • Product Team Blog: http://blogs.technet.com/momteam • Support Team Blog: http://blogs.technet.com/operationsmgr • Twitter: Follow #mpreleaseshashtag for updates on management packs

24. Management Track Resources • Don’t forget to visit the Management TLC area (Red Section) to see product demos and speak with experts about the System Center solutions • You can also find the latest information about the System Center products at the following links • System Center Site – http://www.microsoft.com/systemcenter/ • System Center Community –http://www.microsoft.com/systemcenter/en/us/community.aspx • TechNet Home Page – http://technet.microsoft.com/en-us/systemcenter/ • TechNet Community – http://technet.microsoft.com/en-us/systemcenter/cc511266.aspx

25. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

26. Required Slide Complete an evaluation on CommNet and enter to win!

27. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

28. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

29. Required Slide