Input

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

Data

Total Results: 43 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/7.2.22	emsc-csem.org	17546.0	emsc-csem.org	2023-10-16 02:40:08.514688-07:00	2024-06-12 00:38:59.528670-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	futbin.com	69743.0	www.futbin.com	2023-10-16 02:41:51.082152-07:00	2024-06-03 06:31:12.666368-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	vietteltelecom.vn	102689.0	vietteltelecom.vn	2023-10-15 03:36:51.657783-07:00	2024-07-01 14:56:40.836442-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	viettel.vn	134855.0	viettel.vn	2023-10-15 03:35:08.395467-07:00	2024-06-30 16:32:44.623749-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	literaturhaus.at	176448.0	www.literaturhaus.at	2023-10-15 04:34:37.435851-07:00	2024-12-05 02:26:43.073670-08:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	themichaelresorts.com	222635.0	themichaelresorts.com	2023-10-16 02:43:34.479410-07:00	2024-02-03 01:47:02.988515-08:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	sussexcountyde.gov	226058.0	sussexcountyde.gov	2023-10-15 04:46:55.144783-07:00	2024-12-05 03:46:17.587778-08:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	eheim.com	251433.0	eheim.com	2023-10-15 04:38:43.071278-07:00	2024-09-16 04:21:49.018922-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	tjarksa.com	256635.0	tjarksa.com/xf	2024-01-13 11:18:55.419325-08:00	2024-01-13 03:02:45.456444-08:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	tokyo-pack.jp	283971.0	www.tokyo-pack.jp	2023-10-15 08:05:09.248811-07:00	2024-12-08 05:09:36.182462-08:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	emsc.eu	296435.0	emsc.eu	2023-10-15 05:27:19.238843-07:00	2024-03-25 03:57:47.129958-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	allvent.co.kr	296558.0	allvent.co.kr	2024-05-25 13:56:23.893096-07:00	2024-10-12 03:31:53.170834-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	abn-tv.co.jp	308444.0	www.abn-tv.co.jp	2023-10-24 14:35:51.960151-07:00	2024-12-01 04:52:11.763268-08:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	jisangmarket.kr	336941.0	jisangmarket.kr	2023-10-15 04:34:58.973905-07:00	2024-10-11 06:50:39.580258-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	lifefnb.com	365252.0	lifefnb.com/bbs/login	2023-10-15 07:31:53.764535-07:00	2024-05-28 08:20:45.724385-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	gangwonheemang.com	374449.0	gangwonheemang.com	2024-10-12 15:16:54.910759-07:00	2024-10-12 04:56:48.382846-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	nordast.ru	408096.0	nordast.ru	2023-11-09 01:44:52.509500-08:00	2024-05-27 15:54:51.157023-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	cinemaescapist.com	449861.0	cinemaescapist.com	2023-10-15 06:11:23.523830-07:00	2024-12-10 10:11:36.275385-08:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	tencarat.co.jp	511742.0	tencarat.co.jp	2023-10-15 10:14:27.391840-07:00	2024-09-02 11:16:42.234543-07:00	lower(http_request.response_headers) contains 'php/7.2.22'
Php/7.2.22	visitsoutherndelaware.com	548843.0	visitsoutherndelaware.com	2023-10-15 09:03:21.450485-07:00	2024-05-25 17:06:50.337919-07:00	lower(http_request.response_headers) contains 'php/7.2.22'