Setting up a Rejected AWA Cases report

Keerthi Rahul
Giga Contributor

Hello All,

I'm trying to setup a report in our servicenow system for AWA time out cases. Screenshot attached. What i want to do is to see the time out for only P1 incidents. How can i achieve that. 

I'm unable to find a filter to select the priority. Any help would be really helpful 

 

5 REPLIES 5

Pavankumar_1
Mega Patron

Hi,

on which table you are generating report. Both case and incident table have the priority field.

please share more details.

regards,

Pavankumar

 

 

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

Im using Table: SAP timed out work item [u_sap_timed_out_work_item]

Mohith Devatte
Tera Sage
Tera Sage

Hello,

You can do reporting on awa_work_item where you can get all your work items and I think if your queue or channel is on case table then in "Document IDfield you will find the tagged case or you ticket.

I know that you can't dot walk on Document ID field 

I had a requirement like yours but we ended up in creating a custom field on work item form which refers to case table and stores the case tagged in document ID field. We wrote a BR for this which updates this custom field with case number when ever a work item is created .

And i did reporting on that custom field .As it was a reference field i could dot-walk to fields on case table. 

In your case you can access priority field on the case form by dot-walking from that custom field.

please refer below link for proof that we can't dot walk .Check for chuck thomasi answer 

https://community.servicenow.com/community?id=community_question&sys_id=629a832ddb5cdbc01dcaf3231f96...

This is the only solution that we got.

And in your report you can filter out for timed out work items using check box "Timed Out" on work item form like below 

find_real_file.png

Please mark my answer helpful if it helps you

Hope this helps 

Sure will check this and get back. Appreciate your help