Oracle custom query monitoring
Article ID: 94228
Updated On:
Products
NIMSOFT PROBES
DX Infrastructure Management
Issue/Introduction
We created a custom query to run a query that returns account expiration dates that we wish to monitor so that we can raise alarms when the account is about to expire, but we cannot get the custom query to work with the oracle probe.
Cause
The custom query returned a list of account names and expiration dates. As documented in the "(Optional) Create Custom Checkpoints" section of the "oracle IM Configuration" and "oracle AC Configuration" Wiki pages, the custom query has to return at least one numeric column that will be used as Checked value (all numeric formats are supported).
Environment
Any UIM version
Any oracle probe version
Any oracle probe version
Resolution
Custom checkpoints in the oracle probe only supports monitoring of numeric fields returned by the custom query. The current design does not support monitoring of a time/date field to be used to generate alarms if the time/date will expire in a set number of days or has already expired.
Additional Information
Feedback
Yes
No
Powered by
