How do you a run a Report to show REQ that you are following

[shelley0366]

Hi

I am trying to run a report that shows all the Requests I am following but doesn't appear to have any option in the selection in report creation

When we click on the Follow any updates it will send a notification, but would be good to be able to have a report on a Dashboard that shows this, similar to Incidents and the watch list. 

I have looked on line, but nothing that I can see mentions this field or how to report on it. 

Is this possible and if so could someone point to where the instructions are please  ?

[Jean-Emmanuel · Accepted solution]

Hi @shelley0366 

The behavior of the “Follow” button involves several key records, but let’s simplify it for you.

When a user clicks the Follow button, three tables in ServiceNow are involved:

1. live_group_profile: This table contains records for the Task being followed.

2. live_profile: This table stores information about the Follower (the user who clicked “Follow”).

3. live_group_member: This table creates the relationship between the Task and the Follower, linking them together.

How to Report on Followers of a Task

To report on the tasks that users are following, you can create a report on the live_group_member table. Here’s what to focus on:

•Group (Task): This column references the Task that is being followed.

•Member (Follower): This column references the user who is following the Task.

Important Filter:

Make sure to filter the report with the condition State = Admin to focus on active followers.

Additional Tips:

If you want to include more fields from the user or the task in your report, you will need to create a Database View. This view can join the necessary tables to pull in additional details like the user’s mail or the task’s description through document field.

By following these steps, you should be able to generate a comprehensive report showing the tasks being followed and by whom.

If this solution helps, please mark this response as helpful!

[Mark Manders]

You are already being notified when something happens, so why an extra report? 

That's probably also the reason that you can't report on it. It's not a field on the form that's set. You aren't made part of the watchlist, you are just getting notified on work notes and comments.

[shelley0366]

Hi, I don't want to have to trawl through emails looking for an update in particular request, as I follow quite a lot of requests

This is why I was looking to see if you could create a report 

Shame its not possible, as it would be really useful

[Jean-Emmanuel · Accepted solution]

Hi @shelley0366 

The behavior of the “Follow” button involves several key records, but let’s simplify it for you.

When a user clicks the Follow button, three tables in ServiceNow are involved:

1. live_group_profile: This table contains records for the Task being followed.

2. live_profile: This table stores information about the Follower (the user who clicked “Follow”).

3. live_group_member: This table creates the relationship between the Task and the Follower, linking them together.

How to Report on Followers of a Task

To report on the tasks that users are following, you can create a report on the live_group_member table. Here’s what to focus on:

•Group (Task): This column references the Task that is being followed.

•Member (Follower): This column references the user who is following the Task.

Important Filter:

Make sure to filter the report with the condition State = Admin to focus on active followers.

Additional Tips:

If you want to include more fields from the user or the task in your report, you will need to create a Database View. This view can join the necessary tables to pull in additional details like the user’s mail or the task’s description through document field.

By following these steps, you should be able to generate a comprehensive report showing the tasks being followed and by whom.

If this solution helps, please mark this response as helpful!

[Jean-Emmanuel · Accepted solution]

@shelley0366 Here an example of report configuration to reach you requirement: