servicenow/userRoleQueries.js at master · t1mb0b/servicenow · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
var user = new GlideRecord('sys_user');
user.addActiveQuery();
user.query();
var count = 0;
while(user.next()){

     var role = new GlideRecord('sys_user_has_role');
     role.addQuery('user', user.sys_id);
     role.addQuery('role.name', 'u_graham_timesheets');
     role.query();
     if(role.hasNext()){
          count++;
     }
}
gs.print(count);

====

var user = new GlideRecord('sys_user');
user.addActiveQuery();
user.query();
var count = 0;
while(user.next()){

     var role = new GlideRecord('sys_user_has_role');
     var queryString = "role.name=itil^ORrole.name=u_graham_timesheets^ORrole.name=admin";
     role.addQuery('user', user.sys_id);
     //role.addQuery('role.name', 'itil');
     role.addEncodedQuery(queryString);
     role.query();
     if(role.hasNext()){
          count++;
     }
}
gs.print(count);

====

var user = new GlideRecord('sys_user');
user.addActiveQuery();
user.query();
var count = 0;
while(user.next()){

     var role = new GlideRecord('sys_user_has_role');
     var queryString = "role.name=itil^ORrole.name=u_graham_timesheets^ORrole.name=admin";
     role.addQuery('user', user.sys_id);
     //role.addQuery('role.name', 'itil');
     role.addEncodedQuery(queryString);
     role.query();
     if(role.hasNext()){
          //count++;
          gs.print(user.name + " has " + role.name);
     }
}
//gs.print(count);

=====

var user = new GlideRecord('sys_user');
user.addActiveQuery();
user.query();
while(user.next()){
     var role = new GlideRecord('sys_user_has_role');
     var queryString = "role.name=itil^ORrole.name=u_graham_timesheets^ORrole.name=admin";
     role.addQuery('user', user.sys_id);
     role.addEncodedQuery(queryString);
     role.query();
     while(role.next()){
          gs.print(user.name + ", " + role.role.name + ", " + role.granted_by.name + ", " + user.last_login_time);
     }
}


=======


var user = new GlideRecord('sys_user');
user.addActiveQuery();
user.query();
while(user.next()){
     var role = new GlideRecord('sys_user_has_role');
     var queryString = "role.name=itil^ORrole.name=u_graham_timesheets";
     role.addQuery('user', user.sys_id);
     role.addEncodedQuery(queryString);
     role.query();
     while(role.next()){
          gs.print(user.name + ", " + user.email + ", " + role.role.name);
     }
}