Need help with a report to display all Incidents and Tasks assigned to Inactive user

[Mark Nguyen]

Hi Platform Analytics Community,

I have a requirement to report on all Incidents and Tasks assigned to a specific inactive user who is no longer with our company.

I am using Task [Task] table but got stuck in how to build the appropriate conditions to query for the inactive user.

Does anyone have any experience building this type of report? Is admin role required to be able to see inactive users in report administration?

[AndersBGS · Accepted solution]

Hi Mark,

Just utilize below filter instead:

Assigned to contains the_interactive_user_name. Remember the state - Otherwise you get also closed, resolved and so on task. 

Please also know, that the task table contains a lot - it could be you should specify to incident, request and so on.

If above answer has helped you in archiving your goal, please mark my answer as helpful or/and correct answer.

Best regards

Anders

[Mark Nguyen]

Thank you so much! This worked and I can see everything assigned to the Inactive user.