Hello Zerah,
I have setup the webserver on the AWS, established the connectivity between Qradar in cloud and AWS, however connectivity looks fine but when running AQL it was not resulting any events. Have you came across such scenario?
Thanks,
Sarat
------------------------------
Sarat Sekhar
------------------------------
Original Message:
Sent: Mon March 13, 2023 07:23 AM
From: Zerah Kim
Subject: Anyone know how to use LOOKUPS::CIDRLIST?
Okay. Thank you.
I solved this problem by creating a new webserver instead of QRadar.
------------------------------
Zerah Kim
Original Message:
Sent: Mon March 13, 2023 06:10 AM
From: Paul Ford-Hutchinson
Subject: Anyone know how to use LOOKUPS::CIDRLIST?
Because of security concenrs, the ability of a Custom AQL function to connect back to QRadar in the manner that this script uses, has been removed. Thus this function (and the others like it in that content pack) will not work on newer versions of QRadar.
pfh
------------------------------
Paul Ford-Hutchinson
Original Message:
Sent: Mon March 13, 2023 04:39 AM
From: Zerah Kim
Subject: Anyone know how to use LOOKUPS::CIDRLIST?
Hello. I'm zerah
I installed a LOOKUPS Content Extension on qradar siem.
When I try to run an advanced search, it makes a problem like this:
(26020) Custom function "lookups::cidrlist" encountered a runtime exception: Exception during invocation of script function "isMatched": Failed to perform get request [http://192.168.252.13/console/qradar/test_lookup.txt]: [ConnectException] Connection refused
AQL:
SELECT sourceip, QIDNAME(qid) AS EventName FROM events WHERE LOOKUPS::CIDRLIST('https://192.168.252.13/console/qradar/lookup_files/test_lookup.txt', sourceip, '{"nonsense_key":"points to nonsense value."}') IS NOT NULL
What do you see as the problem?
------------------------------
Zerah Kim
------------------------------