Home
  •  

Monitor Random Password Manager Compliance Database

LiebermanSoftware.RPMMP.CDBUnitMonitor (UnitMonitor)

Monitor Random Password Manager compliance database's Connection and Size

Knowledge Base article:

Summary

Monitor Random Password Manager main database's connections and size.

Causes

This two state monitor will raise alert when

1.The database can not be opened

2.The database is not set to auto growth or its size is almost full (set by DBPercent)

Resolutions

Ensure agent action account have the right to access the database if you use Windows Authentication.

Ensure the Random Password Manager SQL Authentication Account is correct if you use SQL Authentication.

It is recommended to set up the database autogrowth policy to be true.

Element properties:

TargetLiebermanSoftware.RPMMP.APP
Parent MonitorSystem.Health.AvailabilityState
CategoryCustom
EnabledFalse
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeLiebermanSoftware.RPMMP.DBUnitMonitorType
RemotableTrue
AccessibilityInternal
Alert Message
RPM Alert: Compliance Database
Error occured on {0}\{1}. Check Alert Context for detail.
RunAsDefault

Source Code:

<UnitMonitor ID="LiebermanSoftware.RPMMP.CDBUnitMonitor" Accessibility="Internal" Enabled="false" Target="LiebermanSoftware.RPMMP.APP" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="LiebermanSoftware.RPMMP.DBUnitMonitorType" ConfirmDelivery="true">

  <Category>Custom</Category>

  <AlertSettings AlertMessage="LiebermanSoftware.RPMMP.CDBUnitMonitor_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/CDBDataSource$</AlertParameter1>

      <AlertParameter2>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/CDBInitCatalog$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="LiebermanSoftware.RPMMP.CDBUnitMonitor_SUCCESS" MonitorTypeStateID="Success" HealthState="Success"/>

    <OperationalState ID="LiebermanSoftware.RPMMP.CDBUnitMonitor_ERROR" MonitorTypeStateID="Error" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <DBSource>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/CDBDataSource$</DBSource>

    <DBName>$Target/Property[Type="LiebermanSoftware.RPMMP.APP"]/CDBInitCatalog$</DBName>

    <SQLUserName/>

    <SQLPassword/>

    <DBPercent>90</DBPercent>

    <IntervalSeconds>300</IntervalSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

  </Configuration>

</UnitMonitor>