Reports - Available Columns

  • Pretty Name - Represents the name shown in a report or table
  • DB Column Name - Represents the name used in AQL and other query tools
  • Is Advanced - Represents if the "Show Advanced Fields" checkbox needs to be checked to see it (entries that are blank do not show at all)
  • Description - Represents a detailed explanation of the field
Pretty Name DB Column Name Is Advanced Description
Access Date accessTime No Date file was last accessed on the local file system
Added Date createdAt Yes Time the file was first added to the Aggregator's database
Audit Message instanceMessage Yes Short message of action(s) taken on an instance of a file on an Aggregator
Audit Message Time instanceMessageTime Yes The time an action was taken on an instance of a file
Category category No Category for which the file's extension belong to
Class Id classId Yes Type of file, directory, or node (ex: Aggregator, Collector, Client, User, Container etc.)
Classification classification No Name of the Classification being applied to file
Classification Hit classificationHit Yes Content detected to be a classification hit
Classification Hit Confidence classificationHitConfidence Yes Threshold required for a file to be classified
Classification Hit Context classificationHits Yes Context of a classification hit
Classification Hit Leading Words classificationHitWordsBefore Yes Words leading up to classification hit
Classification Hit Policy classificationHitPolicy Yes Number representing how many classification are associated with the file
Classification Hit Rule classificationHitRule Yes Rules of a classification associated with the file
Classification Hit Trailing Words classificationHitWordsAfter Yes Words trailing the classification hit
Classification Id classificationId Yes ID number associated with a classification
Classifications classifications Yes Set of classifications associated with a file
Compression Ratio compressionRatio No Ratio of the actual size that file occupies to the size of the actual file
Confidence % confidence No Confidence level of a classification hit
Create Date createTime No Date file was first created on the local file system
Deleted Date deletedAt Yes Time the file was deleted from the Aggregator's database
Document Created By docCreator No User by whom the document was created
Document Creation Time docCreateTime No Date that the document was created
Document Modified By docModifier No User by whom the document was last modified
Document Modify Time docModifyTime No Date that the document was last modified
Duplicate Count dupCount No Number of identical copies of a file found in an Aggregator's database
Extension extension No Extension associated with the file
File Signature dupKey Yes Cryptographic algorithm representing the unique content of a file
Is Deleted isDeleted Yes Determines if the data has been removed
Is Storage Container isContainer Yes Determines if this item is a directory
Is Storage Object isObject Yes Determines if this item is a file
Local Path localPath No Local path of file
Metadata metadata No A document internal information (ex: creator, original create date, modification date, etc.)
Metadate Object metadataObject Yes A document internal information in JSON format (ex: creator, original create date, modification date, etc.)
Modify Date modifyTime No Date file was last modified on the local file system
Name name No Name of file or directory
Node Name node Yes Name of the aggregator or collector
OS Permissions osPermissions Yes The Operating Systems permissions associated with a file
Owner osOwner No Owner of the file
Parent Path parentPath No Path to the corresponding directory of a file
Path path No Path to the corresponding file
Permission osPermission No A file's Operating System permission
Retrieval Cost retrievalCost No Cost for retrieving a file
Retrieval Time retrievalTime No The estimated time for retrieving a file
Search Hit searchHit Yes Search entry sucessfully found
Search Hit Context searchHits Yes Context of a search hit
Search Hit Leading Words searchHitWordsBefore Yes Words leading to the word being searched for
Search Hit Trailing Words searchHitWordsAfter Yes Words trailing the word being searched for
Service Mode serviceMode No Source or Target
Service Name service No Name of the target or source service
Service Type serviceType No The type of the service this can be a target or a source
Size size No The size of the file on the local file system
Size on Disk storeSize No The size of the file as stored by the Aggregator's database
Storage Cost storageCost No Cost of maintaining a file in storage for up to 30 days
Store Date storeTime No Date a file was stored to the Aggregator's database
Tag userTag No Tag(s) associatd with file
Tags userTags Yes Set of tags for files
Updated Date updatedAt Yes Date a file was last edited in the Aggregator's database
Version version No Number of times a file has changed, each number represent a new version of the file

attrib
Number of attributes associated with file

batchId
Batch Id of Batch the file(s) belonged to when processed

classificationObjects
Returns the classification being applied to be processed by backend

componentId
Id of component as text

dataset
Name of the set of data

datasetId
Id number of the set of data

encryptionId
Encryption Id of file

iFlags
Instance flags indicating current status of file

instanceBatchId
Instance Batch Id of file

instanceId
Instance Id of file

instanceMessageObjects
Returns the Audit Message with associated transaction to be processed by backend

instanceTags
Returns the instance tags as a collection of Ids to be processed by backend

instanceTagString
Returns the instance tags as text

isClassified
True or false value representing whether file is classified

isIndexed
True or false value representing whether file is indexed

isSigned
Represents if a cryptographic algorithm has been used to identify the unique content of a file

keyId
Encryption key id which is a hash of encryption key of file

localParentPath
Path to file on local disk

localParentUrlScheme
Local Parent URL Scheme

nodeObjectId
Id of the returned node

objectId
Id of file

objectMessage
Returns message associated with file as text

objectMessageObjects
Returns message associated with file to be processed by backend

objectMessageTime
Returns time when corresponding file message was sent

osOwnerObject
Owner of the file on disk

osPermissionObjects
Returns associated OS permission to be processed by backend

parentId
Parent Id of file

processPipe
Id of file

processTime
The time is took to assess a files index, classification, and metadata

serviceId
The target or source unique identifier

tags
Returns the tags as a collection of Ids to be processed by backend

tagString
Returns the tags as a single line of text

uniqueName
Unique name of file or directory (only unique inside its parent directory)

userTagObjects
Returns a user tag to be processed by backend

winLocalParentPath
Windows local parent path of file

winLocalPath
Windows local path of file

winParentPath
Windows parent path of file

winPath
Windows absolute path of file

wordBatchId
The Batch Id of Batch containing the words in file
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us