Input

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

Data

Total Results: 95 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/8.1.15	nyit.edu	19339.0	www.nyit.edu	2023-10-16 02:41:32.700533-07:00	2023-11-09 00:29:01.664760-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	thekeylab.co.uk	22305.0	www.thekeylab.co.uk	2023-10-16 02:24:31.826640-07:00	2023-12-05 00:30:27.455102-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	namnak.com	45971.0	namnak.com	2024-12-04 09:11:43.125722-08:00	2024-12-04 01:45:01.874144-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	donotlink.com	80165.0	www.donotlink.com	2023-10-15 04:22:02.051440-07:00	2023-12-10 01:25:55.395699-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	teamsideline.com	83212.0	go.teamsideline.com	2023-10-15 03:36:50.503608-07:00	2024-11-24 02:06:36.303580-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	onlinecasinodollar.com	101318.0	www.onlinecasinodollar.com	2023-10-15 02:42:49.788165-07:00	2024-07-08 11:10:07.523965-07:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	erfelijkheid.nl	124412.0	erfelijkheid.nl	2023-10-15 04:21:47.511336-07:00	2023-12-13 02:15:35.979948-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	allcasino.org	129765.0	www.allcasino.org	2023-10-15 03:37:32.589065-07:00	2024-11-25 02:49:50.953268-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	bristol-cathedral.co.uk	137364.0	bristol-cathedral.co.uk	2023-10-31 08:11:23.478953-07:00	2024-03-28 01:41:26.017081-07:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	mabulle.com	140980.0	mabulle.com	2023-10-15 05:02:12.112668-07:00	2023-12-10 02:25:02.539689-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	graffer.jp	164954.0	graffer.jp	2023-10-16 03:14:19.871897-07:00	2024-01-03 02:32:29.845735-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	handysektor.de	216863.0	www.handysektor.de/startseite	2023-10-15 04:26:58.338739-07:00	2024-01-18 02:23:18.238743-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	via-la.com	220111.0	www.via-la.com	2023-10-15 03:17:04.380258-07:00	2024-12-13 13:00:11.341179-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	isuisse.com	225188.0	isuisse.com	2023-10-15 04:38:40.556887-07:00	2023-12-10 02:13:16.386721-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	sciencenorth.ca	232186.0	www.sciencenorth.ca	2023-10-16 03:12:45.223446-07:00	2024-12-13 04:03:01.131573-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	barrgroup.com	245234.0	barrgroup.com	2024-02-07 15:53:52.924390-08:00	2024-06-16 10:08:57.189923-07:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	synology-forum.de	246396.0	www.synology-forum.de	2023-10-15 07:31:24.774482-07:00	2024-12-11 06:01:43.935829-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	thegoodocs.com	292263.0	thegoodocs.com	2023-10-15 04:27:37.710904-07:00	2024-12-08 05:12:21.312276-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	up-ar.biz	303012.0	up-ar.biz	2023-10-15 03:36:37.896659-07:00	2023-11-15 01:05:36.542875-08:00	lower(http_request.response_headers) contains 'php/8.1.15'
Php/8.1.15	afvalbakkenwinkel.nl	319826.0	www.afvalbakkenwinkel.nl	2023-10-15 06:58:15.837787-07:00	2023-11-04 03:58:17.521371-07:00	lower(http_request.response_headers) contains 'php/8.1.15'