Database views

tushar_ghadage · ‎09-29-2025

Hi ,

Can anyone guide me on problem migration utility what its for and why its used ??

thankss

Ankur Bawiskar · ‎09-30-2025

My thoughts

-> Since you said it didn't show data when you click Try it -> then do you have data in your tables (RITMs have approval records and those RITMs have SC Task with them)

-> It all depends whether you want to join sc_task or not => based on customer requirement

I shared solution already for this couple of years ago and it worked fine

-> Try to re-order the View tables as per below

Help With Database View (RITM-Approvals/SCTASK-Assignment Groups)

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Bhuvan · ‎09-29-2025

@tushar_ghadage

I am not sure why the question was changed as edited version is unrelated to original question.

Please create a new thread for new question so that it can help you and others to find right solution for the question.

Thanks,

Bhuvan

Dr Atul G- LNG · ‎09-29-2025

Hi @tushar_ghadage

https://www.servicenow.com/community/itsm-blog/problem-management-migration-utility/ba-p/2294946

*************************************************************************************************************
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]

****************************************************************************************************************

Rafael Batistot · ‎09-29-2025

Hi @tushar_ghadage

See this article, might help you

https://www.servicenow.com/community/itsm-blog/problem-management-migration-utility/ba-p/2294946

If you found this response helpful, please mark it as Helpful. If it fully answered your question, consider marking it as Correct. Doing so helps other users find accurate and useful information more easily.

Ankur Bawiskar · ‎09-29-2025

@tushar_ghadage

what's your actual business requirement?

share that along with screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

tushar_ghadage · ‎09-29-2025

Hi @Ankur Bawiskar ,

I need to show the approver column for the RITM records and catalog task records as well

for the RITM it is working but when I added the third table in database view its not showing me any data.

below I am trying to add the approver column for the catalog task as well along with the ritm records for this I have created below queries :

above is the condition I am using it for joining 3 tables

here but when I try to run it I am not getting any data for the report

as shown below

am I missing something in the clause ??

thankss