can we bring the History(audit) of user in the related list of sys_user table?

Service Manager
Kilo Guru

Hi,

Can we bring the user history in the related list of user table(next to roles, groups, Delegates....

how could we configure the view

Right Click header --> history --> calendar

into a related list or tab

Thanks

1 ACCEPTED SOLUTION

Please follow below to turn on audit on sys_user table.

-- Navigate to System Definition --> Dictionary

- Open below record for dictionary on your instance.

 

find_real_file.png

 

- Click on audit to true for this record and save dictionary record.

 

find_real_file.png

 

- After you turn on audit for sys_user table, you can configure activity for-matter for sys_user table to see old and new values for user records.

 

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/form-administration/concept/c_ActivityFormatter.html#t_AddTheActivityFormatterToAForm

 

Regards,

Sachin

 

Regards,

Sachin

 

View solution in original post

6 REPLIES 6

Prateek kumar
Mega Sage

Right Click on the user record, configure>Related list and bring History->USer from available to selected.


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Would like to bring the records as below

 

Thanks

sachin_namjoshi
Kilo Patron
Kilo Patron

sys_user table is NOT audited OOB.

You need to turn on audit on sys_user table first and then you can configure activity for-matter on user table to show changed field values.

 

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/security/task/t_EnableAuditingForATable.html

 

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/form-administration/concept/c_ActivityFormatter.html

 

Regards,

Sachin

Hi,

Thanks for your response!

Could you break down the steps to turn on the audit on sys_user table cause I looked into the tables and dictionary perspective couldn't turn on the audit history

I tried to turn on the audit via field perspective on dictionary but I couldn't save

FYI, based on the documentation

Sys_user table is already a part of glide.ui.audit_deleted_tables properties in my instance.

Besides this option, is there any alternative method of tracking the audit history of users?

Thanks