identifying users with tasks from a list view

[Phil O_shea]

Hi Friends,

On implementation of Snow we leveraged AD as our user provisioning and now planning on switching to an Identity governance app SailPoint to create users within the tool instead....

need a way to cleanup the inherited mess we obtained from AD and identify\delete users that have no associated tasks\links to fields.

In Short: i would like to see a task count associated to a user in a list view.

if the user has no tasks assigned to them, then i will be able to identify that at a first glance instead of opening the record.  

Phil.

[ruzzty06]

If you want to delete the user, then just create a background script? I think you have more work to do if you wanna see the task count as a field on the user table and deleting it manually.

[Phil O_shea]

hmmm, ok, i hadn't thought of that.

Currently i am looking at each user and seeing if they have any tasks assigned to/requested by them and then assigning there tasks to the correct user account (mostly due to there is a duplication of that user).

I will have a troll though the community to see if anyone has built a script to do just this or something similar that i can modify (i am still learning on the scripting side of things)

Thanks Rusty for the idea.

[Celliven]

Hi Philip

I could be missing your point, though you could run a custom report to look at all tasks and group by user and or type.

I just did a quick test using the 'My Tasks' list and modified the filter to get rid of the assigned to me, then grouped by 'assigned to'. I then filtered to remove the private tasks.

This is quick and easy and can be exported to excel.

Hopefully this is what you are looking for.

Chris

[Phil O_shea]

getting there

My User admin has provided me with a specific list of users that are duplicated in service-now (incorrectly created with no person ID that has a duplicate username WITH a person id).

So in essence some tasks may have been assigned to this incorrect user and i need to identify the users with tasks as opposed to the users without.

I can make short work of the users without by a mass deletion.

This will leave me with a the few with tasks and i can transfer the records to their correct account.

I'm sorry if this is confusing.

Just trying to make light work of a large repetitive task while i figure out a long term solution to prevent this in the future.