Scheduled Data Export sc_task and include variables from RITM

jlaps
Kilo Sage

‎10-02-2023 06:04 AM

i am trying to export a list of catalog tasks to be actioned by Manage Engine for Active Directory account management. The problem I am facing, is that the sc_tasks in question have fields in variables on the RITM, and though I can get at these variables from the REPORTS module, I do not seem to be able to get at them from the Scheduled Data Export module.

 

I found some posts about using the many to many table, which does look like I can get at the RITM and variables that way, but then I seem to be stuck referencing the TASK that we need to process with inbound action.

 

Are there other options to exporting catalog tasks that need to add variables to the CSV output?

0 Helpfuls
  • 452 Views
1 REPLY 1

jlaps
Kilo Sage

‎10-02-2023 07:37 AM

I created a database view linking sc_item_option_mtom and sc_task by the RITM. This seems like it might do the job, except for the fact that the VALUE field for reference fields is the sys_id, which is not useful exported to CSV. I think this may be a dead-end, but is there any way to resolve reference fields from the sc_item_option_mtom.dependent_item.value column so I can actually get the export to show the display values and not sys_ids?

0 Helpfuls