Automated Logic WebCTRL connector for Microsoft Sentinel

You can stream the audit logs from the WebCTRL SQL server hosted on Windows machines connected to your Microsoft Sentinel. This connection enables you to view dashboards, create custom alerts and improve investigation. This gives insights into your Industrial Control Systems that are monitored or controlled by the WebCTRL BAS application.

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

Connector attributes

Connector attribute Description
Log Analytics table(s) Event (AutomatedLogic-WebCTRL)
Data collection rules support Not currently supported
Supported by Microsoft Corporation

Query samples

Total warnings and errors raised by the application

Event

| where Source == "ALCWebCTRL"

| where EventLevel in (1,2,3)

Vendor installation instructions

  1. Install and onboard the Microsoft agent for Windows.

Learn about agent setup and windows events onboarding.

You can skip this step if you have already installed the Microsoft agent for Windows

  1. Configure Windows task to read the audit data and write it to windows events

Install and configure the Windows Scheduled Task to read the audit logs in SQL and write them as Windows Events. These Windows Events will be collected by the agent and forward to Microsoft Sentinel.

Notice that the data from all machines will be stored in the selected workspace

2.1 Copy the setup files to a location on the server.

2.2 Update the ALC-WebCTRL-AuditPull.ps1 (copied in above step) script parameters like the target database name and windows event id's. Refer comments in the script for more details.

2.3 Update the windows task settings in the ALC-WebCTRL-AuditPullTaskConfig.xml file that was copied in above step as per requirement. Refer comments in the file for more details.

2.4 Install windows tasks using the updated configs copied in the above steps

Run the following command in powershell from the directory where the setup files are copied in step 2.1

schtasks.exe /create /XML "ALC-WebCTRL-AuditPullTaskConfig.xml" /tn "ALC-WebCTRL-AuditPull"

  1. Validate connection

Follow the instructions to validate your connectivity:

Open Log Analytics to check if the logs are received using the Event schema.

It may take about 20 minutes until the connection streams data to your workspace.

If the logs are not received, validate below steps for any run time issues:

  1. Make sure that the scheduled task is created and is in running state in the Windows Task Scheduler.
  1. Check for task execution errors in the history tab in Windows Task Scheduler for the newly created task in step 2.4
  1. Make sure that the SQL Audit table consists new records while the scheduled windows task runs.

Next steps

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