Is it possible to extract records from GRC indicator result?

[Connor Meyer]

Hi Community, 

I have a scripted control indicator which runs monthly and generates supporting data in the indicator result. Currently, the supporting data is in a list view and shows the 'live record'.

This view of the records does not allow for the records to be extracted in xlsx or csv format (or any format for that matter). The Indicator Result system table is set-up this way.  

It's likely a long shot, but is there a way to allow for the records to be extracted via xslx or csv? 

[Community Alums]

Hi @Connor Meyer ,

As per your screenshot, the supporting data view which you have, you cannot  extract via xslx or csv Unfortunately.

However, if you just want to export the Indicator Results which is just "True" or "False" can be found in the table "sn_grc_indicator_result":

[Naveen Kumar4 · Accepted solution]

Hi @Connor Meyer ,

The above list is developed using a UI macro and UI formatter.

You can find them in below URL's

<instance>/now/nav/ui/classic/params/target/sys_ui_macro.do%3Fsys_id%3D63882935c333020044b2db1122d3aed3

<instance>/now/nav/ui/classic/params/target/sys_ui_formatter.do%3Fsys_id%3D8bc8a935c333020044b2db1122d3ae14%26sysparm_record_target%3Dsys_ui_formatter%26sysparm_record_row%3D3%26sysparm_record_rows%3D5%26sysparm_record_list%3DtableCONTAINSindic%255EORDERBYname

We store this data in a columnar format in sn_grc_indicator_supporting_data table. We are not providing any option to extract this information as of now. Please customise based on your needs for now. I will see if we can incorporate this requirement into our product.

Thanks,

Naveen

[Connor Meyer]

Thanks Naveen for the response! That makes sense regarding the list's development in a UI macro and formatter. And thanks for dropping the URLs to them - I'll take a look!

Lastly, I think it would be a subtle but powerful enhancement to have some form of extractable list! On my end, upon creation, issues are assigned to a certain area of our business that is responsible for mitigating/resolving the issue (an issue manager oversees). The assigned to users almost always want to be able to extract the records into some form of Excel format as it's easier for base users to filter/pivot the records to analyze the data in order to pick out trends or patterns. Ultimately, it would be a really, really nice to have feature!  

[Naveen Kumar4]

Hi @Connor Meyer ,

I talked to PM about this. We will see how to prioritise it.

Thanks,

Naveen