SPLUNK - TRN job configuration on SQL 2014

Hi

I am new to Splunk and I need an expert to direct(explain) me what (how) SQL job i need to configure  to receive TRN log on  SQL 2014 server for SPLUNK. Please check attachment and look for line  highlighted on blue .
how to capture db tables in particular database  or logins, this is for splunk.

Do you know how to generate TRN log file (highlighted on blue) for one specific database or for all for SPLUNK?

Thx, M
SPLUNK-pict.jpg
michalek19Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin MillerCTOCommented:
Hi, This question has an element a MS-SQL DB configuration question. If I have read this correctly you need to enable TRANSACTION logs in MS-SQL server, and then point the Splunk agent to where this log is being written.
0
michalek19Author Commented:
Can you tell me how to enable TRANSACTION logs in MS-SQL server, step by step?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
What's SPLUNK is catching is a BACKUP TRANSACTION LOG command. All backups performed in SQL Server is logged in the Windows Event Log and that's why SPLUNK's catching it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin MillerCTOCommented:
michalek19, can we close this ?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.