Do you need to find details about slow queries coming from inbound integration calls to APIs? Below are three tables that can serve as a starting point:
| Table | Filter using | Relevant fields |
| Slow queries (sys_query_pattern) |
Example Java stack trace starts with API_INT
API_INT indicates an API call was made.
|
Example URL
This field displays the API call made, for example:
/api/now/table/incident
state=1
category=Software
Average execution time (ms)
|
| Transactions (syslog_transaction) |
Type = REST
Created by = [The integration user used by the other application to authenticate]
|
URL
This field displays the API call made, for example:
/api/now/table/incident?state=1&category=Software
Response time
|
| Log (syslog) |
Level = Warning
Message starts with Cancelling transaction
(For transactions that exceed the maximum REST Table API transaction quota rule [default = 60 sec])
|
Message
Contains the API call made.
|
