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.
Environment
Any UIM version Any oracle probe version
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).
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.