Example that works on my system. You need to test this on your TEST system:
Part of my nas.cfg:
<enrichment-source>
<cmdbs>
<os_enricher>
active = true
connection_url = jdbc:sqlserver://sql_server:1433;DatabaseName=CA_UIM
user = sa
password = xxxxxxxxxxx==_encrypted
query = select name,ip,os_type,mac from cm_computer_system with(nolock) where os_type != 'NULL' and name=?
population_query = select name,ip,os_type,mac from cm_computer_system with(nolock) where os_type != 'NULL'
</os_enricher>
</cmdbs>
</enrichment-source>
<enrichment-rules>
exclusive_enrichment = no
<3>
match_alarm_field = prid
match_alarm_regexp = (net_connect)
use_enricher = os_enricher
lookup_by_alarm_field = udata.source
lookup_by_regexp =
<overwrite-rules>
udata.custom_4 = [cmdb.os_type]
udata.custom_3 = alarm_os_type_source
udata.custom_2 = [cmdb.mac]
</overwrite-rules>
</3>
<1>
match_alarm_field = prid
match_alarm_regexp = .*
use_enricher = os_enricher
lookup_by_alarm_field = robot
lookup_by_regexp =
<overwrite-rules>
udata.custom_4 = [cmdb.os_type]
udata.custom_3 = alarm_os_type_robot
udata.custom_2 = [cmdb.mac]
</overwrite-rules>
</1>
</enrichment-rules>
Original Message:
Sent: 09-18-2019 04:56 AM
From: anmol kumar
Subject: Using Alarm enrichment to add OS
Hi All,
I need to add OS name in alert using alarm enrichment.
Any suggestions how to do it
Thanks
Anmol