GFI
English Deutsch Français Italiano Nederlands Español
Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Member List  Search  FAQ  Ticket List  Log Out

 

Complex query

 
Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Messaging] >> GFI MailArchiver for Exchange >> Complex query Page: [1]
Login
Message << Older Topic   Newer Topic >>
Complex query - 14.Aug.2008 4:52:06 PM   
pflint

 

Posts: 28
Joined: 4.Jan.2006
Status: offline
We are doing an investigation and need to be able to do slightly more complex searches than wildcard searches ..

For example "testword" w/5 "secondtestword" .. that kind of stuff.

Can this be done somehow within Mail Archiver 5 .. ? 

Seems not .. :-(

Paul
Post #: 1
RE: Complex query - 14.Aug.2008 8:53:31 PM   
John Letourneau

 

Posts: 1124
Joined: 28.Apr.2008
From: Clayton, NC
Status: offline
pflint,

These types of searches can be done by using qualifiers in the simple search. 

Low-level Boolean Search

A low-level boolean search can be performed from the "Simple search" page by typing in the following query in the "Search for" field.
This type of search allows to perform certain searches that cannot be specified using the user interface
 
Syntax:
 
raw: complex-term [operand complex-term]
 
complex-term: [ ( ] boolean-term | field-term [ ) ]
 
field-term: { subject | sender | to | msgid | sentdated | recvdated | msgsizekb__contains boolean-term
 
boolean-term: [ ( ] simple-term [ ) ] [operand boolean-term]
 
operand: { __and | __or } [ __not ]
 
simple-term: [ mail-term | text-term | numeric-term ]
 
mail-term: mail( word )
 
text-term: { word | phrase}
 
phrase: [ " ] word [space word ...] [ " ]
 
word: { letter | digit | @ | wildcard } [...]
 
wildcard: * | ?
 
numeric-term: number ~~ number
 
number: digit [...]
 
 
Notes:
 
1) sentdated and recvdated are numeric searches and are specified in the number of days from 1970-01-01 and padded with zeros to 10 digits. For example:
 
    sentdated __contains(0000007305~~0000013819)
 
2) msgsizekb is a numeric search and is specified in KB and padded to 10 digits. For example:
 
    msgsizekb __contains(0000001025~~0001048576)
 
3) Parenthesis are recommended for proper grouping
 
4) Email addresses and message ids shall be specified using the mail-term syntax
 
5) It is not possible to select a particular database for the search. The search will be performed accross all registered indexes
 
6) Numeric searches may not perform as efficient as from the Advanced search
 
7) When no field-term is specified the search is performed on the whole email (fileds, body and attachments)
 
8) Low level searches can be saved as Search Folders
 
9) Low level searches may produce incorrect results for indexes built by the GFI MailArchiver 4 builds prior to 20070616
 
Examples:
 
raw: "concept plan" __or "master plan" - emails containing a phrase "concept plan" or a "master plan"
 
raw: sender __contains mail(sales@gfi.com) - emails sent by sales@gfi.com
 
raw: ( sender __contains mail(sales@gfi.com) ) __or ( subject __contains GFI ) - emails sent by sales@gfi.com or containing GFI in the subject
 
raw: to __contains mail(sales@gfi.com) __or mail(info@gfi.com) - emails received by sales@gfi.com or info@gfi.com
 
raw: ("master plan") __or (msgsizekb __contains 0000001025~~0001048576) - emails containing a phrase "master plan" or larger than 1 MB

< Message edited by John Letourneau -- 14.Aug.2008 8:54:41 PM >


_____________________________

Regards,
John Letourneau - Senior Technical Support Representative
GFI Software - www.gfi.com

(in reply to pflint)
Post #: 2
Page:   [1]
All Forums >> [Messaging] >> GFI MailArchiver for Exchange >> Complex query Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


   © 2008. All rights reserved. GFI Software Home Products Download Trials Support Ordering Site Map About Us Contact us
GFI solutions: Exchange anti spam filter - exchange anti virus - isa server - network vulnerability scanner - event log management - USB security software - exchange archiving - fax server software