- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 07:33 AM
Hello community,
I have a request from the customer to create an Indicator Template for each Control Objective.
They have 250 Control Objectives and 14 613 Controls so I decided to go with the Fix Script.
It should create 250 Indicator Templates, create a relationship between the CO and Template in the sn_grc_m2m_ind_temp_cont table and this relationship should automaticaly create Indicators.
Demand is to automatically populate these fields on the Indicator template: name, short description, instructions, collection frequency, first run date and next run date.
My script creates 250 Indicator Templates, does the mapping and Indicators on the sn_grc_indicator table are created but ...
"Template" and the "first_run_date" fields on the Indicators are empty.
And I have no idea why as on the Template everything seems to be fine.
Would you know what might be the problem?
Thanks a lot for any help.
My fix script:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2024 12:40 AM
Hello @Mira1992 , the "first run date" is empty because this indicator has not been run yet. It will be filled after 1st execution (try by clicking on "Execute" in the indicator).
Regarding the "template" field, can you check the user's role if he has right to see the indicator template record ?
If the content of the indicator is the same for the 250, prefer to create the indicator template and attach it to the 250 control objectives.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2024 12:40 AM
Hello @Mira1992 , the "first run date" is empty because this indicator has not been run yet. It will be filled after 1st execution (try by clicking on "Execute" in the indicator).
Regarding the "template" field, can you check the user's role if he has right to see the indicator template record ?
If the content of the indicator is the same for the 250, prefer to create the indicator template and attach it to the 250 control objectives.