The sql_response probe is configured to monitor databases on a remote server that has no robot installed. We have not configured the Alarm Source in the probe because the default source is the robot name.
When we look into Operator Console for the Alarm we see the robot name as well but the Device Name is the SQL Server Device.
In the Inventory the Robot Device does not have this Alarm.
In the Inventory, a new Device shows up for the SQL Server which has the Alarm.
Is there a way to configure the probe to show all Alarms on the robot device where it is installed?
This will be fixed on Cumulative Update 8 that will be released in July 2023.
Workaround:
In order to create an alarm on the robot device, we can override the source with the Probe robot name and enhance the alarm using alarm enrichment rules.
In nas.cfg following config changes can be made and nas and alarm enrichment probes to be deactivated and activated:
Under enrichment-source/cmdbs/ added a new enricher:
<source_enricher>
population_query = null
user = <user usually the sys admin>
password = <encrypted_password>
query = select dev_id, dev_name as name from CM_DEVICE where dev_name=?
active = true
connection_url = jdbc:sqlserver://UIMIPAddressForSQLServer:1433;DatabaseName=<database_name>;
</source_enricher>
Under enrichment-rules , added a new rule.
<2>
use_enricher = source_enricher
match_alarm_regexp = sql_response
match_alarm_field = prid
lookup_by_regexp =
lookup_by_alarm_field = udata.source
<overwrite-rules>
dev_id = [cmdb.dev_id]
</overwrite-rules>
</2>
In the sql_response profile, the alarm source is to be set to ip/name of probe robot.
Once these are done, I could see the alarm created on dev_id of probe robot instead of remote device.
This KB was written with logmon in mind but can be applicable for any probe.
https://knowledge.broadcom.com/external/article/4677/alarm-source-change-in-logmon-to-the-cor.html