Ingesting from a SQL Server to Log Analytics

%3CLINGO-SUB%20id%3D%22lingo-sub-1529072%22%20slang%3D%22en-US%22%3EIngesting%20from%20a%20SQL%20Server%20to%20Log%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529072%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20ingest%20logs%20from%20a%20table%20in%20a%20SQL%20Database%20that%20contains%20logs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20%22easy%22%20way%20out%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20what%20i%20can%26nbsp%3B%20see%20the%20only%20way%20is%20to%20create%20a%20job%20in%20the%20SQL%20Server%2C%20and%20export%20the%20tables%20that%20i%20want%2C%20into%20a%20file%2C%20a%20read%20that%20file%20to%20log%20analytics.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20correct%20%3F%20Or%20is%20there%20any%20other%20way%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533757%22%20slang%3D%22en-US%22%3ERe%3A%20Ingesting%20from%20a%20SQL%20Server%20to%20Log%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533757%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F714167%22%20target%3D%22_blank%22%3E%40loadedlouie27%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20not%20a%20SQL%20Audit%20ingestion%2C%20but%20an%20application%20that%20runs%20on%20IIS%2C%20and%20generates%20the%20logs%20from%20the%20application%20into%20a%20table%20on%20a%20database%20for%20logs...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi 

I want to ingest logs from a table in a SQL Database that contains logs.

 

Is there a "easy" way out ? 

 

From what i can  see the only way is to create a job in the SQL Server, and export the tables that i want, into a file, a read that file to log analytics. 

 

Is this correct ? Or is there any other way ? 

 

1 Reply

@loadedlouie27 

This is not a SQL Audit ingestion, but an application that runs on IIS, and generates the logs from the application into a table on a database for logs...