Regola avviso integrità database DHCP

Microsoft.Windows.DHCPServer.Library.Database.DBIntegrity.Warning.Rule (Rule)

Knowledge Base article:

Soluzioni

Se il database del server DHCP viene danneggiato o perso, è possibile ripristinarlo sostituendo il file di database del server (Dhcp.mdb), posto nella cartella %SystemRoot%\System32\Dhcp, con una copia di backup dello stesso file.

Se Gestore DHCP è stato utilizzato in precedenza per eseguire un backup, è possibile ottenere la copia di backup del file di database del server posto nella cartella %SystemRoot%\System32\Dhcp\Backup. È inoltre possibile ripristinare il file Dhcp.mdb da un backup su nastro o da altri supporti di backup.

Per eseguire queste procedure, è necessario essere un membro del gruppo Administrators oppure avere ricevuto in delega l'autorità appropriata.

Per ripristinare una copia di backup del database DHCP:

Fare clic sul pulsante Start, selezionare Tutti i programmi, Accessori, fare clic con il pulsante destro del mouse su Prompt dei comandi, quindi fare clic su Esegui come amministratore.
Digitare net stop dhcpserver, quindi premere INVIO.
Digitare md c:\olddhcp, quindi premere INVIO.
Digitare move %SystemRoot%\system32\DHCP\*.* c:\olddhcp, quindi premere INVIO.
Digitare del %SystemRoot%\system32\DHCP\Dhcp.md, quindi premere INVIO.
Digitare copy %SystemRoot%\system32\dhcp\backup\jet\new\dhcp.mdb %SystemRoot%\system32\dhcp\dhcp.mdb, quindi premere INVIO.
Digitare net start dhcpserver, quindi premere INVIO.

Element properties:

Target

Microsoft.Windows.DHCPServer.Library.Database

Category

EventCollection

Enabled

True

Alert Generate

True

Alert Severity

Warning

Alert Priority

Normal

Remotable

True

Alert Message

Avviso integrità database DHCP

{0}

Event Log

System

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.Windows.EventProvider	Microsoft.Windows.DHCPServer.Library.ActionAccount
GenerateAlert	WriteAction	System.Health.GenerateAlert	Default
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectEvent	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishEventData	Default

Source Code:

<Rule ID="Microsoft.Windows.DHCPServer.Library.Database.DBIntegrity.Warning.Rule" Enabled="true" Target="Microsoft.Windows.DHCPServer.Library.Database" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="DS" RunAs="Microsoft.Windows.DHCPServer.Library.ActionAccount" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerName>

      <LogName>System</LogName>

      <Expression>

        <And>

          <Expression>

            <Or>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

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

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="String">Microsoft-Windows-DHCP-Server</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

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

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="String">DHCPServer</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

            </Or>

          </Expression>

          <Expression>

            <Or>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

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

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="UnsignedInteger">1010</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

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

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="UnsignedInteger">1014</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

              <Expression>

                <SimpleExpression>

                  <ValueExpression>

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

                  </ValueExpression>

                  <Operator>Equal</Operator>

                  <ValueExpression>

                    <Value Type="UnsignedInteger">1015</Value>

                  </ValueExpression>

                </SimpleExpression>

              </Expression>

            </Or>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectEvent"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>

    <WriteAction ID="GenerateAlert" TypeID="Health!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>1</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.Windows.DHCPServer.Library.Database.DBIntegrity.Warning.Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</SuppressionValue>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>