It worked just fine, also under Server 2008 but since 2008 R2 we have the problem here that these tasks don't "really run" as the action account but as local system.

What I mean is:

I launch a VBScript that launches a Powershell Script that is supposed to write to the eventlog with this Description: "%username% $Environmentvar blahblah"

And what I get in the eventlog is:

"COMPUTERNAME$ blahblah" <- therefore the Environmentvar is null and user seems to be localsystem.

Now the funny thing is, the user that wrote into the eventlog is: The MOM Action Account.

The script mentioned here was just for testing purposes, the real script only relies on global variables that are loaded using Powershell Profiles, but when it runs as local system this profile won't get loaded.

As said, this occurs since Server 2008 R2 and I was wondering if anyone else faced a problem like this.

Am I wrong in assuming that it should appear in the Health Explorer of a SQL Server?

Where will it appear?

Regards,

Now at version 6.0.7600.0, the IIS 7 management pack provides proactive monitoring of incidents that could affect the performance and availability of the different services provided through IIS, which include:

• Web Sites
• Application Pools
• FTP Servers
• NNTP Servers
• SMTP Servers

To help troubleshoot common issues the management pack contains helpful product knowledge and inline management tasks.  Operations Manager also provides the ability to extend this knowledge through adding your own company or organization information.

The updated management pack can be downloaded immediately, and will shortly be available to customers running Operations Manager 2007 R2 via the online catalog.  Customers running Operations Manager 2007 SP1 should review KB article 971541 and apply the Operations Manager Service Pack 1 update before installing this updated management pack.

Sacha Dawes, CISSP
Sr. Technical Product Manager
System Center Solutions for Dynamic Datacenters

Published 08 February 10 09:31 by sdawes]]> Tue, 09 Feb 2010 11:15:48 GMT /BlogDetails/tabid/143/IndexId/59259/Default.aspx  Okay, for future reference, putting your RMS in maintenance mode stops the Config service from processing data - no change is calculated, etc. In my experience, you wind up with a backlog of data to be processed and it can be difficult to get the RMS to doing it's job again.

Have you tried restarting SDK, Config and Health Services on the RMS? That would be a good start. Then, keep an eye on the OpsMgr Event Log on the RMS to see that it stops logging errors and goes back to doing it's job.

In the end, just be sure that RMS never goes into maintenance mode. 

IIS management pack for Server 2008 SP2 & Server 2008 R2 has been released. Available now in the in-product R2 catalog. Pinpoint ETA 24hrs 5 minutes ago from web

An updated version for the ReSearch This management pack has been created for the R2 version of the management pack and has been updated to work for MOM 2005 as well. There had been issues with this management pack and how it integrated with the new systemcentercentral.com website which should be addressed with the updated version. This management pack provides an easy way to investigate alerts in Operations Manager (and System Center Essentials, and MOM) and search for resolutions which the community has found when the alert occurs. The updated version of this management pack is available at: http://www.systemcentercentral.com/PackCatalog/PackCatalogDetails/tabid/145/IndexID/21716/Default.aspx.

I am working on a version which will work on OpsMgr 2007 RTM – hopefully later in the week.

WIth that being said, it would seem plausible your regular expression is problematic...can you post that expression so we can have a look and perhaps offer some alternatives?

Vlad J. from the product team posted an article you might have a look at for insight about OpsMgr and it's support of regex.

Regular Expression Support in SCOM 2007

Start with Kevin Holmans blog with these articles 

Event ID 2115 A Bind Data Source in Management Group

Here are a few bits on tracking down the biggest sources of data in your Operational database. You may find multiple sources of significant data insertions with minimal production value.

• OpsMgr Database Hygiene: Monitoring database insertions to keep your infrastructure tuned
• OpsMgr Database Hygiene Part 2: Table Size Reporting and what this information reveals...
• OpsMgr Database Hygiene Part 3: Identifying recently noisy unit monitors
• OpsMgr Database Hygiene Part 4: Identifying Rules and Instances Generating the Most Alerts
• OpsMgr Database Hygiene Part 5: More Useful Queries for Daily Operations

And while a bit off the subject. And Kevin has this post with just a huge list of queries, within which you may find some additional information 

Useful Operations Manager 2007 SQL queries