Getting Data In

Is it possible to add SQL logs without server add-on?

mhpapa62
New Member

Can I add SQL logs without the SQL server add-on?
I need to add SQL logs. I've requested to do this on Splunk and also read many Splunk docs,
but all of them refer to the add on.

We don't have it installed and looks like we have no plans to do it in the near future.
So, in the meantime, how can I add SQL logs into Splunk 8.0.0?

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @mhpapa62,
if you're speaking of SQL Server logs, they are in the Windows Event Viewer, so you can take this and search for the specific SQL Server EventCodes.
The way to take them are different: use the Windows Add-on it's the easiest way, but you can take them also by Splunk Enterprise [Settings -- data Inputs -- Remote event log collections] but this method uses WMI and needs a domain account (I don't like it!).

It's different if you want to extract data from the database: the easiest way is to use DB-Connect App, otherwise, you could schedule a query on the DB that writes results in a file and then read these files using the Splunk Universal Forwarder.

Ciao.
Giuseppe

0 Karma

mhpapa62
New Member

Thank you Giuseppe. Just a question, are you using Splunk 8? I can't find [Settings -- data Inputs -- Remote event log collections] on Splunk 8 settings. Just [Data, Report acceleration Summaries / Source Types].

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @mhpapa62,,
yes, but WMI is available only on Windows machines, so you should use an Heavy Forwarder instaled on Windows Operative System.

Ciao.
Giuseppe

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...