Record updated by

[Nenad Berbatovi]

Hello,

I would like to make a report on INC not updated by itil role last 5 days. Is it possible and how?

Best regards,

Nenad

[Ankur Bawiskar]

@Nenad Berbatovi 

not straight forward to achieve this

You can use scripted approach and use script in report filter conditions

1) create classless script include like this

function getIncidents() {
    var arr = [];
    var gr = new GlideRecord('incident');
    gr.addActiveQuery();
    gr.addQuery('sys_updated_on', '<=', gs.daysAgoStart(5));
    gr.query();
    var count = 0;
    while (gr.next()) {
        var updater = gr.sys_updated_by;
        if (updater) {
            var ugr = new GlideRecord('sys_user_has_role');
            ugr.addQuery('user.user_name', updater);
            ugr.addQuery('role.name', 'itil');
            ugr.query();
            if (!ugr.hasNext()) {
                arr.push(gr.getUniqueValue())
            }
        }
    }
    return arr.toString();

}

2) then call like this Sys ID [IS ONE OF] javascript: getIncidents();

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