Updating Classification,Classification type and Classification Rule in sn_vul_third_party_entry tbl

[Sneh]

Hello All,

We integrated with Rapid7 Solution and I made it available on third party entry table as the related list is by default hidden :

I have created a Classification Rule on  sn_vul_r7_solution table and this will update the Solution group :

Now the requirement is, we need to populate fields like Classification,Classification type and Classification Rule in sn_vul_third_party_entry table once we update the solution group in Solution table but when I checked the Solution table there is no column available as this table is not extending any another table:

If I create these fields on Solution table then how I will map it with third party vuln entry table?

I would like to know how to achieve this?

[john_gibbons]

Most likely you will need to add a custom Business Rule or Scheduled job to populate the values to the solution table.  Is there a reason you cant use the Vul Entry table to drive the classification?   

[Sneh]

My  requirement is, we need to populate fields like Classification,Classification type and Classification Rule in sn_vul_third_party_entry table once we update the solution group in Solution table .

As we know third party has the reference of solution table.so we need to populate solution group field in solution table and we need to populate additional fields like Classification,Classification type and Classification Rule which are available in third part entry table but not in solution table