User Impersonation report in ServiceNow Kingston

[georgechen]

Hello folks, 

I've come to take a challenge to build a reporting in system with user impersonation which will be used by Management to use in case any reasons may raise. 

I have some investigation from ServiceNow Doc and noticed a sys_property can be enabled to enable the logging, however, the OOTB log appears to be very basic (in syslog table), 

This is a concept only screenshot I wish to build 

I was wondering if anyone has built something similar or known any plug-in, that would accommodate this sort of reportability? 

Thanks in advance. 

[georgechen]

Hello Ahmmed, 

just to share my first attempt to create Script Action against impersonation.start,

When this is set, and i start impersonating users, it writes to sys_log which is looking good, but in the script not sure I have current object , if not, I need to query sysevent table to fetch parm2 which is the impersonating user and the sys_created_on to write onto my customer table. 

Will keep working on this and share 

Thanks again. 

[Ahmmed Ali · Accepted solution]

Hello George,

I tried below code and it worked.

but in above parm1 and parm2 giving user ID, not full name. you can get full name by querying user table.

but by thought was to user a custom table to store these logs, as system log table will have very huge data, and i think (not sure) it will be cleared after a specified time.

so by storing his data on a new custom table, you have a historical data also (if needed).

else system log is good.

Thanks,

Ali

[HarshTimes]

You need to create a script action instead of the business rule. in the script you can capture the param1 and param2 add put them in a table

[georgechen]

Thanks Harshtimes, just realised this

Your tip is very helpful