-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDynatrace CDN
More file actions
15 lines (14 loc) · 1.54 KB
/
Copy pathDynatrace CDN
File metadata and controls
15 lines (14 loc) · 1.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SELECT "Dynatrace CDN" as Vendor , table_name, count(*) AS counter
FROM
(SELECT *, "2020 Desktop" as table_name FROM httparchive.response_bodies.2020_01_01_desktop WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2020 Mobile" as table_name FROM httparchive.response_bodies.2020_01_01_mobile WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2019 Desktop" as table_name FROM httparchive.response_bodies.2019_01_01_desktop WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2019 Mobile" as table_name FROM httparchive.response_bodies.2019_01_01_mobile WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2018 Desktop" as table_name FROM httparchive.response_bodies.2018_01_01_desktop WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2018 Mobile" as table_name FROM httparchive.response_bodies.2018_01_01_mobile WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2017 Desktop" as table_name FROM httparchive.response_bodies.2017_01_01_desktop WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2017 Mobile" as table_name FROM httparchive.response_bodies.2017_01_01_mobile WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2016 Desktop" as table_name FROM httparchive.response_bodies.2016_01_01_desktop WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)')),
(SELECT *, "2016 Mobile" as table_name FROM httparchive.response_bodies.2016_01_01_mobile WHERE REGEXP_MATCH(url, r'(js-cdn.dynatrace.com)'))
GROUP BY table_name
ORDER BY table_name desc;