Coveo Enterprise Search Online Help
List of System Fields
Search Interface > Performing a Search > Advanced Field Queries > List of System Fields

Glossary Item Box

System fields are common to most repositories (Windows, Microsoft Exchange, SharePoint, etc.). The following table lists the different system fields available:

 
Name Type Available in Query Source Type Description Example

sysaboutme

String

 Yes System

Contains the description of the user.

@sysaboutme=manager

Finds users whose description contains the word manager.

sysauthor String Yes System

Contains the author of the document.

@sysauthor=John

Finds documents whose author is John.

sysauthorloginname

 String Yes System

Contains the author login name of the document.

@sysauthorloginname=COVEO\JSmith

Finds documents whose author login name is COVEO|JSmith.

syscollection

 String Yes System

Contains the name of the collection in which the document is indexed.

@syscollection=Coveo

Finds documents from the Coveo collection.

sysconcepts

 String Yes System

Contains the key concepts extracted by Coveo Enterprise Search's (CES) linguistic algorithm to create the document's excerpt and summary.

See also: Search Interface > What Are Excerpts?, Search Interface > What Are Summaries?, What Are Converters?

@sysconcepts=stemming

Finds documents for which CES has extracted the concept stemming.

syscontainsattachment

 String Yes System

Indicates if the document contains attachments (email attachments or files in an archive such as a .zip or .rar).

@syscontainsattachments

Finds documents containing attachments.

sysdate

Date/time

 Yes System

Contains the creation or modification date of the document.

Note: The indexing date of a document is indicated by sysaddeddate; whereas, its re-indexing (i.e. refreshing or rebuilding) date is indicated by sysindexeddate.

@sysdate=today

Finds documents created or modified today.

@sysdate>now-5h

Finds documents created or modified less than 5 hours ago.

sysduration

 Floating Point Yes System

Contains the duration, in seconds, of the audio video document.

@sysduration>120

Finds audio video documents whose duration exceeds 120 seconds.

sysfilename

 String Yes System

Contains the filename of the document.

@sysfilename=Online_Documentation

Finds documents whose file names contain Online_Documentation.

sysfiletype

 String Yes System

Contains the document type. The document types supported by CES' main converters are listed in Supported File Formats.

Note: Other document types can be indexed using open converters or IFilters.

See also: How to Add an Open Converter, What Are IFilters?

@sysfiletype=doc

Finds Microsoft Word documents.

sysfirstname String Yes System

Contains the first name of the user.

@sysfirstname = John

Finds user whose first name is John.

sysheight Numeric Yes System Contains the height of the picture.

@sysheight>512

Finds pictures whose height is greater than 512 pixels.

syshomephone

 String No System Contains the home phone number of the user.

 

sysindexeddate

Date/time

 Yes System

Contains the most recent date on which the document was re-indexed (i.e. refreshed or rebuilt).

Note: The indexing date of a document is indicated by sysaddeddate; whereas, its modification date by sysdate.

@sysindexeddate<=today-1mo

Finds documents indexed a month ago or earlier.

sysisattachment

 String Yes System Indicates if the document is an attachment (email attachments or files in an archive such as .zip or .rar).

@sysisattachment

Finds email attachments and archive files (e.g. files in a .zip archive).

sysisreference

 String Yes System

Indicates if the document is indexed by reference.

See also: What Is the Difference Between Indexing by Reference and Indexing by Content?

@sysisreference

Finds documents indexed by reference.

not @sysisreference

Finds documents indexed by content.

syslanguage

 String Yes System

Contains the language of the document.

Note: CES recognizes English, French, German, Spanish, Italian, Portuguese, Dutch, Catalan, Chinese (traditional and simplified), Japanese and Korean.

@syslanguage=Spanish

Finds documents written in Spanish.

not @syslanguage

Finds documents whose language is unknown.

syslastname

 String Yes System Contains the last name of the user.

@syslastname=Smith

Finds users whose last name is Smith.

sysloginname String Yes System Contains the login name of the user.

@sysloginname = COVEO\JSmith

Finds users whose login name is COVEO\JSmith.

sysmanager

 String No System Contains the manager name of the personal user.

 

sysmmrpath String No System Contains the datastream relative path of the audio video document.
sysmobilephone String No System Contains the mobile phone number of the user.
sysmonth String Yes System Contains the month of the modification date of the document (from 01 to 12).

@sysmonth=09

Finds documents created or modified in September.

sysoffice

 String Yes System Contains the location of the office of the user.

@sysoffice=Boston

Finds users whose office is located in Boston.

