How to allow line managers to request delegates for the direct reports of their direct reports

[Aparna Gurav]

Hello All,

Could someone assist with the following requirement?

I’m working with the Request Delegate catalog item. The goal is to allow line managers to request delegates for the direct reports of their direct reports (i.e., two levels down in the org chart).

If a manager impersonates and opens this catalog item, they should only see their direct reportees and second-level reportees (i.e., the reportees of their reportees) in the "Requested For" variable on the portal.

Can anyone suggest how to implement this functionality?

[Dr Atul G- LNG]

Hi @Aparna Gurav 

This approach breaks security protocols. Even though we’re in the IT industry, we should never allow a manager to request delegation on behalf of a direct report — this is more of an exception than a rule. We should educate users that if someone is going on leave, they must set up their own delegation. Instead of shifting the burden to the manager, we could define some KRAs around this. Imagine a manager with 20 direct reports — if 5 of them are on leave, that creates a significant overhead. Now consider if this happens weekly or monthly — the impact adds up quickly.

[Ankur Bawiskar · Accepted solution]

@Aparna Gurav 

you can use advanced ref qualifier with this

something like this

javascript: var query = '';
var userId = gs.getUserID();
var users = [];

// Direct reports
var gr = new GlideRecord('sys_user');
gr.addQuery('manager', userId);
gr.query();
while (gr.next()) {
    users.push(gr.getUniqueValue());
}

// Second-level reports
if (users.length > 0) {
    var gr2 = new GlideRecord('sys_user');
    gr2.addQuery('manager', 'IN', users.join(','));
    gr2.query();
    while (gr2.next()) {
        users.push(gr2.getUniqueValue());
    }
}

query = 'sys_idIN' + users.toString(); // list of user sys_ids
query;

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Aparna Gurav]

@Ankur Bawiskar : Thank you for the response. I applied the same logic and impersonated the line manager, but now he can see the entire list of users.

[Ankur Bawiskar]

@Aparna Gurav 

share your script.

It worked fine for me

-> I am manager of 4 users

-> So I will get those 4 users

-> Then each of those reportees are again manager of some other users

-> Abel is manager of 2 users, Annabelle is manager of 2 users, Isabell is manager of 1 user, Mabel is manager of 2 users

-> Total 4+2+2+1+2 => 11 Users

Below Output = 11 Users

If my response helped please mark it correct and close the thread so that it benefits future readers.