Need to create a report from Problem table with associated incident numbers

[PRADEEPREDDY GU]

Hi 

 I Need to create a report from Problem table with associated incident numbers.

can anyone help me on this

[Sujatha V M]

@PRADEEPREDDY GU  You can generate the report on incident table as below with problem record details. 

You can even dot walk on the problem record to get other fields. 

Navigate through the comments : 

Reference : https://www.servicenow.com/community/itsm-forum/how-to-create-a-problem-report-with-the-number-of-in... 

 Please mark this as helpful and accept it as a solution if this resolves your query.

Thanks,

Sujatha V.M.

[Community Alums]

Hi @PRADEEPREDDY GU ,

There is a field on problem table known as First Reported By which holds the reference of incident table. You can right click on that field and click bar chart/pie chart as of your requirments 

I clicked on bar chart and result as follow 

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak

[AndersBGS]

Hi @PRADEEPREDDY GU ,

Why do you need to create the report from the problem table and not the incident table? What is your end goal? In general you could leverage the incident table and chose all with associated problem record.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders