All Apps and Add-ons

Why does server info populate SQL App, but Windows Event Log Data does not?

KpiBuff
Explorer

Splunk App or Microsoft SQL Server has an Overview page. I have that successfully showing the monitored SQL instance.

But if I go to the Security/Database Operations report, it fails to return results.

An indexed audit event can be found with this search: index="wineventlog" AND "logname=application"

Inspecting one of these events reveals it is missing the mssql-audit eventtype.

Splunk App or Microsoft SQL Server has a macros.conf. Line 3 reads "definition = eventtype=mssql-audit server_instance_name="$instance$"...

I regularly run unsigned Powershell scripts from this server. There are no recent errors in the Powershell errors report.

Is something malfunctioning around automatically assigning the mssql-audit eventtype to events as they are searched or indexed?

Thanks! - Chris

0 Karma

KpiBuff
Explorer

This may be related to a mixup between a SPLUNK supported Add On for SQL, and an unsupported App for SQL that has since been discontinued.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Introduction to Splunk AI

How are you using AI in Splunk? Whether you see AI as a threat or opportunity, AI is here to stay. Lucky for ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Maximizing the Value of Splunk ES 8.x

Splunk Enterprise Security (ES) continues to be a leader in the Gartner Magic Quadrant, reflecting its pivotal ...