Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Here's the listing I've been working with: https://yaledevelopment.service-now.com/sys_user_has_role_list.do

I've been working with Alan at Fruition to build up a list of Financial Approver group members who are not also members of any other assignment group. He came up with:

https://yaledevelopment.service-now.com/financial_group_members.do

I need to vet this and see whether it is true. I spot checked for Deb Bettley and Nancy Scanlon. Both were not members of the Alan version, but are members of the overall group. As such, this seems to really work.

Isolating ITIL users who didn't get the role from Financial Approvers

So now that I have two sets of users, I really want to do set logic on it, and subtract the results of the financial_group_members.do list from the sys_user_has_role_list.do results.

I'm wondering if I can do exactly that using a script. Going to try. First, need to track down both scripts.