sysopenwithquickview

 String No System Indicates if the document should be opened using the Quick View (i.e. the actual document cannot be opened from the Search Interface).

 

syspages

 Numeric Yes System Contains the number of pages of the document.

@syspages>100

Finds documents containing more than 100 pages.

sysparents String No System Contains the parent information of the document. Note that this field is used internally by CES.
syspicturetakenon Date/Time Yes System Contains the date on which the picture was taken.

@syspicturetakenon=today

Finds pictures taken today.

syspictureuri String No System Contains the picture URI of the user.

 

sysrelatedlink String Yes System Contains the related (or alternative) link of the document.

@sysrelatedlink=Coveo

Finds documents whose related links contain Coveo.

syssite

 String Yes System Contains the Web site address of the document.

@syssite=www.coveo.com

Finds documents located on Coveo's Web site.

syssize

 Numeric Yes System Contains the size, in bytes, of the document.

@syssize>1024

Finds documents whose size is superior to 1 kilobyte.

syssource

 String Yes System Contains the source in which the document is indexed.

@syssource=Coveo

Finds documents from the Coveo source.

systitle

 String Yes System Contains the title of the document.

@systitle=Coveo

Finds documents whose titles contain the word Coveo.

sysuri

 String Yes System Contains the URI of the document.

@sysuri=Coveo

Finds documents whose URI contain the word Coveo.

syswidth Numeric Yes System Contains the width of the picture.

@syswidth>512

Finds pictures whose width is greater than 512 pixels.

sysworkemail

 String Yes System Contains the work email of the user.

@sysworkemail = Coveo@Search.com

Finds users who have the following work email: Coveo@Search.com.

sysworkphone

 String No System Contains the work phone number of the user.

 

sysworktitle

 String Yes System Contains the title of the user.

@sysworktitle=manager

Finds users whose title contains manager.

sysyear

 String Yes System Contains the year of creation or modification of the document.

@sysyear=2007

Finds documents created or modified in 2007.

sysspauthorid Numeric No SharePoint

Contains the author Id of the SharePoint item or document.

 

sysspblogpostid Numeric Yes SharePoint

Contains the blog post Id of the SharePoint blog comment.

@sysspblogpostid=2

Finds SharePoint blog pcomments whose Id is 2.

sysspcontenttype String Yes SharePoint Contains the content type of the SharePoint item or document.

@sysspcontenttype=post

Find SharePoint items and documents whose content type is post.

sysspiscontainer

 Numeric Yes SharePoint

Indicates if the SharePoint item is a container (portal, site or list).

@sysspiscontainer

Finds SharePoint containers items (portals, sites, lists, etc.).

sysspisdraft String Yes SharePoint Indicates whether the SharePoint item or document is a draft.

@sysspisdraft

Finds SharePoint items and documents that are drafts.

sysspispersonalsite

 Numeric Yes SharePoint

Indicates if the SharePoint item is a personal site.

@sysspispersonalsite

Finds SharePoint personal sites.

sysspistoplevelsite Numeric Yes SharePoint

Indicates if the SharePoint item is a top-level site.

@sysspistoplevelsite

Finds SharePoint top-level sites.

sysspitemtype

 String Yes SharePoint

Contains the type of the SharePoint item or document (site, list, listitem, etc.).

See also: ItemTypes

@sysspitemtype=list item

Finds all SharePoint items and documents.

syssplistbasetype

 String Yes SharePoint

Contains the list base type of the SharePoint item or document (document library, issues, discussion, etc).

See also: List Base Types

@syssplistbasetype= documentlibrary

Finds all SharePoint documents whose list base type is documentlibrary.

syssplistguid

 String No SharePoint

Contains the list GUID (Globally Unique Identifier) of the SharePoint item or document. Note that this field is used internally by CES.

 

syssplistitemguid String No SharePoint

Contains the list item GUID of the SharePoint item or document. Note that this fiel is used internally by CES.

 

syssplistitemid

 Numeric Yes SharePoint

Contains the Id of the SharePoint list item or document.

@syssplistitemid = 2

Finds SharePoint items and documents whose list item Id is 2. 

syssplistname

 String Yes SharePoint

Contains the list name of the SharePoint item or document.

@syssplistname=Coveo

Finds SharePoint items or documents whose list name contains Coveo.

syssplisttruncatedguid String Yes SharePoint Contains the list truncated GUID of the SharePoint item or document. Note that this field is used internally by CES.

@syssplisttruncatedguid=7CB9E0BC1CF3

Finds SharePoint items and documents whose list GUID contains 7CB9E0BC1CF3.

syssplisttype

 String Yes SharePoint

