Report based on Request and Requested Items

[BuddhikaN]

Hi All,

I'm struggling to create a report based on Request and Requested Items in SNOW and would you be able to help me with this please? 

In my scenario one Request has two connected Requested Items.  So I want to create a report to show no of Requests where the connected two Requested Items are in Completed stage. 

Is this possible? 

Thanks 

[Sujatha V M · Accepted solution]

@BuddhikaN  Please refer the link below, 

https://www.servicenow.com/community/platform-analytics-forum/how-to-get-a-report-of-the-no-of-reque...

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

Thanks,

Sujatha V.M.

[BuddhikaN]

Hi @Sujatha V M,

Many thanks for the information. However, under the sc_req_item table I cannot see a filter for Stage or Status. So may I know how can I use either Requested Item Stage or Status for filteration? 

Thanks 

[Sujatha V M]

@BuddhikaN  You will be able to see the "State" & "Stage" under choose columns. 

For filtering the data, you can select it from the drop down. Please check once again. 

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

Thanks,

Sujatha V.M.

[BuddhikaN]

Thank you and it's sorted.