Trying to filter out 4 IP ranges, 3 can use CIDR..... suggestions?


1 comment

  • Official comment
    Matt Sullivan

    First I would definitely upvote idea 1834 which asks for CIDR based lookup tables. Meantime I would just do something like this:

    | where !(ip="" or ip="" or compareCIDRPrefix("", ip, toInt(27)))

    replacing the individual IPs and ranges of your own, and add more or clauses as req'd.  basically the equality check and compareDICRPrefix operators both return boolean so code similar to above should do the trick

    Comment actions Permalink

Please sign in to leave a comment.