Audit a User's Activity in ServiceNow

tekkytommy
Tera Contributor

Hi All,

 

How do I audit the activity of a user in ServiceNow?

 

Best

Tommy

2 ACCEPTED SOLUTIONS

Yes, Check the syslog_transaction table. You will get enough information regarding the time taken for transactions. 

For More :

To look at the log, navigate to System Logs > Transactions.

To see the average response time of all listed transactions, right-click the column Response time. Select Configure > List Calculations, and then select the Average value check box.

 

Mark it as helpful or correct, If Applicable

Cheers..!
Happy Learning:)
Tushar

Mark it as helpful or correct, If Applicable


Cheers..!

Happy Learning:)

Tushar

View solution in original post

eumak
Tera Guru

Hello @Jyoti Patil ,
From my point of view, we can't write any script to achieve this.

Prefer the manual process via following below steps.
1) Get the user ID via created on filter on sys_user.
2) Use the above user ID's in the System Logs > Transactions table. You can keep additional filter of date.

Additional option you can try of is create a data base view between sys_user & Transactions table.
There you can keep the unique filed as user ID/user name. Hope this will help you to see both things on a single database view.

Let me know if anything works for you. 

Cheers...!
Tushar

Mark it as helpful or correct, If Applicable


Cheers..!

Happy Learning:)

Tushar

View solution in original post

5 REPLIES 5

eumak
Tera Guru

Hello ,
Already Servicenow use to track the activity of all the things. Are you referring to create some new table where you can store all the audits done by some user?

Cheers..!
Happy Learning:)
Tushar

Mark it as helpful or correct, If Applicable


Cheers..!

Happy Learning:)

Tushar

tekkytommy
Tera Contributor

Yes ServiceNow has the capability - I went in the Event Logs, sorted by created by. Is there a way to calculate the total time of all the users' transactions?

Yes, Check the syslog_transaction table. You will get enough information regarding the time taken for transactions. 

For More :

To look at the log, navigate to System Logs > Transactions.

To see the average response time of all listed transactions, right-click the column Response time. Select Configure > List Calculations, and then select the Average value check box.

 

Mark it as helpful or correct, If Applicable

Cheers..!
Happy Learning:)
Tushar

Mark it as helpful or correct, If Applicable


Cheers..!

Happy Learning:)

Tushar

Jyoti Patil
Tera Contributor

Is there any way to get user activity/audit log for new users from creation till up to a week or 2