We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Reporting on Stories and their dependencies

Spencer Granth1
Tera Contributor

Does anyone know how to report on the relationship of User stories and their dependencies/prerequisites? I've tried to create a list and show the related records but that did not work. 

2 REPLIES 2

Ehab Pilloor
Mega Sage

Hi @Spencer Granth1,

 

You would have to create database view of Story and dependencies/prerequisite tables and then you can produce report on it.

Refer these for more info:

https://www.youtube.com/watch?v=_JY462TmXxU

 

https://www.youtube.com/watch?v=syC8-0beVjQ

 

Regards,

Ehab Pilloor

In this ServiceNow Tutorial, Aaron Elder gives a demo on creating and using a database view in ServiceNow. Create the database view. Role required: admin. Learn more: https://docs.servicenow.com/bundle/paris-platform-administration/page/use/reporting/task/t_CreateADatabaseView.html ...

Dr Atul G- LNG
Tera Patron

Hi @Spencer Granth1 

I don’t think there’s a need to create any Database View. You can simply create a report on the m2m_story_dependencies table, and that should be sufficient.

The output will look like this:

 

DrAtulGLNG_0-1750949742812.png

 

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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