How can I sys_id of configuration item in a report using task_ci table as a source

R Aishwarya
Tera Contributor

‎12-05-2023 05:31 AM

I have used task_ci table as a source table to create a report.

Now I need sys id of Business application(CI) to be reflected in my report.

I have tried adding sys_id to list elements of Business application table using system UI. But when i tried doing dot walk of Configuration item,i couldn't fetch its related sys_id of CI.Please help me  to map its sys_id 

Preview file
14 KB
Preview file
27 KB
0 Helpfuls
  • 555 Views
1 REPLY 1

Rahul Priyadars
Tera Sage
Tera Sage

‎12-05-2023 11:28 PM

Hi Aishwarya

 

In which View You have the the UI element as the given table task_ci  has 8/9 views.

Now On top of It for every report it creates a Temp View also. I tried adding SYS_ID in the report View and Flushed the Cache it created another default view and not picked the View where i added the SYS_ID field.

 

RahulPriyadars_0-1701847671631.png

 

How its doing at ur end?

Users are unable to add the Sys ID field to a form or list view or a report / Exporting data with Sy...

Regards

RP

0 Helpfuls