Hi Marios
I like the way you handled this task and the great information it provides. However, I had some errors on the 2000 script thats making me do a lot of head scratching. These our all older 2000 instances on either Windows Server 2000 or 2003
Does any of these make any since to you:
Event Type:Warning
Event Source:Health Service Modules
Event Category:None
Event ID:21413
Date:11/7/2008
Time:1:03:57 PM
User:N/A
Computer:GIS
Description:
The Event Policy for the process started at 1:03:56 PM has detected errors in the output. The 'StdErr' policy expression:
\a+
matched the following output:
C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\55987\Custom_SQL2000_Blocking.vbs(153, 9) ADODB.Command: Item cannot be found in the collection corresponding to the requested name or ordinal.
Command executed:"C:\WINDOWS\system32\cscript.exe" /nologo "Custom_SQL2000_Blocking.vbs" gis
Working Directory:C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\55987\
One or more workflows were affected by this.
Workflow name: MomUIGeneratedRule81b439253e464a408ab1d0402a91aad1
Instance name: MSSQLSERVER
Instance ID: {6BEBE62A-DEE0-BEB3-8822-FD9B7941FD43}
Management group: SCOM
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type:Warning
Event Source:Health Service Modules
Event Category:None
Event ID:21413
Date:11/7/2008
Time:3:43:07 PM
User:N/A
Computer:GIS
Description:
The Event Policy for the process started at 3:43:06 PM has detected errors in the output. The 'StdErr' policy expression:
\a+
matched the following output:
C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\56373\SQL2000Blocking.vbs(100, 1) Microsoft OLE DB Provider for SQL Server: String or binary data would be truncated.
Command executed:"C:\WINDOWS\system32\cscript.exe" /nologo "SQL2000Blocking.vbs" gis
Working Directory:C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\56373\
One or more workflows were affected by this.
Workflow name: MomUIGeneratedRule624f6f0c92d14efc8c6798ca7787892d
Instance name: MSSQLSERVER
Instance ID: {6BEBE62A-DEE0-BEB3-8822-FD9B7941FD43}
Management group: SCOM
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.