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 ;-)
% Logical Disk Free Space on Windows Server 2003
Total Number of Servers per OS
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)
Building on its cloud computing strategy, Microsoft made several announcements yesterday:
More announcements can be found on System Center Central. Keynotes will be also be available for live and on-demand viewing here
During the keynote the next products where used to show how they support Microsoft’s Cloud strategy:
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
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.
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 firstname.lastname@example.org.
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
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.
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.
There are new downloads available for OpsMgr 2007 R2 on Connect.
Go to Connect and download the new stuff.
Today was the first unofficial day of MMS 2009 in Las Vegas and here are some announcements:
Tomorrow is the first official day which starts with a keynote so there will more announcements tomorrow.
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:
More info on Veeam.
Source: Microsoft Technet
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)
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.
Event ID: 1032409726
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:
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.
Source: Microsoft Download Center
This QFE updates the System Center Operations Manager 2007 Agent to allow it to monitor Windows Server 2008 Internet Information Services 7.0 Servers.
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:
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.
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
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:
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.
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:
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.
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
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.
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”
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:
If you are interested, let us know by sending us a quick email to email@example.com.