Is it possible to extract records from GRC indicator result?

Connor Meyer · ‎12-12-2023

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?

Naveen Kumar4 · ‎12-12-2023

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

View solution in original post

Natascha deJ · ‎07-18-2024

Hi,
Are there any updates? Our organization would also like to have this option.