Getting Data In

Parsing SQL Queries

masterpiece
Engager

I am analyzing SQL Queries executed by users, is there any way to parse this queries. e.g. In insert query every time schema and values will be dynamic.

Sample event :

insert into UtilityConnectivityHandler(ErrorCode,InstanceName,MailHost,MailBox,IssueDesc,IssueDateTime)VALUES ('A','B','C','D,E,F,G','H ',GETDATE())

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What are you wanting to retrieve from the events?

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

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