Associate the server/asset name with the business application record in the VR module

Alex Litvak
Tera Contributor

We are using the Vulnerable Item application in the VR module, which receives data from Qualys. One of the fields in the data is "Configuration item," which contains the name of the server or asset. The requirement is to associate the server/asset name with the business application record and add two more fields to the layout, "Application name" and "Owned by," which are part of the Business Application record.

Is there any way to achieve this task?

Thanks

2 REPLIES 2

alvinbm1
Tera Expert

 

1. **Create Reference Fields:**
- Go to the Vulnerable Item table in the ServiceNow Table dictionary.
- Add a new field of type "Reference" that references the Business Application [cmdb_ci_business_app] table. This will be your "Application name" field.
- Add another "Reference" field if "Owned by" is also a reference to a user or group within ServiceNow.

2. **Scripting to Auto-Populate Fields:**
- You can write a Business Rule or a Scripted REST API that triggers when a new Vulnerable Item record is created or updated.
- This script would search the Business Application table for a match based on the "Configuration item" data.
- Once a match is found, it would set the "Application name" and "Owned by" fields in the Vulnerable Item record.

3. **Data Lookup and Record Matching:**
- Alternatively, you can use the Data Lookup and Record Matching feature to automatically set the "Application name" and "Owned by" fields based on the "Configuration item" field.
- You would define the lookup rules that match fields from the Vulnerable Item record to fields in the Business Application record.

4. **Transform Map:**
- If you are importing data from Qualys using Import Sets, you can use a Transform Map to set these fields during the import process.
- You can add a script to the Transform Map to look up the Business Application record and populate the "Application name" and "Owned by" fields.

 

Hello,

I will test all your suggestions. Since we're not Java script experts, maybe you have some examples for bullet # 2 **Scripting to Auto-Populate Fields:**.

I appreciate any help you can provide.

Alex