Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. The Exchange Server Availability report in the Exchange 2003 Management Pack for MOM 2005 may show availability of over 100 percent

The Exchange Server Availability report in the Exchange 2003 Management Pack for MOM 2005 may show availability of over 100 percent

View products that this article applies to.

Symptoms

In a Microsoft Exchange Server 2003 environment, the Exchange Server Availability report in the Microsoft Exchange Server 2003 Management Pack for Microsoft Operations Manager (MOM) 2005 may show availability of over 100 percent.

Note This problem does not occur in System Center Operations Manager 2007.

↑ Back to the top

Workaround

To work around this problem, follow these steps:
  1. Export the Availability report as an .rdl file. To do this, follow these steps:
    1. In the Report console, open the Exchange Server Availability Report item.
    2. Click Properties.
    3. In the Report Definition field, click Edit.
    4. Save the "Exchange Server Availability.rdl" file.
  2. Modify the .rdl file, and then rename it. To do this, follow these steps:
    1. Open the "Exchange Server Availability.rdl" file in Notepad.
    2. Locate the following sections of code.
      "<CommandText>"
      "
SELECT
Server,
[MDB],
SUM(EventNumber9980) AS MDBAvailCount,
SUM(EventNumber9981)  AS DSUnAvailCount,
SUM(EventNumber9982)  AS StoreUnAvailCount,
"
    3. Between these sections of code, add the following code.
      Declare @tempBeginDate as Datetime
Declare @tempEndDate as Datetime
select @tempBeginDate = @BeginDate
select @tempEndDate   = @EndDate
select @BeginDate = DATEADD(s,  -1 - Datepart (s,@tempBeginDate) , DATEADD (n , (FLOOR(Datepart (n,@tempBeginDate) / 5) * 5 ) - Datepart (n,@tempBeginDate), @tempBeginDate ))
select @EndDate = DATEADD(s,  -1 - Datepart (s,@tempEndDate) , DATEADD (n , (FLOOR(Datepart (n,@tempEndDate) / 5) * 5 ) - Datepart (n,@tempEndDate), @tempEndDate ))
    4. Save the report by giving it a new name.
  3. In the Report console, at the same level as the Availability report, click Upload in the bar. Click Browse, and then select the .rdl file that you saved in step 2.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More information

The Exchange Server Availability report counts the number of Event 9980 events that occur in a time period.

Event 9980 is logged by the "Check mailbox store availability" rule. This rule runs one script that tries to connect to a test mailbox on the store. If the rule succeeds, it will log Event 9980.

This rule is scheduled to run every five minutes. In the Exchange Server Availability report, a column that is named Success/Expected indicates how many Event 9980 events were logged in the time period.

↑ Back to the top

Keywords: KB945966, kbprb, kbexpertiseinter, kbtshoot

↑ Back to the top

Article Info
Article ID : 945966
Revision : 1
Created on : 12/31/2007
Published on : 12/31/2007
Exists online : False
Views : 197