Input

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

Data

Total Results: 33 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Mod_auth_pam	archive-it.org	2310.0	wayback.archive-it.org/2217/20101208171548/http://www	2023-10-15 16:54:48.857029+00:00	2024-12-09 12:33:14.731098-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	van-halen.com	64077.0	van-halen.com	2023-10-15 09:42:43.082224+00:00	2024-12-23 01:06:05.502666-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	albion.com	79079.0	albion.com	2023-10-15 10:37:20.214205+00:00	2024-12-13 02:00:31.471021-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	phobialist.com	124032.0	phobialist.com	2023-10-15 10:34:10.690011+00:00	2024-11-13 03:59:37.647459-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	newbreedsoftware.com	126086.0	newbreedsoftware.com	2023-10-15 10:41:06.019592+00:00	2024-10-09 03:09:10.436970-07:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	sterba.com	146933.0	sterba.com	2023-10-15 09:41:28.943494+00:00	2023-10-21 00:30:37.765299-07:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	isthe.com	175794.0	isthe.com	2023-10-15 11:38:56.994615+00:00	2024-06-11 10:43:31.381678-07:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	paulnoll.com	248614.0	paulnoll.com	2023-10-15 11:27:03.552131+00:00	2024-06-07 09:52:49.062117-07:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	emfsafetynetwork.org	287301.0	emfsafetynetwork.org	2023-10-15 12:13:44.808005+00:00	2024-12-08 05:14:44.113359-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	cetel.org	306704.0	cetel.org	2023-10-15 13:10:13.663414+00:00	2024-12-09 05:34:45.651540-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	gamecabinet.com	311836.0	gamecabinet.com	2023-10-15 13:00:21.324952+00:00	2024-12-23 04:41:22.933749-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	openthefuture.com	323373.0	openthefuture.com	2023-10-16 12:12:22.058383+00:00	2024-12-11 07:13:16.654316-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	sonomawireworks.com	403745.0	sonomawireworks.com	2024-08-20 21:47:15.267898+00:00	2024-12-10 08:15:03.249749-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	anomalyinfo.com	493859.0	anomalyinfo.com	2023-10-15 17:03:58.331780+00:00	2024-12-08 10:08:15.332644-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	albionmonitor.com	497231.0	albionmonitor.com	2023-10-15 16:00:00.221041+00:00	2024-12-08 10:04:20.808597-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	nurseday.org	536023.0	nurseday.org	2023-10-15 11:26:55.449013+00:00	2024-12-07 10:15:06.607576-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	shareguide.com	564928.0	shareguide.com	2023-10-15 16:01:06.838291+00:00	2024-12-13 11:01:09.345566-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	interleaves.org	577493.0	interleaves.org	2023-10-15 16:51:35.683052+00:00	2024-12-03 14:11:33.496162-08:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	sunfrost.com	734723.0	www.sunfrost.com	2023-10-15 19:19:57.068357+00:00	2024-03-22 14:02:39.120956-07:00	lower(http_request.response_headers) contains 'mod_auth_pam'
Mod_auth_pam	barkingdogs.net	734916.0	barkingdogs.net	2024-08-31 04:12:34.403017+00:00	2024-08-30 17:54:47.951697-07:00	lower(http_request.response_headers) contains 'mod_auth_pam'