I need a fix script to populate sys id of cmdb_ci table in a report built on database view

R Aishwarya
Tera Contributor

‎12-15-2023 06:46 AM

I have created a database view by combining task_ci and cmdb_ci. I have built a report on this view.I'm able to get task sys id directly but when i tried getting sys id of CI's from cmdb_ci table its not populating.

Servicenow support team suggested to write a fix script to populate sys id on report.

Can anyone help on this fix scripting part ?

0 Helpfuls
  • 294 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎12-17-2023 08:23 AM

Hi @R Aishwarya  

 

You can ask fix script as well from the support team. I am not getting what exactly you want to achieve.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

BalaG
Kilo Sage

‎12-17-2023 04:21 PM

Hi @R Aishwarya   not clear what is failing, please include more details on how the view was created and what the report is.  I assume  you are using the variable prefix to distinguish to the sys_id field from the two tables.

 

Regards

--

Balal G

0 Helpfuls