@Florian Korbmac
You won't know that in database view because user criteria is evaluated against catalog item in run-time.
But why you want the list of users for each catalog item. The number of catalog items would be huge and sys_user will also be huge. your report will be heavy.
what you can do is this to achieve your requirement
1) create a custom table which holds Catalog item (List field) and the Users (reference field) which has access to that catalog item
2) populate this table by leveraging the User Criteria API and use fix script.
3) then report on that custom table and then you know which catalog item has which users
UserCriteria - Scoped
Script, something like this, but please enhance
Note: your script will take long time as it will iterate each record of the table "sc_cat_item_user_criteria_mtom" and for all user records
// query sc_cat_item_user_criteria_mtom table and pick the criteria sysId and the catalog item
var gr = new GlideRecord("sc_cat_item_user_criteria_mtom");
gr.query();
while (gr.next()) {
var userSatisfying = [];
var itemArr = [];
var criteriaSysId = gr.getValue('user_criteria');
var userRec = new GlideRecord("sys_user");
userRec.addActiveQuery();
guserRecr.query();
while (userRec.next()) {
var userMatches = sn_uc.UserCriteriaLoader.userMatches(userRec.getUniqueValue(), criteriaSysId);
if (userMatches)
itemArr.push(gr.getValue('sc_cat_item'));
}
// now you get all users satisfying this catalog item, insert record into that table
}
If my response helped please mark it correct and close the thread so that it benefits future readers.
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
