All Apps and Add-ons

dbxquery - is the massage from the db interface available?

damucka
Builder

Hello,

We work quite much with the SQL statements executed using dbxquery. It would be very helpful for us to have the response of the database interface. Here I mean not only the result itself (dataset returned), but also the error and status messages, like the number of rows affetced / updated / inserted, etc.

Example:
After execution of the delete statement on the database, we get the following message:

Statement 'delete from ZKPID_HHIGHMEM_STATEMENTS' 
successfully executed in 6 ms 575 µs  (server processing time: 1 ms 587 µs) - Rows Affected: 595  

It would be very good to have it under some variable in SPL.
Is it possible?

Another example:
Let us say I have the following SQL statement: insert into tab1 (select * from tab2);
I would like to know:
- was the insert successful?
- how many rows have been inserted?

Please advice.

Kind Regards,
Kamil

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 ...