• My Operations Manager 2007 SQL Queries

    Jonathan Almquist started a blog post about Operations Manager 2007 SQL Queries.

    “I’m starting a new post here, similar to my Command Shell reference.  This will include some useful SQL queries that I happen to need and direct my customers to on a daily basis.  If you don’t see something here, check Kevin Holman’s blog.  He’s already got a library of useful queries posted, in which I will not duplicate here.

    I will continue to update this table periodically.  If you subscribe to my blog, you will receive each new example as I post it.”

    I also have some SQL queries I used at customers I want to share. Would be nice if we had some kind of Wiki where we could post all our OpsMgr SQL queries though ;-)

    OperationsManager OperationsManagerDW
      Logical Free Megabytes on Windows Server 2000 and higher
     

    % Logical Disk Free Space on Windows Server 2003

    List all Windows Computers  

    Total Number of Servers per OS

     
  • MMS 2009 first day Keynote announcements

    IMG_3022
    Bob Kelly (Picture by Andre Pronk)

    At the 10th annual Microsoft Management Summit this week in Las Vegas, Bob Kelly (Corporate Vice President, Server & Tools Business) outlined an infrastructure strategy to help IT customers understand their options as they incorporate “the cloud” into Microsoft’s future plans.

    Two Cloud models

    Bob talked about the Cloud, and Microsoft sees two models: The Public and a Private Cloud. According to Bob, Microsoft will be one of the few companies who delivers the Public Cloud with their Windows Azure platform.

    And secondly there is the Private Cloud which you should see as your internal Data Center. Think about Virtualization to conceptionalize what this means. Microsoft invests across their portfolio, everything from Windows, Forefront, System Center across optimizing your infrastructure and application platform, SQL, Biztalk, dotNet and SharePoint so they all have consistent and coherent API’s in the Private Cloud to the Public Cloud. Windows Azure is that implementation of that Microsoft stack in the Public Cloud. Microsoft took all those investments made in the On-Premise world and have taken those to the Public Cloud.  And what they have learned in the Public Cloud and bring that to the Private Cloud. That will give Microsoft  a unique position, in the way that there are very view companies that have the capacity and toolset to offer a platform that is deep and raw from Private Cloud to Public Cloud.
    Microsoft will extend their investments, from the learning's they have in the Public Site to what they are doing on the Private site to ensure they have a platform that spans those two worlds and allows you to take advantages of thinks like AD, Security Infrastructure and Microsoft Management Infrastructure across both of that Public and Private Cloud build on Windows Server and System Center.

    “Our goal is to give businesses the choice of running applications on-site, in the cloud or using a combination of the two,” says Kelly. “This hybrid model gives customers the best of both worlds — the scale and convenience of a public cloud and the control and reliability of on-premises software — and lets them move fluidly between the two based on their needs. It provides customers an on-ramp from their current IT environment to the cloud.”
    [Soundbite here 4:27 mins)

    Announcements:

    Building on its cloud computing strategy, Microsoft made several announcements yesterday:

    • System Center Operations Manager 2007 R2 will be available within 30 days.
      [Soundbite  here]
    • Availability of the Dynamic Datacenter Toolkit for Hosters [soundbite here]
      Enabling the Foundation for Hosting Partners
    • Availability of the Dynamic Datacenter Toolket for Enterprises (within 90 days)
      Enabling the Foundation for Private Clouds

    More announcements can be found on System Center Central. Keynotes will be also be available for live and on-demand viewing here

    Demo’s

    During the keynote the next products where used to show how they support Microsoft’s Cloud strategy:

    • Windows Server 2008 R2. With investments in Hyper-V, Live Migration, Remote Desktop Services, IIS 7.5, Integrated IIS Extensions, ASP.NET on Server Core, PowerShell Management, PowerShell 2.0 and BPA.
    • Virtual Machine Manager 2008 R2. With investments in Automation of Live Migration, VM migration in SANs, Hot storage management.
      Demo from Edwin Yuen about Managing the Fabric using a Visio Add-in to show Real Time Power Consumption and demoing Live Migration due to exceeding the Power Budget.

      Bill Morein demonstrated decoupling applications from the underlying operating system using application virtualization technology.

    • Operations Manager 2007 R2. With investments in Service level monitoring, cross platform monitoring, and live operational data in Visio diagrams.

      Lorenzo Rizzi (Principal Architect System Center Operations Manager) demonstrated Service Level Dashboard 2.0 Beta for OpsMgr 2007 R2.
      IMG_3051 
      SLDV2.0 (Picture by Andre Pronk)
  • Reblog: Announcing a New Program for System Center Influencers

    Source: Nexus SC

    Yesterday there was a new announcement at MMS 2009. A new program for System Center Influencers. This is a new community program that will give influencers—user group leads, MVPs, popular bloggers, and others recognized as influential in the community around System Center—the technical training content, people connections, and general guidance they need to enhance their credibility and impact in the community.

    Key Member Benefits

    • Access key content:  Members get access to the latest technical training content to help them enhance their expertise.   This also includes exclusive user group content.
    • Meet experts and peers in the community:  Members can stay connected with System Center-focused events, or let others know about their upcoming events.   Members can register and find events, as well as request speakers for upcoming meetings.
    • Grow in influence:  Members can learn about new opportunities to lead their communities on and offline, and find out about other opportunities to get more involved with Microsoft.

    This invitation-only program has its online home on Microsoft Connect, and offers or links to several different tools intended to support influencer needs. As this is very much a work in progress that is just getting off the ground, we are asking participants to help us develop the program and shape it in ways that are most relevant to the community.

    Who’s Eligible

    This program is intended for influencers of all kinds, or simply those who are looking for tools to become more influential in their communities. Our intention is not to supplant any existing influencer programs, such as the MVP program, but merely to complement and extend them, focusing specifically on the needs of the System Center (and soon: Virtualization) community.

    How to Find Out More

    If you are interested in this program, or have any questions about our tools, resources, or mission, please contact us at scnetsup@microsoft.com.

  • Become an MMS 2009 “Virtual Attendee”

    Source: MMS 2009 organization

    I just got an email from the MMS 2009 organization that’s possible to become an MMS 2009 “Virtual Attendee”.

    Maybe a could idea if your manager didn’t allow you to go to MMS 2009 this year.

    Ok, it’s still costs you (or your manager) $350, but that’s the same as 25 days internet in the Planet Hollywood hotel in Las Vegas ;-)

     

    “If you are unable to attend MMS 2009 in person this week, a new MMS 2009 Online” registration option has been created which provides access to the valuable session content being presented at this year’s MMS 2009 event - right from your desktop. 

    MMS 2009 Online - Features
    MMS 2009 Online” is an opportunity to access the MMS 2009 CommNet both during and after the event, just like attendees who are present at the event.  This option provides access to key content including:

    · Live Webcast of the MMS 2009 Keynotes*

    · Video Recordings of Breakout session topics**

    · Downloadable PowerPoint slide decks from the Breakout sessions

    · Hands-on Lab Manuals

    · Sample files shared by Speakers

    · Access to the MessagePoint system for online discussions with other attendees

    · Copy of the MMS 2009 Post-show DVD set mailed shortly after the event (a $275 value)

    · Copy of the MMS 2009 Hands-on Lab Walkthrough DVD mailed after the event (a $125 value)

    · Access to all MMS 2009 Online content for 3 months after the event closes

    Registration as an “MMS 2009 Online” Attendee costs $350 and provides online access to over 140 breakout topics as recordings and PowerPoint slide decks as well as 76 Hands-on Lab manuals.  The Post-show DVD set provides indexed recordings of all available Breakouts plus bonus materials and supplementary files from session speakers and Event Sponsors.  The Hands-on Lab Walkthrough DVD provides video recordings of the most popular lab topics offered at the event with audio commentary providing step-by-step explanations of the key procedures covered.

    *Note that the live webcasts of the MMS 2009 keynotes are not restricted to registered “MMS 2009 Online” Attendees.  Access to all other content is restricted to in-person and on-line attendees up to 3 months post-event.

    **Breakout session recordings for most topics will be posted within 24 hours of the live session.

    Full Session Details
    Full details of the sessions being offered at MMS 2009 this week are provided on the event site Sessions Page and in a downloadable Session Details PDF.

    “MMS 2009 Online” Registration
    The MMS 2009 Online registration package is available for only $350.  If you would like to register as an attendee of “MMS 2009 Online” click on the following link:

    · "MMS 2009 Online" Attendee Registration Site

    The username and password you create during registration will give you immediate access to all the online content available to attendees at the event – and without leaving your desk!

    Don’t miss out on the top IT Management event of 2009.  Register now!
    www.mms-2009.com

  • Following MMS 2009 on Twitter

    MMS 2009 is very close now and I’m getting ready to leave on Sunday for Las Vegas. More and more people are getting exited including me for this great event to learn about the latest IT Management Solutions from Microsoft.

    As you may know there is something new that’s called Twitter. If you still not know what Twitter is you are working too much ;-)

    Ok, I’ll explain once more. Twitter is a service for friends, family, and co–workers to communicate and stay connected through the exchange of quick, frequent messages. People write short updates, often called "tweets"  of 140 characters or fewer.  These messages are posted to your profile or your blog, sent to your followers, and are searchable on Twitter search.

    Quite some people in working in IT Management are already using Twitter and some of them will also go to MMS 2009. To name some:

    I also created a Twibe for MMS09.

    What is a Twibe?
    A Twibe is a group of Twitter users interested in a common topic who would like to be able to communicate with each other.  On each twibe's page, there is a list of twibe members.  There is also a tweet stream that lists tweets from Twibe members which contain key word tags. Tags are set by the Twibe founder and are listed just above the tweet stream.

    So if you are going to MMS 2009 join the Twibe and use the hashtag #mms209 for all tweets about MMS 2009.

    Hope to see you all at MMS 2009 in Las Vegas.

  • Remote Operations Manager 2007 to Be Retired

    The decision has been made to retire System Center Remote Operations Manager 2007. This means that there will be no further engineering investments or follow-on release to the product and it will retire from the SPLA price list by October 2009. However, the Remote Operations Manager management pack will be made publicly available in the System Center Operations Manager catalog on the Web, and partners can use this management pack with the SPLA version of Operations Manager 2007. No releases beyond Operations Manager 2007 SP1 will specifically provide support for the Remote Operations Manager management pack.

  • New downloads for OpsMgr 2007 R2 on Connect

    There are new downloads available for OpsMgr 2007 R2 on Connect.

    • Bulk URL Editor (BUE) for Operations Manager R2
      With Operations Manager 2007 R2, you can now monitor up to 1000 URLs per watcher node and 3000 URLs per management group. However, creating the monitors for that number of URLs has been time-consuming, as each monitor had to be created manually. The new Bulk URL Editor addresses this issue, enabling you to create multiple monitors at once.
    • Operations Manager 2007 R2 Interop Connectors
      This package contains the RC software for System Center Operations Manager 2007 R2 Interop Connectors.  The following Connectors are included:
      • Operations Manager 2007 R2 Connector for Tivoli Enterprise Console
      • Operations Manager 2007 R2 Connector for HP OpenView Operations
      • Operations Manager 2007 R2 Connector for BMC Remedy ARS
      • Operations Manager 2007 R2 Universal Connector

    Go to Connect and download the new stuff.

  • Reblog: Release: Veeam nworks 4.5

    Source: Gerben’s Blog On Virtualization

    Veeam released version 4.5 of it’s nworks monitoring management pack and plugin for Microsoft Operations Manager (SCOM2007 and MOM2005) and HP Operations Manager respectively.

    The key improvements in this release are:

    • support for larger VMware environments (more hosts & virtual machines)
    • less vcenter processing requirements
    • improvement on reliability, and better monitoring of critical events
    • officially certified as VMware Ready Optimized
    • focus on business, segmentation into line of business area’s by using custom attributes of vCenter in order to monitor SLA’s

    More info on Veeam.

  • TechNet Webcast: Operations Manager 2007 R2 Deployment and Upgrade Best Practices (Level 300)

    Source: Microsoft Technet

    Language(s): English.

    Product(s): Microsoft System Center Operations Manager.

    Audience(s): IT Professional.

    Duration: 60 Minutes

    Start Date: Wednesday, April 15, 2009 10:00 AM Pacific Time (US & Canada)

    Event Overview

    Join us for this informative session on deploying Microsoft Systems Center Operations Manager 2007, where you will gain useful insights into what worked, as well as what didn't, when deploying Operations Manager 2007 into different environments. You will have the opportunity to learn best practices for setup (including recommended approaches for disaster recovery and high availability), running Operations Manager in a virtualized environment, and more.
    Presenters: Rob Kuehfus, Setup and Deployment Program Manager, Microsoft Corporation

    Rob is  a Program Manager in the System Center Operations Manager product group.  Responsibilities include Setup, Deployment, Upgrade, AD Integration, High Availability, Disaster recovery, notification and maintenance mode.     Before coming to Microsoft, Rob has been working with MOM 2005 since late 2004 using it to monitor mission critical Active Directory, Exchange and Application environments.  Rob was a part of the Microsoft TAP program before coming to Microsoft and has been an early adaptor of System Center Operations Manager 2007.  Current certifications include MCSE 2003, CCNA, and ITIL foundations.

    View other sessions from: Managing a Microsoft Infrastructure: Improve Reliability and Performance

    If you have questions or feedback, contact us.

    Registration Options

    Event ID:
    1032409726

  • First MMS 2009 announcements

    Today was the first unofficial day of MMS 2009 in Las Vegas and here are some announcements:

    • Announcement of the launch of Opslogix. Their mission is to deliver Intelligent Management Packs for Microsoft System Center. No more hassle using converted packs or high maintenance connectors / services. They provide high quality native management packs at a very competitive price.
      Check out their free Ping Management Pack and read more about their Intelligent Management Pack for Blackberry
    • Launch of launched SystemCenterCentral.com.
      SystemCenterCentral.com has been founded by three System Center community members; Pete Zerger, Rory McCaw and Maarten Goet. SystemCenterCentral.com is a community initiative that will combine a number of existing internet properties under a single community site and strive to become the leading community landing page for all System Center technologies. Sites to be consolidated include Sytem Center Forum, Techlog and several user group sites, including http://wmug.co.uk

    Tomorrow is the first official day which starts with a keynote so there will more announcements tomorrow.

  • Reblog: Visio Add-in for Operations Manager 2007 R2 Beta released

    Source: System Center Operations Manager blog

    The Visio Add-in for System Center Operations Manager 2007 R2 combines the strengths of two applications widely used in enterprise IT to simplify the creation of customized graphical dashboards showing the health of an environment. Examples of such diagrams include showing objects by geography overlaid on a map, by location in a datacenter or building, by role in a logical view of an application or by topology for complex distributed applications such as Exchange or Active Directory. 

    The Visio Add-in has the following features:

    • Distributed applications exported from System Center Operations Manager 2007 R2 (release candidate) as Visio documents automatically show live health state information on the exported objects when opened in Visio.
    • You can easily create new Visio documents and link shapes to any managed object (computer, database, web site, perspective etc.) to show the current health state.
    • You can automatically link entire existing Visio documents to the computer and network devices managed by Operations Manager by matching computer names or IP addresses.
    • Health states can be automatically refreshed in Visio documents. You can use this option along with Visio’s full screen view to create dashboard views suitable for use as a summary display in a datacenter control room.
    • Predefined data graphics enable you to toggle from Operations Manager health icons to shape color for health state. 

    Download the Visio add-in at https://connect.microsoft.com/Downloads/DownloadDetails.aspx?SiteID=446&DownloadID=17995.
    (To get access to this release, apply to participate in the "Operations Manager Public Beta" at https://connect.microsoft.com/SelfNomination.aspx?ProgramID=2249&pageType=1&SiteID=446.)

    This looks quite like the solution Savision is offering with their Savision Live Maps.

  • System Center Operations Manager 2007 SP1 Internet Information Services 7.0 Monitoring support

    Source: Microsoft Download Center

    Brief Description

    This QFE updates the System Center Operations Manager 2007 Agent to allow it to monitor Windows Server 2008 Internet Information Services 7.0 Servers.

    System Requirements

    • Supported Operating Systems: Windows Server 2008
    • Other Software: System Center Operations Manager 2007 Service Pack 1

     

    Instructions

    Important Notice: A problem was found with this package, we are working on resolving it.
    This hotfix must be applied to each computer that meets the following criteria:

    • Hosts a Microsoft Operations Manager Root Management Server
    • Hosts a Microsoft Operations Manager Management Server
    • Hosts a Microsoft Operations Manager Gateway Server
    • Host a Microsoft Operations Manually Installed Agent (Discover-based agent deployment not used)

    To extract the hotfix files contained in this hotfix:
    1. Copy the file, SystemCenterOperationsManager2007-SP1-KB957123-X86-X64-IA64-ENU.MSI, to either a local folder or accessible network shared folder.
    2. Then run SystemCenterOperationsManager2007-SP1-KB957123-X86-X64-IA64-ENU.MSI locally on each applicable computer that meets the predefined criteria.
      You can run SystemCenterOperationsManager2007-SP1-KB957123-X86-X64-IA64-ENU.MSI from either Windows Explorer or from a command prompt.

    NOTE: To run this file on Windows Server 2008 you must run this file from a command prompt which was executed with the Run as Administrator option. Failure to execute this Windows installer file under an elevated command prompt will not allow display of the System Center Operations Manager 2007 Software Update splash screen to allow installation of the hotfix.
  • Time To Prepare For MMS 2009

    I just received an email from the MMS Event Team to prepare for MMS 2009. I’ve already done that, but if not please do as soon as possible.

     

     

    Email:

    First of all, many thanks for joining us at this year’s Microsoft Management Summit in Las Vegas.  As a registered attendee there are a number of ways you can prepare for the event, to ensure you get the most out of your week at MMS 2009. This email describes how to:

    · Vote for Birds-of-a-feather topics most relevant to you

    · Volunteer for Focus Group sessions with Microsoft Product Groups

    · Build your personal schedule for the week at MMS 2009

    · Book your Instructor-led Lab sessions prior to the event

    Last Chance to Vote for Birds-of-a-feather (BOF) Topics

    This year we will again be hosting BOF sessions on Tuesday and Wednesday evening after the final breakout sessions of the day. These informal community sessions allow small groups of attendees to meet and discuss a topic of common interest peer-to-peer or with Microsoft or Industry experts, covering questions on specific areas of IT management.

    To ensure that the topics hosted at these BOF sessions reflect the interests of all MMS 2009 attendees, we are asking you to vote for the topics you would prefer to attend or propose your own topic. On Friday night we will close the BOF Survey and the most commonly requested topics will then be scheduled and published to the CommNet web site.

    To vote for your preferred Birds-of-a-Feather session topics:

    • Log in to the MMS 2009 CommNet using the credentials you created during registration
    • Select “BOF Survey” in the left hand navigation pane
    • You may either:
      • Select from the dropdown list of most commonly requested topics so far

    or

      • Enter a new topic proposal, including rough abstract and optional speaker/moderator name for the session
    • Press Submit to enter your vote

    The selected BOF topics will be published to the MMS web site by end of day Tue, April 14th, allowing you to add them to your schedule via the “Schedule Builder” option.  Note that space is limited at these sessions, so early booking is advised.

    Volunteer for Product Focus Groups

    Are you interested in providing feedback to Microsoft product teams, to help them design future IT management products? We are seeking volunteers during MMS 2009 to attend Focus Groups run by Microsoft product teams. These sessions typically last only 1-2 hours and aim to gather information about your experiences and work scenarios, enabling future releases to address a broader range of customer scenarios.

    To help us identify the Focus Group sessions most relevant to you, we request that you complete a short on-line survey for each topic in which you are interested.  The survey questions ask about your experience, the products you use and your IT operations environment. You may volunteer for any number of product sessions which seem relevant to you.

    To volunteer for Focus Groups during MMS 2009:

    • Log in to the MMS 2009 CommNet using the credentials you created during registration
    • Select “Focus Groups” in the left hand navigation pane
    • Each of the Focus Group topics being offered during MMS 2009 are listed on this page
    • Click the icon clip_image003to the left of any Focus Group topic in which you would like to participate
    • Complete the survey for that topic

    Each survey should take only a few minutes to complete.  The deadline for submissions is April 14th at midnight PDT – but places will be allocated on a first-come basis, so we encourage you to complete the survey as soon as possible. Selected volunteers will be contacted approximately one week prior to the event to confirm participation.

    Time to Build Your Personal Schedule

    There is a massive amount of information available during the week of MMS 2009. To get the best out of the event we strongly suggest taking a few moments to plan your schedule by selecting the breakouts and labs most valuable to you. To help you with this process a number of session listings and on-line tools are available.

    A searchable detailed listing of all Breakout, Self-paced and Instructor-led Lab sessions is provided on the event web site Sessions Page and in a downloadable Session Details PDF. In addition a grid view of all the Breakout and ILL schedules is available in two page formats: Session Grid (11”x17”) and also Session Grid (Legal).

    Since there may be some schedule changes or updates prior to the event, we suggest that you monitor the MMS News RSS feed. Any new topics or changes to existing sessions will be posted here, as well as being reflected in the Session Links above. The “MMS News” page will also provide updates and general information about the event up to and during the event itself.

    How to Log On and Build Your Personal Session Schedule

    • Log in to the MMS 2009 CommNet using the credentials you created during registration
    • Select “Schedule Builder” in the left hand navigation pane
    • Search the content database using the filters and review the labs and presentations being offered during the event
    • To add a breakout or lab session to your schedule, simply click the circle beside the time and location you wish to attend
    • You may print out your schedule or export sessions to your Outlook client by clicking on the relevant icon

    Booking Instructor-led Lab Sessions at MMS 2009

    The Instructor-led Lab (ILL) sessions at MMS are extremely popular and many lab sessions will be fully booked well before the event opens.  We strongly recommend that you use this opportunity to book places in the labs that most interest you while places are still available in all sessions.  Lab topics are being offered in two formats. 

    Instructor-led Labs: Five rooms are dedicated to Instructor-led lab (ILL) sessions running throughout the week. During these sessions an instructor provides an introduction to the each lab topic and leads you through the lab procedure for a specific topic. Places in all Instructor-led Sessions may be reserved in advance though the MMS 2009 attendee web site Schedule Builder tool. Prior reservations are recommended since the most popular sessions often become fully booked before the event opens.
    Self-paced Labs:
    A self-paced hands-on lab area adjacent to the CommNet area offers walk-up access to all lab topics where attendees may complete their choice of lab without an instructor. Lab proctor support is provided in this area during session time-slots and the area remains open outside session times without proctor support. Access to this area is provided on a first-come basis - on-line reservations are not available for the self-paced lab area.

    ILL sessions match breakout session slots and are 75 minutes long. Scheduled lab sessions start on Monday, April 27th. These Monday lab sessions are very popular and tend to become fully booked well before the event opens.

    Instructor-led Lab Booking Quota

    At this time you may reserve places in up to 3 ILL sessions. From Monday, April 13th you may book an additional 3 lab sessions and once the event opens on Monday April 27th any number of ILL session slots may be reserved in your schedule.

    Many thanks for choosing to join us again at MMS 2009.  We look forward to meeting you again in Las Vegas this April.

    Best wishes

    The MMS 2009 Event Team

    You have been sent this email as a registered attendee of MMS 2009.  If you no longer wish to receive email updates about the MMS 2009 event please reply to this message with a subject line of “Remove

  • Reblog: Do you have an interest in Microsoft System Center products and solutions?

    Source:User Groups and Community

    The Microsoft System Center team is pleased to announce the creation of the
    System Center Influencers Program.   With this program user group leads and user group members will be able to:

    • Access key content:  Get access to the latest System Center technical training content to help you enhance your expertise.   This also includes exclusive user group session content that you can use/present at your user group sessions.
    • Meet experts and peers in the community:  Stay connected with System Center -focused events, or let others know about your upcoming events.   You can register and find events, as well as request speakers with domain expertise for upcoming meetings.
    • Grow in influence:  Learn about new opportunities to lead your community on and offline, find out about other opportunities to get more involved with Microsoft. 

    If you are interested, let us know by sending us a quick email to scnetsup@microsoft.com