Collect InterSystems Caché logs

Supported in:

Google secops SIEM

This document explains how to ingest InterSystems Caché logs to Google Security Operations using the Bindplane agent.

InterSystems Caché is a high-performance database and application platform used in healthcare and financial services. It generates audit logs for database operations, user access, and system events. The parser extracts fields from Caché audit data and maps them to the Unified Data Model (UDM), capturing user identity, network attributes, process details, file operations, and security results.

Before you begin

Make sure you have the following prerequisites:

A Google SecOps instance
Windows Server 2016 or later, or Linux host with systemd
Network connectivity between the Bindplane agent and the InterSystems Caché server
If running behind a proxy, ensure firewall ports are open per the Bindplane agent requirements
Privileged access to the InterSystems Caché instance with authority to configure audit logging and log export

Get Google SecOps ingestion authentication file

Sign in to the Google SecOps console.
Go to SIEM Settings > Collection Agents.
Download the Ingestion Authentication File.
Save the file securely on the system where Bindplane will be installed.

Note: This JSON file contains credentials for authenticating the Bindplane agent to Google SecOps.

Get Google SecOps customer ID

Sign in to the Google SecOps console.
Go to SIEM Settings > Profile.
Copy and save the Customer ID from the Organization Details section.

Note: The customer ID is required for configuring the Bindplane agent exporter.

Install the Bindplane agent

Install the Bindplane agent on your Windows or Linux operating system according to the following instructions.

Windows installation

Open Command Prompt or PowerShell as an administrator.

Run the following command:

msiexec /i "https://github.com/observIQ/bindplane-agent/releases/latest/download/observiq-otel-collector.msi" /quiet

Wait for the installation to complete.
Verify the installation by running:
```
sc query observiq-otel-collector
```
The service should show as RUNNING.

Linux installation

Open a terminal with root or sudo privileges.

Run the following command:

sudo sh -c "$(curl -fsSlL https://github.com/observiq/bindplane-agent/releases/latest/download/install_unix.sh)" install_unix.sh

Wait for the installation to complete.
Verify the installation by running:
```
sudo systemctl status observiq-otel-collector
```
The service should show as active (running).

Additional installation resources

For additional installation options and troubleshooting, see the Bindplane agent installation guide.

Configure the Bindplane agent to ingest syslog and send to Google SecOps

Locate the configuration file

Linux:

sudo nano /opt/observiq-otel-collector/config.yaml

Windows:

notepad "C:\Program Files\observIQ OpenTelemetry Collector\config.yaml"

Edit the configuration file

Replace the entire contents of config.yaml with the following configuration:

receivers:
    udplog:
        listen_address: "0.0.0.0:514"

exporters:
    chronicle/intersystems_cache:
        compression: gzip
        creds_file_path: '/etc/bindplane-agent/ingestion-auth.json'
        customer_id: '<customer_id>'
        endpoint: malachiteingestion-pa.googleapis.com
        log_type: INTERSYSTEMS_CACHE
        raw_log_field: body

service:
    pipelines:
        logs/intersystems_cache:
            receivers:
                - udplog
            exporters:
                - chronicle/intersystems_cache

Configuration parameters

Replace the following placeholders:

Receiver configuration:
- udplog: The receiver type based on protocol:
  - udplog for UDP syslog
  - tcplog for TCP syslog
  - syslog for RFC 3164/5424 syslog
- 0.0.0.0: IP address to listen on:
  - 0.0.0.0 to listen on all interfaces (recommended)
  - Specific IP address to listen on one interface
- 514: Port number to listen on (for example, 514, 1514, 6514)
Exporter configuration:
- <customer_id>: Customer ID from the earlier step
- malachiteingestion-pa.googleapis.com: Regional endpoint URL:
  - US: malachiteingestion-pa.googleapis.com
  - Europe: europe-malachiteingestion-pa.googleapis.com
  - Asia: asia-southeast1-malachiteingestion-pa.googleapis.com
  - See Regional Endpoints for complete list
- Adjust the creds_file_path depending on the platform:
  - Linux: /etc/bindplane-agent/ingestion-auth.json
  - Windows: C:\Program Files\observIQ OpenTelemetry Collector\ingestion-auth.json

Save the configuration file

After editing, save the file:
- Linux: Press Ctrl+O, then Enter, then Ctrl+X
- Windows: Click File > Save

Restart the Bindplane agent to apply the changes

To restart the Bindplane agent in Linux, run the following command:

sudo systemctl restart observiq-otel-collector

Verify the service is running:

sudo systemctl status observiq-otel-collector

Check logs for errors:

sudo journalctl -u observiq-otel-collector -f

To restart the Bindplane agent in Windows, choose one of the following options:
- Command Prompt or PowerShell as administrator:
```
net stop observiq-otel-collector && net start observiq-otel-collector
```
- Services console:
  1. Press Win+R, type services.msc, and press Enter.
  2. Locate observIQ OpenTelemetry Collector.
  3. Right-click and select Restart.
  4. Verify the service is running:
```
sc query observiq-otel-collector
```
  5. Check logs for errors:
```
type "C:\Program Files\observIQ OpenTelemetry Collector\log\collector.log"
```

Configure InterSystems Caché syslog forwarding

InterSystems Caché writes audit events to its internal audit database. Configure syslog forwarding to send these events to the Bindplane agent.

Enable and configure audit logging

Open the Caché Management Portal.
Navigate to System Administration > Security > Auditing > Configure System Events.
Enable the audit events you want to capture (for example, %System/%Login/LoginFailure, %System/%Security/Protect).
Click Save.

Configure syslog forwarding

In the Management Portal, navigate to System Administration > Security > Auditing > Configure Audit.
Enable syslog forwarding for audit events.
Provide the following configuration details:
- Syslog Server: Enter the IP address of the Bindplane agent host (for example, 192.168.1.100).
- Port: Enter 514 (must match the Bindplane receiver port).
- Protocol: Select UDP (must match the Bindplane receiver type).
Click Save.

Note: If Caché does not support native syslog forwarding in your version, use the %SYS.Audit class to export audit data programmatically and forward the output using a syslog utility such as logger or rsyslog.

UDM mapping table

Log Field	UDM Mapping	Logic
`deviceNtDomain`	`about.administrative_domain`	Renamed/mapped
`deviceExternalId`	`about.asset.asset_id`	Directly mapped
`device_product`	`about.asset.asset_id`	Directly mapped
`device_vendor`	`about.asset.asset_id`	Directly mapped
`fileHash`	`about.file.full_path`	Directly mapped
`filePath`	`about.file.full_path`	Renamed/mapped
`_hash`	`about.file.sha256`	Renamed/mapped
`fileHash`	`about.file.sha256`	Renamed/mapped
`fsize`	`about.file.size`	Renamed/mapped
`dvchost`	`about.hostname`	Renamed/mapped
`ips`	`about.ip`	Merged
`dvc_mac`	`about.mac`	Mapped: `slot` → `mac_address`
`dvcmac`	`about.mac`	Merged
`mac_address`	`about.mac`	Merged
`deviceTranslatedAddress`	`about.nat_ip`	Merged
`Emne`	`about.process.command_line`	Directly mapped
`Path`	`about.process.command_line`	Directly mapped
`Subject`	`about.process.command_line`	Directly mapped
`deviceProcessName`	`about.process.command_line`	Renamed/mapped
`dvcpid`	`about.process.pid`	Renamed/mapped
`permissions`	`about.resource.attribute.permissions`	Merged
`additional_cfp1`	`additional.fields`	Merged
`additional_cfp2`	`additional.fields`	Merged
`additional_cfp3`	`additional.fields`	Merged
`additional_cfp4`	`additional.fields`	Merged
`additional_cn1`	`additional.fields`	Merged
`additional_cn2`	`additional.fields`	Merged
`additional_cn3`	`additional.fields`	Merged
`additional_cs1`	`additional.fields`	Merged
`additional_cs2`	`additional.fields`	Merged
`additional_cs3`	`additional.fields`	Merged
`additional_cs4`	`additional.fields`	Merged
`additional_cs5`	`additional.fields`	Merged
`additional_cs6`	`additional.fields`	Merged
`additional_cs7`	`additional.fields`	Merged
`additional_devicePayloadId`	`additional.fields`	Merged
`additional_eventId`	`additional.fields`	Merged
`additional_field`	`additional.fields`	Merged
`additional_field_key`	`additional.fields`	Mapped: `smb_stage1` → `additional_smb_stage1`
`additional_flexString1`	`additional.fields`	Merged
`additional_fname`	`additional.fields`	Merged
`additional_smb_stage1`	`additional.fields`	Merged
`cs2`	`additional.fields`	Mapped: `arc_test` → `additional_cs2`
`cs5_label`	`additional.fields`	Merged
`event_name`	`extensions.auth.type`	Mapped: `logout` → `AUTHTYPE_UNSPECIFIED`, `login` → `AUTHTYPE_UNSPECIFIED`
`field_intermediary`	`intermediary`	Merged
`msg`	`metadata.description`	Renamed/mapped
`Generated`	`metadata.event_timestamp`	Parsed as `yyyy-MM-ddTHH:mm:ss`
`Received`	`metadata.event_timestamp`	Parsed as `yyyy-MM-ddTHH:mm:ss`
`rt`	`metadata.event_timestamp`	Parsed as `yyyy-MM-ddTHH:mm:ssZ`
`event_name`	`metadata.event_type`	Mapped: `logout` → `USER_LOGOUT`, `login` → `USER_LOGIN`, `"LogSpyware","LogPredictiveMachin...
`device_event_class_id`	`metadata.product_event_type`	Directly mapped
`event_name`	`metadata.product_event_type`	Directly mapped
`externalId`	`metadata.product_log_id`	Directly mapped
`device_product`	`metadata.product_name`	Directly mapped
`device_version`	`metadata.product_version`	Directly mapped
`device_vendor`	`metadata.vendor_name`	Renamed/mapped
`app_protocol_output`	`network.application_protocol`	Directly mapped
`deviceDirection`	`network.direction`	Mapped: `0` → `INBOUND`, `1` → `OUTBOUND`
`requestMethod`	`network.http.method`	Renamed/mapped
`agentZoneURI`	`network.http.referral_url`	Directly mapped
`requestClientApplication`	`network.http.user_agent`	Renamed/mapped
`ip_protocol_out`	`network.ip_protocol`	Directly mapped
`in`	`network.received_bytes`	Renamed/mapped
`out`	`network.sent_bytes`	Renamed/mapped
`sntdom`	`principal.administrative_domain`	Renamed/mapped
`sourceServiceName`	`principal.application`	Renamed/mapped
`Group_name`	`principal.group.group_display_name`	Directly mapped
`Gruppenavn`	`principal.group.group_display_name`	Directly mapped
`Device_name`	`principal.hostname`	Directly mapped
`Enhetsnavn`	`principal.hostname`	Directly mapped
`shost`	`principal.hostname`	Renamed/mapped
`principal_ip`	`principal.ip`	Merged
`shost`	`principal.ip`	Merged
`mac`	`principal.mac`	Merged
`sourceTranslatedAddress`	`principal.nat_ip`	Merged
`sourceTranslatedPort`	`principal.nat_port`	Renamed/mapped
`spt`	`principal.port`	Renamed/mapped
`sproc`	`principal.process.command_line`	Renamed/mapped
`spid`	`principal.process.pid`	Renamed/mapped
`principal_role`	`principal.user.attribute.roles`	Merged
`suser`	`principal.user.user_display_name`	Directly mapped
`suid`	`principal.user.userid`	Renamed/mapped
`_action`	`security_result.action`	Merged
`act`	`security_result.action`	Mapped: `accept` → `_action`, `deny` → `_action`
`Action_Taken`	`security_result.action_details`	Directly mapped
`act`	`security_result.action_details`	Directly mapped
`cat`	`security_result.category_details`	Merged
`Scan_Type`	`security_result.description`	Directly mapped
`Type`	`security_result.description`	Directly mapped
`msg_data_2`	`security_result.description`	Directly mapped
`infection_channel_label`	`security_result.detection_fields`	Merged
`operasjon_label`	`security_result.detection_fields`	Merged
`operation_label`	`security_result.detection_fields`	Merged
`permission_label`	`security_result.detection_fields`	Merged
`spyware_Grayware_Type_label`	`security_result.detection_fields`	Merged
`threat_probability_label`	`security_result.detection_fields`	Merged
`tillatelse_label`	`security_result.detection_fields`	Merged
`mwProfile`	`security_result.rule_name`	Directly mapped
`severity`	`security_result.severity`	Mapped: `"0", "1", "2", "3", "LOW"` → `LOW`, `"4", "5", "6", "MEDIUM", "SUBSTANTIAL", "INFO"...
`severity`	`security_result.severity_details`	Directly mapped
`Result`	`security_result.summary`	Directly mapped
`appcategory`	`security_result.summary`	Directly mapped
`reason`	`security_result.summary`	Renamed/mapped
`Spyware`	`security_result.threat_name`	Directly mapped
`Unknown_Threat`	`security_result.threat_name`	Directly mapped
`Virus_Malware_Name`	`security_result.threat_name`	Directly mapped
`oldFilePath`	`src.file.full_path`	Renamed/mapped
`oldFileSize`	`src.file.size`	Renamed/mapped
`old_permissions`	`src.resource.attribute.permissions`	Merged
`dntdom`	`target.administrative_domain`	Renamed/mapped
`app`	`target.application`	Directly mapped
`destinationServiceName`	`target.application`	Renamed/mapped
`ahost`	`target.hostname`	Directly mapped
`temp_dhost`	`target.hostname`	Directly mapped
`IPv6_Address`	`target.ip`	Merged
`agt`	`target.ip`	Merged
`dst_ip`	`target.ip`	Merged
`ipv6`	`target.ip`	Mapped: `-` → `IPv6_Address`
`atz`	`target.location.country_or_region`	Directly mapped
`amac`	`target.mac`	Merged
`mac_address`	`target.mac`	Merged
`destination_translated_address`	`target.nat_ip`	Merged
`destinationTranslatedPort`	`target.nat_port`	Renamed/mapped
`dpt`	`target.port`	Renamed/mapped
`dproc`	`target.process.command_line`	Renamed/mapped
`File_name`	`target.process.file.full_path`	Directly mapped
`Infected_Resource`	`target.process.file.full_path`	Directly mapped
`Object`	`target.process.file.full_path`	Directly mapped
`Objekt`	`target.process.file.full_path`	Directly mapped
`dpid`	`target.process.pid`	Renamed/mapped
`resource_Type_label`	`target.resource.attribute.labels`	Merged
`request`	`target.url`	Directly mapped
`target_role`	`target.user.attribute.roles`	Merged
`CustomerName`	`target.user.user_display_name`	Directly mapped
`temp_duser`	`target.user.user_display_name`	Directly mapped
`Bruker`	`target.user.userid`	Directly mapped
`User_value`	`target.user.userid`	Directly mapped
`temp_duid`	`target.user.userid`	Directly mapped
N/A	`extensions.auth.type`	Constant: `AUTHTYPE_UNSPECIFIED`
N/A	`metadata.event_type`	Constant: `USER_LOGOUT`
N/A	`network.direction`	Constant: `INBOUND`
N/A	`security_result.severity`	Constant: `LOW`

Need more help? Get answers from Community members and Google SecOps professionals.