Input

field	value
Query:	SELECT 'Php/7.2.17' AS technology_name ,domain ,global_rank ,url_matchable AS url ,created AS first_seen ,last_seen ,CASE WHEN indicator_matchable[2] = 'plain' THEN 'lower(' || indicator_matchable[3] || '.' || indicator_matchable[4] || ') contains ''' || indicator_matchable[1] || '''' ELSE indicator_matchable[3] || '.' || indicator_matchable[4] || ' is regex match of ''' || indicator_matchable[1] || '''' END AS indicator FROM indicator_detection_domain_rollup WHERE (indicator_matchable[1] = 'php/7.2.17' AND indicator_matchable[2] = 'plain' AND indicator_matchable[3] = 'http_request' AND indicator_matchable[4] = 'response_headers') ORDER BY global_rank ASC NULLS LAST

Query Plan

Download: csv json

Query Plan
Limit (cost=3485.21..3486.06 rows=20 width=117)
-> Result (cost=3485.21..3521.68 rows=858 width=117)
-> Sort (cost=3485.21..3487.36 rows=858 width=168)
Sort Key: global_rank
-> Bitmap Heap Scan on indicator_detection_domain_rollup (cost=61.64..3462.38 rows=858 width=168)
Recheck Cond: ((indicator_matchable[1] = 'php/7.2.17'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))
-> Bitmap Index Scan on indicator_detection_domain_rollup_indicator_matchable_arr_idx (cost=0.00..61.43 rows=858 width=0)
Index Cond: ((indicator_matchable[1] = 'php/7.2.17'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 96 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/7.2.17	emsc-csem.org	17546.0	emsc-csem.org	2023-10-18 02:07:48.165354-07:00	2024-02-04 00:23:20.436029-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	policymaker.io	28858.0	policymaker.io	2023-10-16 01:13:44.105098-07:00	2024-12-23 00:48:11.017059-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	be1.ru	38092.0	be1.ru	2023-10-16 01:46:37.479980-07:00	2024-12-12 02:13:29.825699-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	netimperative.com	52241.0	www.netimperative.com	2023-10-16 02:41:51.082152-07:00	2024-12-23 00:44:43.978547-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	mmiwg-ffada.ca	59621.0	mmiwg-ffada.ca	2023-10-15 02:41:28.943494-07:00	2024-12-23 01:09:28.331846-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	hochu.ua	93184.0	hochu.ua	2023-10-15 03:37:28.527503-07:00	2023-12-09 05:14:05.161794-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	adomonline.com	106380.0	www.adomonline.com	2023-10-15 04:21:56.262500-07:00	2024-07-03 16:21:32.002615-07:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	acquisio.com	112372.0	www.acquisio.com	2023-10-15 03:36:42.581676-07:00	2024-12-11 03:10:25.805948-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	eventize.com.br	121891.0	www.eventize.com.br	2023-10-15 03:41:06.019592-07:00	2024-12-05 01:49:39.914344-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	chinaredflag.cn	147328.0	bbs.chinaredflag.cn	2023-11-16 06:08:33.860040-08:00	2024-07-06 16:57:33.492668-07:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	rinnapp.com	147431.0	rinnapp.com	2023-10-16 01:56:02.570067-07:00	2024-09-20 02:33:34.828069-07:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	gingertea.ru	156358.0	gingertea.ru	2023-10-15 05:41:15.779695-07:00	2024-12-06 03:52:54.454336-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	jihosoft.com	172165.0	www.jihosoft.com	2023-10-21 15:33:06.642273-07:00	2024-07-03 16:15:08.322729-07:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	lacittadella.co.jp	203212.0	lacittadella.co.jp	2023-10-15 04:47:19.627870-07:00	2024-12-09 03:29:50.982170-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	kairos.com	248455.0	kairos.com	2023-10-15 04:38:40.556887-07:00	2024-02-04 04:13:15.388356-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	tjoy.jp	251795.0	tjoy.jp	2023-10-15 05:48:03.567747-07:00	2024-12-23 06:17:09.166063-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	explora.cl	279023.0	www.explora.cl	2023-10-15 05:41:03.130000-07:00	2024-12-04 05:22:03.330627-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	transparenciainternacional.org.br	281695.0	transparenciainternacional.org.br	2023-10-15 05:49:00.587668-07:00	2023-11-02 03:01:03.160342-07:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	scienceweek.net.au	282426.0	www.scienceweek.net.au	2023-10-15 05:13:38.488672-07:00	2024-02-20 05:13:58.295700-08:00	lower(http_request.response_headers) contains 'php/7.2.17'
Php/7.2.17	peigenesis.com	286252.0	www.peigenesis.com	2023-10-17 13:11:24.911612-07:00	2024-02-16 04:28:01.543248-08:00	lower(http_request.response_headers) contains 'php/7.2.17'