Is there a way to search for both Incidents and Requests in one report?

[Dutra]

Hi everyone!

I'd like to know if on Service Now it's possible to create a report/dashboard to view and search for both Requests and Incidents. I already tried to make a new filter, but it just shows INCs and RITMs separately. 

I could merge two reports in a dashboard but the search bar is not available on this model. Could you help me?

[SanjivMeher · Accepted solution]

Yes. You can create a report on task table and in report condition select Task Type/Class Name as Incident Or Requested Item. That should give you report of both tables in the same report

[Sebas Di Loreto · Accepted solution]

@Dutra 

This is what you have to do

[SanjivMeher · Accepted solution]

Yes. You can create a report on task table and in report condition select Task Type/Class Name as Incident Or Requested Item. That should give you report of both tables in the same report

[Sebas Di Loreto · Accepted solution]

@Dutra 

This is what you have to do

[Musab Rasheed · Accepted solution]

Hello,

You can use 'Task' table for that purpose and use task type to group RITM and Incident, alternatively you can use 'Date set' concept in reporting in case you want to show both INC and RITM as separate but part of one report. Check below

https://www.servicenow.com/community/performance-analytics-blog/servicenow-creating-advanced-report-...

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

[Dutra]

Hi! @SanjivMeher and @Sebas Di Loreto 

Thank you for your quick response! I already tested it out and it worked on my report. 
  I'll also use the guide provided to improve my project. I really appreciate the help.