Skyvia offers detailed logs of all data access and manipulation operations for all your endpoints. A basic version of the log is displayed on the Endpoint Details page for every endpoint. It can display the endpoint activity (the number of calls to the endpoint) for the current day (displays the number of calls per hour) and the last 7 or 30 days (displays the number of calls per hour). You can switch the period, for which the activity is displayed, by clicking the Today or Last 7 Days or Last 30 Days button. To see the exact number of calls in a period, point to the corresponding bar, and the number of calls will be displayed.
To see a more detailed log, click the Log button. Detailed log describes the list of all the requests to the endpoints for a selected date or a range of dates. For each request it displays the following information:
|•||Type of the HTTP request.|
|•||Remote IP address of the request.|
|•||The User, who performed the request.|
|•||The date and time of the request.|
|•||The log of the request execution (when applicable), including data source access operations and SQL statements, executed against the data source, and time these operations took.|
With this log you can easily view all the activity on your endpoint for the specified date, and see which users performed which operations from which IPs. You can also filter the requests depending on their result and display only successful or failed requests. To do it, click Failed or Successful buttons at the top left corner of the page.
To change a date, for which the requests are displayed, click the calendar button alt the top right corner of the page and select the necessary date. You can also switch to the previous or next day by clicking the < and > buttons.
To display log for a range of dates, click Range and specify the start and end dates of the range.
Skyvia displays 10, 25, or 50 requests on a page. You can select how many requests to display by selecting a number in the Items list. You can navigate between pages of the log by clicking the buttons.