This KB describes an example how to configure alarm enrichment rule to add user_tag value for new alarms.
Pre-Requisite A table (referred as cmdb) must be ready. In this example, table name is Customer_Info. The table has 2 columns (robot, customer_id)
UIM any version
(*) This is an example of cmdb in SQL Server.
*** Take backup of nas.cfg prior to go steps. ***
1. Open nas probe in Raw Configure. 2. Go to <enrichment-source>/<cmdbs>, add new section "Add_User_Tag"
3. Configure the following key and value.
active = true connection_url = jdbc:sqlserver://<ip address or hostname of sqlserver>:1433;DatabaseName=<Database Name of cmdb table> user = <database user> password = <database user password in plain text> query = select robot,customer_id from Customer_Info where robot=? population_query =
(*) password string is automatically encrypted when nas probe is restarted.
4. Go to <enrichment-rules>/<1>, configure the following key and value.