How to show only active users on reports

[Priyanka132]

Hi All,

We have requirement to make "active=true" to be a mandatory filter on all reports being created on the sys_user table. Our user table is very large and has a large data of inactive users. Hence, any query on sys_user table from report should query only active users (additional filters can be included as per reports requirement).

[Omkar Mone · Accepted solution]

Hi 

Try writing a before query BR on it. 

Something like this  :-

var tm = '';
var as = new GlideRecord('sys_user');
as.addQuery('active','true');
as.query();
while(as.next())
{
tm += as.name +',';
gs.addInfoMessage('ACTIVE User List : " +tm);
}