How to identify Service Catalog items linked to specific approver groups?

nameisnani · 3 weeks ago

Hi Community,

I need help identifying the list of Service Catalog items that are associated with the following approver groups:

FSD-FCIT_SM-APR
FSD-FCIT_SO-APR

This is an information-only requirement. I am not looking to modify any workflows or approvals, just to understand where these groups are currently used as approvers (via catalog item approvals, workflows, flows, or approval rules).

Could you please suggest the best approach or tables to check to extract this information accurately?

If possible please provide Screenshots for better understanding .

Thanks in advance for your guidance.

Ankur Bawiskar · 3 weeks ago

@nameisnani

Background script like this, please enhance

var groups = ['CAB Approval'];

var catItems = {};
var groupGr = new GlideRecord('sysapproval_group');
groupGr.addQuery('assignment_group.name', 'IN', groups.join(','));
groupGr.query();

while (groupGr.next()) {
    var ritmSysId = groupGr.getValue('parent'); // sys_id of sc_req_item
    if (!ritmSysId) continue;

    var ritmGr = new GlideRecord('sc_req_item');
    if (ritmGr.get(ritmSysId)) {
        var catItemSysId = ritmGr.getValue('cat_item');
        if (catItemSysId) {
            catItems[catItemSysId] = ritmGr.cat_item.name.toString() || catItemSysId;
        }
    }
}

// Output unique catalog items
gs.info('Catalog Items with group approvals:');
for (var sysId in catItems) {
    gs.info('Sys ID: ' + sysId + ', Name: ' + catItems[sysId]);
}
gs.info('Total: ' + Object.keys(catItems).length);

Output: it gave me 2 catalog items which are using CAB Approval as approval group

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · 3 weeks ago

@nameisnani

no direct way to check in flow, but I used this approach in below link and it worked till some extent

Flow Designer - Search through flows efficiently with scripts

to search in workflow check this

Finding references / sys_ids in Workflows

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

nameisnani · 3 weeks ago

@Ankur Bawiskar I think this is not related to my query -

Ankur Bawiskar · 3 weeks ago

@nameisnani

you want to which catalog items are using either of those groups for approvals?

If that's your question then the links I shared should help you

If not then what's your query?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

nameisnani · 3 weeks ago

@Ankur Bawiskar

you want to which catalog items are using either of those groups for approvals? - YES anukur this is only my query could you pease help me here .