Create a Report showing the Last 20 entries of an Assignments groups open Tasks (Activity Stream)

[Keith Ciupak]

Hello,

I have received a request from a service manager who is looking for a report of the teams last 20 entries in the activity stream of their open Tasks. He had something similar to this when they used Jira and is looking for a SN solution for the same information. Is this something we can create from basic SN reporting?

Thx

[SwarnadeepNandy]

Hello @Keith Ciupak,

ServiceNow provides a feature called Activity Stream that allows users to view and update the activities related to a record, such as comments, work notes, attachments, approvals, and state changes. The Activity Stream is displayed as a tab on the form of the record, and it can be configured to show different types of activities and filters.

To create a report of the last 20 entries in the Activity Stream of the open Tasks for a team, you will need to follow these steps:

• Navigate to Reports > Create New in the application navigator.
• Select the List report type and click Create.
• In the Data tab, select the Task [task] table as the data source.
• In the Filter section, add the following conditions:
  • [Assignment group][is][the name of the team]
  • [Active][is][true]
• In the Group by section, select the Number field as the grouping field.
• In the Columns section, add or remove the columns that you want to display in the report. For example, you can add columns such as Short description, State, Priority, and Updated.
• In the Sort section, select the Updated field as the sorting field and choose Descending as the order.
• In the Style tab, select the List with activity stream option as the list style. This will enable the Activity Stream feature for each record in the report.
• In the Title tab, enter a name and a description for your report. For example, you can name it “Open Tasks with Activity Stream for Team X”.
• Click Save or Run to save or run your report.

You should now see a list report of the open Tasks for your team, with each record showing an Activity Stream tab that displays the last 20 entries of activities related to that record. You can also click on each record to open its form and view more details and activities.

I hope this helps you

Kind Regards,

Swarnadeep Nandy

[Keith Ciupak]

Great info! I was able to replicate everything you mentioned except for the following: 

• In the Style tab, select the List with activity stream option as the list style. This will enable the Activity Stream feature for each record in the report. 

I am not seeing this option in the report build. (Using Tokyo version)

[Keith Ciupak]

@SwarnadeepNandy 

Great info! I was able to replicate everything you mentioned except for the following: 

• In the Style tab, select the List with activity stream option as the list style. This will enable the Activity Stream feature for each record in the report. 

I am not seeing this option in the report build. (Using Tokyo version) Was this a plugin or customization you did to add this activity stream option in the Style Tab dropdown?

[jkhanddh]

Hi @Keith Ciupak ,
Did you get any solution to this then? If yes, please share