Input

field	value
Query:	SELECT 'Mod_ssl/2.8.24' 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] = 'mod_ssl/2.8.24' 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] = 'mod_ssl/2.8.24'::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] = 'mod_ssl/2.8.24'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 39 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Mod_ssl/2.8.24	koreapartner.biz	90983.0	koreapartner.biz	2023-10-15 09:41:26.437800+00:00	2024-05-29 04:28:43.636780-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	hstechno.com	91581.0	hstechno.com	2023-10-15 09:41:26.437800+00:00	2024-05-30 05:27:50.074223-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	taxtrade.co.kr	92531.0	taxtrade.co.kr	2023-10-15 09:41:31.500275+00:00	2024-05-29 04:27:14.686017-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	japanbizkorea.com	92546.0	japanbizkorea.com	2023-10-15 09:41:27.845959+00:00	2024-05-29 04:59:32.542113-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	cwpni.com	95427.0	cwpni.com	2023-10-16 09:43:34.479410+00:00	2024-03-15 00:39:39.583883-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	daewoongbio.net	96517.0	daewoongbio.net	2023-10-15 09:41:28.943494+00:00	2024-05-29 05:02:57.555660-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	jpiano.net	99116.0	jpiano.net	2023-10-15 09:41:24.852886+00:00	2024-05-30 05:42:28.141460-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	se-eek.co.kr	100200.0	se-eek.co.kr	2023-10-15 09:41:22.676770+00:00	2024-03-12 00:48:25.710943-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	lumieye.com	100941.0	lumieye.com	2023-10-15 09:41:30.298350+00:00	2024-05-29 05:12:05.362615-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	goodmetal.co.kr	102374.0	goodmetal.co.kr	2023-10-15 09:41:22.676770+00:00	2024-05-29 04:50:20.662733-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	dury114.com	103474.0	dury114.com	2023-10-15 09:41:24.852886+00:00	2024-05-29 04:56:07.398457-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	nahwoo.com	103685.0	nahwoo.com	2023-10-15 09:41:27.845959+00:00	2024-05-29 05:23:36.214062-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	kemt.co.kr	103903.0	kemt.co.kr	2023-10-15 09:41:30.298350+00:00	2024-05-30 05:41:49.962474-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	sejinroad.co.kr	104465.0	sejinroad.co.kr	2023-10-15 09:42:45.998931+00:00	2023-12-22 01:31:17.026562-08:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	lotteca.co.kr	104866.0	lotteca.co.kr	2023-10-15 09:41:26.437800+00:00	2024-05-29 05:14:54.684239-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	mpsword.com	105234.0	mpsword.com	2023-10-15 09:41:24.852886+00:00	2024-05-30 05:43:18.504469-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	bc-ms.co.kr	105433.0	bc-ms.co.kr	2023-10-15 09:41:24.852886+00:00	2024-04-07 01:01:51.431374-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	ilsungwarehouse.com	105447.0	ilsungwarehouse.com	2023-10-15 09:41:22.676770+00:00	2024-05-30 05:37:38.617002-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	twtqedu.com	106977.0	twtqedu.com	2023-10-15 09:41:27.845959+00:00	2024-05-29 05:23:26.848903-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'
Mod_ssl/2.8.24	goryoabacus.co.kr	107177.0	goryoabacus.co.kr	2023-10-15 09:42:43.082224+00:00	2024-05-30 05:52:32.796383-07:00	lower(http_request.response_headers) contains 'mod_ssl/2.8.24'