How can i check How many Records has updated in last 24 hours and who is updating?

[rakesh_mishra]

Hi,

I have below queries , can any one help me to figure out the solution of below queries?

1 . Number of   REST API call made by an user in last 24 hours.?

2.   How many records updated in a specific table [Incident/Problem] in last 24 hours?

3.   can i write a script which will execute when a user make REST API [GET] call?

Thanks in advance

Rakesh

[aswinsiddaling2]

Hi Rakesh,

1. You can use System web services - Usage overview (or) Usage by API for this

2. Same as above

3. If it is a scripted REST API, you can write your script

Please let me know if you need any additional information

Thanks and Regards,

Aswin Siddalingam

[rakesh_mishra]

Thanks Aswin,

I can see the number of API consumed , but i can't see number of records updated or created, can you please help me for the same?

[aswinsiddaling2]

You can go to 'sys_api_stats_requestor' table. This has all the information that you are looking for.

To find the inserts/updates made in any particular table, you can add filter resource=now/table/problem (For problem table in this example)

Thanks and Regards,

Aswin Siddalingam

Please mark the answer as helpful/correct if applicable

[rakesh_mishra]

Thanks Aswin, can we do same thing using UI?