Input

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

Data

Total Results: 204 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/8.2.6	wdr.de	2166.0	blog.wdr.de/digitalistan	2023-10-15 20:56:35.515289+00:00	2024-02-18 14:09:03.301101-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	e-monsite.com	2912.0	www.e-monsite.com	2023-10-16 09:23:22.789681+00:00	2024-12-23 01:16:43.022230-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	quarks.de	22270.0	www.quarks.de	2023-10-16 08:29:45.222754+00:00	2024-06-09 00:36:13.237015-07:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	ittf.com	24191.0	www.ittf.com	2023-10-16 08:29:45.222754+00:00	2024-12-23 00:32:20.484997-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	unib.ac.id	24216.0	www.unib.ac.id	2023-10-16 08:45:00.280449+00:00	2024-12-23 00:35:34.131555-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	iclarified.com	30656.0	www.iclarified.com	2023-10-18 08:14:43.048695+00:00	2024-02-17 00:34:01.358403-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	printdirect.ru	36426.0	printdirect.ru	2023-10-15 09:41:24.852886+00:00	2024-12-12 02:06:39.353692-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	minzdravrso.ru	39376.0	minzdravrso.ru	2023-10-30 01:58:10.602114+00:00	2023-12-12 00:24:25.510547-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	marathi.tv	45455.0	www.marathi.tv	2023-10-15 10:17:04.380258+00:00	2023-10-30 00:50:25.808808-07:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	macewan.ca	48648.0	www.macewan.ca/home	2023-10-16 09:12:51.151783+00:00	2024-02-20 00:45:50.861771-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	kanazawa21.jp	49760.0	kanazawa21.jp	2024-04-01 11:17:41.229564+00:00	2024-12-12 02:50:52.732292-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	rp5.ru	53457.0	rp5.ru	2023-10-17 20:17:50.847970+00:00	2023-11-17 00:24:27.440464-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	maps.com	54608.0	www.maps.com	2023-10-16 09:41:51.082152+00:00	2023-10-17 00:27:45.257134-07:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	emyspot.com	61039.0	www.emyspot.com	2023-10-16 09:10:05.102012+00:00	2024-12-23 00:54:32.872279-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	matson.com	64005.0	www.matson.com	2023-10-15 09:41:28.943494+00:00	2024-03-25 00:36:45.181142-07:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	1sweetbonanza.com	72669.0	1sweetbonanza.com	2024-09-11 07:28:55.258391+00:00	2024-10-04 13:02:43.947354-07:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	medcom.ru	85693.0	medcom.ru	2023-10-15 11:21:47.511336+00:00	2023-10-24 01:52:39.586976-07:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	eg-online.ru	92713.0	www.eg-online.ru	2023-10-18 09:10:49.563065+00:00	2024-12-07 02:05:47.265797-08:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	agsvv.ru	100278.0	agsvv.ru	2023-10-15 09:42:39.409345+00:00	2024-04-29 04:06:14.652550-07:00	lower(http_request.response_headers) contains 'php/8.2.6'
Php/8.2.6	prostopleer.com	105672.0	prostopleer.com	2023-10-15 10:32:56.731483+00:00	2023-11-16 00:54:34.595242-08:00	lower(http_request.response_headers) contains 'php/8.2.6'