Method: getApplicationBrowserTableData
Retrieve data from the application browser.
Parameters
| Name | Type | Description |
|---|---|---|
| tableId | int | The table to retrieve the data from, available options are:
0 – appid_attribute (client & server data) 1 – appid_datapoint (application data) 2 – topn_tables 3 – application_usage_default (hourly application data) 4 – application_usage_hr_default (high rate application data) |
| target | string | The target to retrieve data from, available options are:
application application_group location profile target_address client target source target_type datafamily user_data TopN specific targets: appsByClient server |
| statistics | string | The statistic to retrieve, available options are:
byte_count – total byte count flow_count – total flow count target_address – client/server IP address app_rsp_time – application response time tcp_rsp_time – network response time total – total clients, used with TopN tx_byte_count – transmit byte count rx_byte_count – receive byte count tx_flow_count – transmit flow count rx_flow_count – receive flow count client_count – client count server_count – server count application_count – application count user_data – user data contains different fields based on the tableId all_stats – all the above stats |
| searchCriteria | string | Key value (key=value) pair used in the database query. The available targets, with the exception of TopN, and statistics can be used as a key. |
| start | long | Starting timestamp for the query in milliseconds |
| end | long | Ending timestamp for the query in milliseconds |
| limit | int | Number of results to return |
| queryType | string | Query type, available options are:
grid chartovertime |
| aggType | string | Aggregation type, available options are:
SUM – sum AVG - average |
Returns
Returns a TableData with a structure defined by the following table.
| Name | Type | Description |
|---|---|---|
| extraData | anyType | Additional data from the operation |
| lastChange | long | Timestamp of last valid data |
| noChange | boolean | True if the data is being stored |
| success | boolean | True if operation is successful |
| tableData | string | JSON data |
Example
Execute the following web service with a browser:
Retrieve all the statistics for Facebook from the hourly table.
https://10.120.85.90:8443/axis/services/PurviewWebService/getApplicationBrowserTableData?tableId=3&target=application&statistics=all_stats&searchCriteria=application=Facebook&start=1464235200000&end=1464321600000&limit=100&queryType=grid&aggType=AVG
Retrieve the total bytes for the top application groups from the hourly table.
https://10.120.85.90:8443/axis/services/PurviewWebService/getApplicationBrowserTableData?tableId=3&target=application_group&statistics=byte_count&searchCriteria=&start=1464235200000&end=1464321600000&limit=100&queryType=grid&aggType=SUM
