when a user is inactive, user should be removed from the report shared by the user

[Sadashiva Das1]

when a user is inactive, user should be removed from the report shared by the user 

Please suggest any BR and Scheduled Job

[Nayan Dhamane · Accepted solution]

Hello @Sadashiva Das1 ,

Please use this script it will give you the required results

var report = new GlideRecord('sys_report_users_groups');

report.addEncodedQuery('user_id.active=false');

report.query();

while(report.next()){

report.user_id=''

report.update()

}

Please mark my answer as correct if it helps.
BR,
Nayan

[SapAuddy]

Hi Sadashiva,
It is recommended to control user access to reports via Roles and for scheduled reports via Groups.
For removal of 'inactive' user(s) from Group(s), use a scheduled job or BR to remove group membership.

Thanks, Saptarshi

[Sadashiva Das1]

Some reports are shared individually to many users . need to remove one of those .

Please suggest ,

[Nayan Dhamane · Accepted solution]

Hello @Sadashiva Das1 ,

Please use this script it will give you the required results

var report = new GlideRecord('sys_report_users_groups');

report.addEncodedQuery('user_id.active=false');

report.query();

while(report.next()){

report.user_id=''

report.update()

}

Please mark my answer as correct if it helps.
BR,
Nayan

[Gunjan Kiratkar · Accepted solution]

Hi @Sadashiva Das1 ,

You can writedown below BR on sys_user table

(function executeRule(current, previous /*null when async*/ ) {

    // Add your code here
    var reportShare = new GlideRecord("sys_report_users_groups");
    reportShare.addQuery("user_id", current.sys_id);
    reportShare.query();
    if (reportShare.next()) {
        reportShare.deleteMultiple();
    }


})(current, previous);