Report on number of emails on Case
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2023 09:21 PM
Hi everyone,
I get a requirement to report on number of emails related to a Case in SN. Or number of actions taken on a case.
I know that the related items links case to emails. However, I have hard time to make use of this link in the report.
Could anyone help?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2023 09:38 PM
Hi @Ping Cai
You can use the "Related Items" field in the Case table to create a relationship between Cases and Emails in ServiceNow. To report on the number of emails related to a Case, you can create a report using the Case table and join it with the Email table using the "Related Items" field. You can then use a count function to count the number of emails for each case. Additionally, you can use the "History" field in the Case table to track the number of actions taken on a case and use this information in your report as well.
Please mark the suggestion as helpful, if you find it useful to you or others who wants to refer similar content.
Please mark the solution as correct, if the answer provided by me has resolved your query.
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 04:14 PM
Hi @Neeraj Modi ,
I think the related items are already defined OOB. Am I right? Simply because I can see the emails in the Case form> related items list.
If I am right as above, I cannot find emails when I report on case table. Did I miss anything?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 04:17 PM
Furthermore, the field which records number of updates is called 'updates', not history .