Splunk Enterprise Security

MSSQL Server TA - audit events scalability over hundreds of DBs

splunk_zen
Builder

According to
https://docs.splunk.com/Documentation/AddOns/released/MSSQLServer/SQLServerconfiguration
Audit events get written into a binary file C:\SQLAudit which then gets read via a DB connect query.
This is problematic when we need to monitor hundreds of different MSSQL Server DBs and would imply us setting up several HFs just for this tech stack alone (as well as very infrequent ingestion queries which doesn't seem a great fit for ES)

Even though writing audit events via Windows Event Log is less performsnt as it implies using the Windows event API rather than outputting to a file
I don't see any other option for us other than doing it and fetching via UF
This seems to have been the legacy approach for older TA versions
https://answers.splunk.com/comments/170572/view.html

0 Karma

splunk_zen
Builder

anyone please?

0 Karma
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...