Contains the list type of the SharePoint item or document.

See also: List Types

@syssplisttype=Agenda

Finds SharePoint items and documents whose list type is Agenda.

sysspparentguids

 String Yes SharePoint

Contains the parent GUID of the SharePoint item or document. Note that this field is used internally by CES.

@sysspparentguids=7CB9E0BC1CF3

Finds SharePoint items and documents whose parent  GUID contains 7CB9E0BC1CF3.

sysspparentname String Yes SharePoint Contains the parent name of the SharePoint item or document. Note that this field is used internally by CES.

@sysspparentname=Coveo

Finds SharePoint  items and documents whose parent names contain Coveo.

sysspparenttruncatedguid String Yes SharePoint Contains the parent truncated GUID of the SharePoint item or document. Note that this field is used internally by CES.

@sysspparenttruncatedguid=7CB9E0BC1CF3

Finds SharePoint items and documents whose parent GUID contains 7CB9E0BC1CF3.

syssprelativelisturi String Yes SharePoint

Contains the relative part of the list URI of the SharePoint item or document.

@syssprelativelisturi=document

Finds SharePoint items and documents whose relative list URIs contain document.

sysspsiteguid String No SharePoint

Contains the site GUID of the SharePoint item or document. Note that this field is used internally by CES.

 

sysspsitename String SharePoint

Contains the site name of the SharePoint item or document.

@sysspsitename="Coveo Enterprise Search - Technical Support"

Finds SharePoint items and documents whose site title contains the expression Coveo Enterprise Search - Technical Support.

sysspsitetruncatedguid String SharePoint Contains the site truncated GUID of the SharePoint item or document. Note that this field is used internally by CES.

@sysspsitetruncatedguid=7CB9E0BC1CF3

Finds SharePoint items and documents whose site GUID contains 7CB9E0BC1CF3.

sysspsiteuri String SharePoint

Contains the site URI of the SharePoint item or document.

@sysspsiteuri=support

Finds SharePoint items and documents whose site URI contains support.

sysspversion String SharePoint Contains the SharePoint version of the SharePoint item or document (2003 or 2007).

@sysspversion=2007

Finds SharePoint items or documents whose SharePoint versions are 2007 (WSS 3.0 and MOSS 2007).

syscc String Exchange

Contains the CC (carbon copy) recipients of the email.

@syscc=John

Finds emails whose CC recipient contains John.

sysconversationtopic

 String Exchange

Contains the conversation thread of the email.

Note: The conversation thread includes the initial email and all other messages sharing the same title (i.e. replies and forwards).

@sysconversationtopic="New Product"

Finds emails in the New Product thread.

sysdisplaycc String Exchange Contains the displayed name of the CC recipients of the email.

@sysdisplaycc=John

Finds emails who CC recipient display name contains John.

sysdisplayfrom String Exchange Contains the displayed name of the sender of the email.

@sysdisplayfrom=John

Finds emails whose sender display name contains John.

sysdisplayrecipients String Exchange Contains the displayed name of the recipients and CC recipients of the email.

@sysdisplayrecipients=John

Finds emails whose recipients or CC recipients display name contains John.

sysdisplayto String Exchange Contains the displayed name of the recipients of the email.

@sysdisplayto=John

Finds emails whose recipients display name contains John.

sysemailfolders String Exchange Contains the parent folder names of the Exchange item.

@sysemailfolders=Support

Finds Exchange items whose parent folder name contains Support.

sysfrom String Exchange

Contains the sender of the email.

@sysfrom=John

Finds emails whose sender contains  John.

sysisdeleteditem String Exchange Indicates if the Exchange item is in the Deleted Items folder.

@sysisdeleteditem

Finds Exchange items located in the Deleted Items folder.

sysmailbox String Exchange

Contains the mailbox name of the Exchange item.

@sysmailbox=Coveo

Finds Exchange items whose mailbox name contain Coveo.

sysmessageclass String No Exchange Contains the message class of the Exchange  item.
sysoutlookuri String No Exchange Contains the URI to use to open the Exchange item in Outlook.
sysowaurl String No Exchange

Contains the URL to use to open the Exchange item in Outlook Web Access (OWA).

 

sysrecipients String Exchange Contains the recipients and CC recipients of the email.

@sysrecipients=John

Finds emails whose recipients or CC recipients contain John.

syssubject String Exchange

Contains the subject of the Exchange item.

@syssubject=Products

Finds Exchange items whose subject contains the word Products.

systo String Exchange

Contains the recipients of the email.

@systo=John

Finds emails whose recipient contains John.

 See also: What Search Operators Can Be Used in CES?