Input

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

Data

Total Results: 344 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Php/5.3.10-1ubuntu3	fc2.com	581.0	analyzer.fc2.com	2023-10-15 13:58:15.837787+00:00	2024-12-13 07:11:02.202361-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	kr.ua	3481.0	kr.ua	2024-08-19 20:35:27.177515+00:00	2024-12-13 00:26:01.568324-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	unifesp.br	13101.0	unifesp.br	2023-10-16 09:41:01.001125+00:00	2023-10-21 00:19:53.348443-07:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	htcdev.com	16667.0	www.htcdev.com	2023-10-16 09:41:32.700533+00:00	2024-02-28 00:13:02.217350-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	mibbit.com	24331.0	search.mibbit.com	2023-10-16 14:04:43.793961+00:00	2024-10-08 13:39:37.978241-07:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	maemo.org	26413.0	maemo.org	2023-10-16 08:45:00.280449+00:00	2024-10-12 01:03:32.672954-07:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	unesa.ac.id	31316.0	unesa.ac.id	2023-10-16 09:10:05.102012+00:00	2024-09-29 00:39:33.281785-07:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	nomachine.com	34405.0	www.nomachine.com	2023-10-16 08:56:02.570067+00:00	2024-02-21 00:52:38.804403-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	salem-news.com	36129.0	salem-news.com	2023-10-16 08:46:37.479980+00:00	2024-12-12 02:06:59.191265-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	newdaynews.ru	37595.0	newdaynews.ru/ural	2023-10-15 12:13:33.527187+00:00	2024-12-12 07:12:52.551050-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	dotclear.org	40632.0	dotclear.org	2023-10-15 11:27:30.870060+00:00	2024-12-12 04:13:46.713957-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	gumer.info	40985.0	www.gumer.info	2023-10-16 08:46:37.479980+00:00	2024-10-08 01:12:35.412533-07:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	devicedoctor.com	41894.0	devicedoctor.com	2023-10-16 08:29:45.222754+00:00	2024-12-12 02:17:59.629643-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	bizvion.kr	44543.0	whitelinedental.bizvion.kr	2023-10-15 11:35:18.012042+00:00	2024-12-23 03:07:26.298945-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	ucv.ve	44738.0	ucv.ve	2024-05-01 16:28:31.789617+00:00	2024-12-12 02:24:04.579193-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	leaders.com.tn	46887.0	leaders.com.tn	2023-10-16 08:56:02.570067+00:00	2024-12-12 02:36:30.494436-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	psychologies.ru	53325.0	www.psychologies.ru	2023-10-16 09:41:51.082152+00:00	2024-12-23 00:53:35.987630-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	secretariasenado.gov.co	58312.0	secretariasenado.gov.co	2023-10-15 09:41:24.852886+00:00	2024-12-23 01:05:40.790610-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	appenninobianco.it	61720.0	www.appenninobianco.it	2023-10-16 09:12:51.151783+00:00	2024-12-23 00:58:25.400653-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'
Php/5.3.10-1ubuntu3	knu.ua	62540.0	knu.ua	2023-10-15 09:42:49.788165+00:00	2024-12-23 01:02:22.033202-08:00	lower(http_request.response_headers) contains 'php/5.3.10-1ubuntu3'