SELECT * FROM web_page_api_history
WHERE page_history_date_time BETWEEN {ts '2018-06-25 00:00:01'} AND {ts '2018-06-25 23:59:59'}
ORDER BY page_history_id

around 72,368 records...


SELECT corp_id FROM web_page_api_history
WHERE page_history_date_time BETWEEN {ts '2018-06-25 00:00:01'} AND {ts '2018-06-25 23:59:59'}
GROUP BY corp_id
ORDER BY page_history_id

list of corps: 609, 581, 514, 663, 891, 550

SELECT web_page_id FROM web_page_api_history
WHERE page_history_date_time BETWEEN {ts '2018-06-25 00:00:01'} AND {ts '2018-06-25 23:59:59'}
GROUP BY web_page_id
ORDER BY page_history_id

list of methods that are being called: 234, 141, 684, 682, 138, 119, 636

SELECT corp_id, web_page_id, COUNT(*) AS page_count FROM web_page_api_history
WHERE page_history_date_time BETWEEN {ts '2018-06-25 00:00:01'} AND {ts '2018-06-25 23:59:59'}
GROUP BY corp_id, web_page_id
ORDER BY page_count DESC, corp_id

this shows counts per corp

SELECT web_page_id, actual_file_function_name FROM web_pages
WHERE web_page_id IN (234,141,684,682,138,119,636)
ORDER BY web_page_id

this will get the api function names and id's


SELECT web_page_api_history.corp_id, web_page_api_history.web_page_id, web_pages.actual_file_function_name, COUNT(*) AS page_count FROM web_page_api_history, web_pages
WHERE web_pages.web_page_id = web_page_api_history.web_page_id
AND web_page_api_history.page_history_date_time BETWEEN {ts '2018-06-25 00:00:01'} AND {ts '2018-06-25 23:59:59'}
GROUP BY web_page_api_history.corp_id, web_page_api_history.web_page_id, web_pages.actual_file_function_name
ORDER BY page_count DESC, web_page_api_history.corp_id

//////////////////////
ip address: 13.57.153.139
ip address: 13.57.143.45

user/payee id: 52903 - Bake, Baker22


SELECT payee_id, web_server_ip, COUNT(*) AS ping_count FROM web_page_api_history
WHERE web_page_id = 119
AND page_history_date_time BETWEEN {ts '2018-06-25 00:00:01'} AND {ts '2018-06-25 23:59:59'}
GROUP BY payee_id, web_server_ip
ORDER BY payee_id, web_server_ip

shows ping counts per ip address