Hello,
I'm trying to change for testing purposes the date that a user was given a role. For example, if a user has the role of 'itil', I would like to change the "sys_created_on" value for the role on the sys_user_has_role table to 120 days before today. This is what I have currently (this is done in a PDI). I'm also running this as a background script:
var grUserRole = new GlideRecord('sys_user_has_role');
grUserRole.addQuery('role.name', 'itil'); //Filter to only itil role
grUserRole.addQuery('user.name', 'Chuck Tomasi');
grUserRole.query();
var days = new GlideDateTime();
days.addDaysUTC(-120);
while (grUserRole.next()) {
grUserRole.setValue('sys_created_on', days);
grUserRole.autoSysFields(false); //Allow manual update of sys fields
grUserRole.update();
gs.info('Updated: ' + grUserRole.user.name + ' | Role: ' + grUserRole.role.name + ' | SysCreatedOn: ' + grUserRole.role.sys_created_on);
}
When I visit the User Role page for 'itil' under the user Chuck Tomasi, the date doesn't change for the Created On field, under the User Role title at the upper left header of the page. Any help would be appreciated.
