- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 10:12 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 10:50 AM
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
Cheers..!
Happy Learning:)
Tushar

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-16-2022 05:34 PM
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
Cheers..!
Happy Learning:)
Tushar

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 10:19 AM
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
Cheers..!
Happy Learning:)
Tushar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 10:36 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 10:50 AM
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
Cheers..!
Happy Learning:)
Tushar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2022 12:38 AM
Is there any way to get user activity/audit log for new users from creation till up to a week or 2