Home
  •  

ConfigMgr 2007 彙總站台系統摘要器:SMS SQL 資料庫僅剩不到 5\% 的可用記錄檔空間，已無法再自動增加

SMSv4_Consolidated_Site_System_Summarizer__SMS_SQL_database_has_less_than_5__free_log_file_space_and_no_autogrow_15_Rule (Rule)

Knowledge Base article:

摘要

此規則會彙總事件，以取得其伴隨事件的處理規則：

ConfigMgr 站台系統摘要器：Configuration Manager SQL Server 資料庫僅剩不到 5% 的可用記錄檔空間，且未設定為自動增加。

Element properties:

TargetMicrosoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Providers_Installation
CategoryEventCollection
EnabledTrue
Alert GenerateFalse
RemotableTrue
CommentMom2005ID='{D0D1285A-FA37-476C-AEA5-B7643C105D4E}';MOM2005ComputerGroupID={9B811173-1E0F-43C1-B7D0-102B24FFFB7D}

Member Modules:

ID Module Type TypeId RunAs 
_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_ DataSource System.Mom.BackwardCompatibility.FilteredEvent.DataProvider Default
ConsolidatedEventWriteAction WriteAction System.Mom.BackwardCompatibility.ConsolidatedEventResponse Default

Source Code:

<Rule ID="SMSv4_Consolidated_Site_System_Summarizer__SMS_SQL_database_has_less_than_5__free_log_file_space_and_no_autogrow_15_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Providers_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{D0D1285A-FA37-476C-AEA5-B7643C105D4E}';MOM2005ComputerGroupID={9B811173-1E0F-43C1-B7D0-102B24FFFB7D}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_" Comment="{F320DA51-13BF-11D3-B2CD-00A0C92A28B4}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.FilteredEvent.DataProvider">

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>1109</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>ConfigMgr 2007 Monitor Site System Summarizer</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="ConsolidatedEventWriteAction" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.ConsolidatedEventResponse">

      <ConsolidationProperties>

        <PropertyXPathQuery>EventDisplayNumber</PropertyXPathQuery>

        <PropertyXPathQuery>PublisherName</PropertyXPathQuery>

        <PropertyXPathQuery>EventDescription</PropertyXPathQuery>

      </ConsolidationProperties>

      <Interval>3600</Interval>

    </WriteAction>

  </WriteActions>

</Rule>