How can I create a report to show all closed tasks and resolved incidents for today?

[chaserich]

My team works on both Incident's and Tasks.   I am trying to build a report that will show all closed/resolved tasks and incidents today.   Ideally it would show when one of my team members marks it as resolved/closed and not the systems reporting of closed (I believe there is a waiting period to be reopened).

I have what I believe is a working version of the report for Incidents only, however I can't think of a way to combine the two reports.

Appreciate any advice I can get.

Have a great day!

-Chase

[Stefan Baldhof1]

Hi Chase,

as the Incident table is extended from the Task table try something like shown in the Screenshot attached.

Best Regards,

Stefan

[Travers M]

This report would catch what you're after but I've found when reporting on incident that resolved on today gives me a more accurate count of resolved incidents as we have a lot of polite users that like to reply with a thank you email when they get around to it and that counts as an update.   You may have an incoming email rule set up that re-opens an incident in which case my point is moot, I'm just putting it out there.

[gyedwab]

If you want to combine live data from multiple tables, possibly with different filters, you can use Explore Analytics' Mash-up feature.

In the following example, I created a list of Incidents closed today mashed-up with a list of Knowledge published today, to show that it doesn't rely on the fact that incident is extended from task -- you can do this with any sets of data, even with data outside of ServiceNow (MySQL, Oracle, MSSQL):

First, I created a list view on Incident, Resolved during Today:

Then, I did the same on Knowledge, published today:

In both, I made sure that the columns had the same labels in this report (so Closed By and Author became --> Closed By / Published By; The "Workflow" column became 'State'). Doesn't impact other reports.

Then, I just selected a mash-up of the two:

You could add additional if you wanted.

The view I got was this:

I could have this published live on SN dashboard or other portals, and the links work if you're logged in to ServiceNow. Also ACL's would be applied. The mashup works even though there's no "priority" field on the Knowledge table.

[chaserich]

Thank you for your reply.   Looks like it's working, however I can't get it to correctly display users only in my group.   I'm using "Assignment Group" "Is Dyanmic" "One of my groups", however it's showing users from all across service now.   I do have the assignment group setup in the top section of conditions, but I'm assuming the OR conditions are overriding that.