Splunk Enterprise

Database queries

RJ2
Observer

From Splunk, can I see the queries that have been implemented in the database?

like update, delete, insert, etc.?

0 Karma

inventsekar
SplunkTrust
SplunkTrust

Hi @RJ2 

Splunk does not uses any database.
It uses some simple "flat files" and some bigdata map reduce algorithms at the backend. 

so we can not find out the queries of delete, update, etc

hope its clear to you, if you have further questions, pls let us know. 

upvotes appreciated, if a reply solved your issue, pls accept it as the solution, thanks. 

 

Best Regards,

Sekar

thanks and best regards,
Sekar

PS - If this or any post helped you in any way, pls consider upvoting, thanks for reading !
0 Karma

RJ2
Observer

YES, BUT HOW? 

0 Karma

PickleRick
SplunkTrust
SplunkTrust

1. Please don't shout.

2. It depends on what kind of data you have. Without knowing that we can't help you. Properly deployed Splunk infrastructure should have some docummented inventory of the sources ingested, sourcetypes, destination indexes and so on.

3. Also just because you can log in to your Splunk server doesn't mean you have access rights to the indexes containing information you need. You have to consult with your local Splunk admin about it.

0 Karma

PickleRick
SplunkTrust
SplunkTrust

What do you mean? You want to see what queries your users run against your database server? Do you have apropriate logging set up in your database server? Do you ingest logs from that database server to your Splunk installation? If an answer to all those questions is "yes", you should have your database activity logs in your Splunk environment and should be able to search through that data.

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...