IBM Security QRadar

 View Only
  • 1.  Anyone know how to use LOOKUPS::CIDRLIST?

    Posted Mon March 13, 2023 04:40 AM

    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
    ------------------------------


  • 2.  RE: Anyone know how to use LOOKUPS::CIDRLIST?

    Posted Mon March 13, 2023 06:10 AM

    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
    ------------------------------



  • 3.  RE: Anyone know how to use LOOKUPS::CIDRLIST?

    Posted Mon March 13, 2023 06:22 AM

    So if I don't reconnect to the QRadar, it works, right?



    ------------------------------
    Zerah Kim
    ------------------------------



  • 4.  RE: Anyone know how to use LOOKUPS::CIDRLIST?

    Posted Mon March 13, 2023 07:24 AM

    Okay. Thank you.

    I solved this problem by creating a new webserver instead of QRadar.



    ------------------------------
    Zerah Kim
    ------------------------------



  • 5.  RE: Anyone know how to use LOOKUPS::CIDRLIST?

    Posted Tue May 16, 2023 07:08 AM

    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
    ------------------------------