How to find active departments that users are member of?

[Sathiskumar_D]

Hello,

I need to find the "active" department that users are part of. I tried the following code but the answer is null. Could someone help me ?

var deptArr = gs.getUser().getUserByID('sys_id').getDepartmentID();
var myDept = [];
myDept.push(deptArr);
//  gs.info("depts are " + typeof myDept+ "users dept are :" +myDept);
for (var i = 0; i < myDept.length; i++) {
    var deptGr = new GlideRecord('cmn_department');
    deptGr.addQuery('u_active', true);
    deptGr.addQuery('sys_id', myDept[i]);
    deptGr.query();
    if (deptGr.next()) {
                var activeDept = [];
                activeDept.push(deptGr);
                 gs.info(activeDept);
        }
}

e

[Tony Chatfield1]

Hi, in OOB ServiceNow the relationship between cmn_department and sys_user is 1 to 1.
Meaning a user has only 1 department relationship and this is defined in their sys_user record.

I see you have added a custom 'u_active' field against department,

this would not impact the existing 1 to 1 department to user relationship and the result would be a sys_user.department that is either active = true or active = false;

but this customization will not allow you to have more than 1 department relationship, without a M2M table to define\contain this information and I do not believe that this exists OOB.

Perhaps you can clarify your configuration and requirements?
OOB the only script you need to return the sys_id of your users department is

gs.getUser().getDepartmentID();

[Omkar Mone]

Can you try this instead?

var deptArr = gs.getUser().getDepartmentID();
var myDept = [];
myDept.push(deptArr);
  //gs.info("depts are " + typeof myDept+ "users dept are :" +myDept);
for (var i = 0; i < myDept.length; i++) {
    var deptGr = new GlideRecord('cmn_department');
    deptGr.addQuery('u_active', true);
    deptGr.addQuery('sys_id', myDept[i]);
    deptGr.query();
    if (deptGr.next()) {
                var activeDept = [];
                activeDept.push(deptGr);
                 gs.info(activeDept);
        }
}

[Ankur Bawiskar]

@Sathiskumar_D 

your requirement is not clear.

Also where are you using this script?

[Sathiskumar_D]

I am using this script in script include. I tried it as an background script. I didn't get any answer.