2011-04-11
03:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Help with creating a report using REGEX
I am trying to create a report that will match firewall activity from a very long list of IP ranges. The two formats I have to choose from are:
1.2.3.0/24 or 1.2.3.0 - 1.2.3.255
My attempts to do this are failing. Any assistance would be greatly appreciated.
3 Replies
2011-04-20
11:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
enVision doesn't allow REGEX to be used in report queries.
Fortunately, your problem as described below is pretty easy to solve with SQL. Your where clause should look like this (assuming SourceAddress is the variable of choice):
SourceAddress LIKE '1.2.3.%'
The % simply represents any number of characters 0 or greater.
I hope that helps!
2011-07-28
04:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Is there any plans for enVision to support REGEX for reports? We have a use case where I'd like to us a REGEX watchlist in a report, as the Watchlist is too long to manage in the report SQL Where clause. Thanks.
2011-08-03
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
None that I am aware of in the near future. The reporting engine is purely SQL driven.
