--- title: "Trellix Intrusion Prevention System Manager (SQL pull) log format and field mapping" slug: "trellix-intrusion-prevention-system-manager-sql-pull-log-format" tags: ["ESM", "Reference"] updated: 2026-10-27T15:50:12Z published: 2026-10-27T15:50:12Z canonical: "docs.trellix.com/trellix-intrusion-prevention-system-manager-sql-pull-log-format" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Trellix Intrusion Prevention System Manager (SQL pull) log format and field mapping **Log format** The expected format for this device is: ``` creationTime=" date time " alertType="…" category="…" subCategory="…" detectionMethod="…" attackId=" # " attackName="…" severity=" # " alertCount=" # " sourceIPAddr="…" sourcePort=" # " targetIPAddr="…" targetPort=" # " sourceUserId="…" destinationUserId="…" ``` **Log sample** This is a sample of a log from the Trellix Intrusion Prevention System Manager device after SQL pull. ``` creationTime="2012-06-22 19:37:01" alertType="Signature" category="Exploit" subCategory="Buffer Overflow" detectionMethod="Signature" attackId="4255775" attackName="IRC: mIRC Userhost Buffer Overflow" severity="7" alertCount="1" sourceIPAddr="6FA2A653" sourcePort="6667" targetIPAddr="550D1EC1" targetPort="1041" sourceUserId="0" destinationUserId="0" ``` **Mappings** This table shows the mappings between the data source and Trellix ESM fields. | Log fields | Trellix ESM fields | | --- | --- | | creationTime | firsttime, lasttime | | alerttype | Object Type | | category + subcategory | Subject | | detectionMethod | Method | | attackId | Signature ID | | attackName | Message (smart learned if unknown) | | severity | severity plus a zero appended | | alertCount | Event Count | | sourceIPAddr | Source IP | | sourcePort | Source Port | | targetIPAddr | Destination IP | | targetPort | Destination Port | | sourceUserId | Source Username | | destinationUserId | Destination Username | | result | Action | | appName | Application | :