I am trying to create a report that shows all Fulfillment Groups in Workflow Activities in an effort to find assignment groups that are no longer in use. I had set this report up in the past and it was working, but today I found out that it is no longer working. When the report is opened nothing is reported and the "Columns" slushbucket is gone. I recreated the report, and it was working up until I added the Fulfillment Group column (Variables.Catalog Task.Fulfillment Group) at which point, the report broke again. Here are the configurations for my report before it is run.
Here is what happens once the report is run:
Is this a bug or am I selecting the Fulfillment Group wrong somehow?
Hello forestoden,
I have a similar need to you and while I haven't been able to work this out as a report, I have found a way to satisfy my use case.
First of all, my use case is this: I have a group which has been disbanded and I need to find all the tasks in all the workflows where it is the fulfillment group.
Here's how I was able to do this. NOTE: This is a painful process and I invite any an all critical comments on better ways to do it.
First, display the group record to be disbanded and copy the sys_id to the clipboard ( or notepad, etc. )
Second, list the sys_variable_value table. You can enter "sys_variable_value.list' in the left nave pane filter, or use the following link:
https://YOUR_INSTANCE.service-now.com/sys_variable_value_list.do
Now filter this list for Value=<Sys_id of group>
The result is a list of wf_activity records which match the group's sys_id.
Note, that there may be multiple entries for each "catalog task specification" because you will have an entry for each version of the workflow.
It should look something like this:
