Share via

[Deprecated] Oracle Database Audit connector for Microsoft Sentinel

  • Article

Important

Log collection from many appliances and devices is now supported by the Common Event Format (CEF) via AMA, Syslog via AMA, or Custom Logs via AMA data connector in Microsoft Sentinel. For more information, see Find your Microsoft Sentinel data connector.

The Oracle DB Audit data connector provides the capability to ingest Oracle Database audit events into Microsoft Sentinel through the syslog. Refer to documentation for more information.

This is autogenerated content. For changes, contact the solution provider.

Connector attributes

Connector attribute Description
Log Analytics table(s) Syslog (OracleDatabaseAudit)
Data collection rules support Workspace transform DCR
Supported by Microsoft Corporation

Query samples

Top 10 Sources

OracleDatabaseAuditEvent

| summarize count() by SrcDvcHostname

| top 10 by count_

Vendor installation instructions

NOTE: This data connector depends on a parser based on a Kusto Function to work as expected which is deployed as part of the solution. To view the function code in Log Analytics, open Log Analytics/Microsoft Sentinel Logs blade, click Functions and search for the alias Oracle Database Audit and load the function code or click here. The function usually takes 10-15 minutes to activate after solution installation/update.

  1. Install and onboard the agent for Linux

Typically, you should install the agent on a different computer from the one on which the logs are generated.

Syslog logs are collected only from Linux agents.

  1. Configure the logs to be collected

Configure the facilities you want to collect and their severities.

  1. Under workspace advanced settings Configuration, select Data and then Syslog.

  2. Select Apply below configuration to my machines and select the facilities and severities.

  3. Click Save.

  4. Configure Oracle Database Audit events to be sent to Syslog

Follow the below instructions

  1. Create the Oracle database Follow these steps.

  2. Login to Oracle database created from the above step Follow these steps.

  3. Enable unified logging over syslog by Alter the system to enable unified logging Following these steps.

  4. Create and enable an Audit policy for unified auditing Follow these steps.

  5. Enabling syslog and Event Viewer Captures for the Unified Audit Trail Follow these steps.

Next steps

For more information, go to the related solution in the Azure Marketplace.