Migrate associated Controls on Entities from business app to technical service table

Rajareddy_VR
Tera Contributor

Team,

 

I have a requirement to migrate all existing associated controls on Entities [sn_grc_profile] from the business app [cmdb_ci_business_app] to technical services[cmdb_ci_service_technical] through the fix script.

applies to record: [applies_to] [field] reference of a business app to technical service table.

 

Rajareddy_VR_0-1693231385911.png

Rajareddy_VR_1-1693231556121.png

 

@Gunjan Kiratkar 

4 REPLIES 4

Gunjan Kiratkar
Kilo Patron
Kilo Patron

Hi @Rajareddy_VR ,

Please share your script so that I can help you make it perfect.

 


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

Community Alums
Not applicable

Hi @Rajareddy_VR ,

Why do you need a fix script for this requirement.

You can simply remove the entity filter condition from the Entity type attached to the control Objective.

and create a new filter condition with Technical services[cmdb_ci_service_technical] as table name and with specific conditions, and add it to the control objective , then automatically the entities from the technical services[cmdb_ci_service_technical] table will have the controls.

 

@Community Alums, We need to update the existing records. it is not happening by adding a filter condition change.

Community Alums
Not applicable

Hi @Rajareddy_VR ,

Unfortunately for the existing records , you cannot change it. It's the not the best practice.