Reporting

Using DBQuery to update DB table data

kenchisho
Path Finder

I am using the "dbquery" command to update tables in MSSQL 2008.

The search is something like:

| dbquery test_db "UPDATE test_table1, test_table2 SET Data1='test1', Data2='test2', Status='Closed' WHERE AccountNumber='1234567890988'"

The inline search updates the database as expected. However the search provides no results which I can use to tell the user if it succeded or not.

The Job inspector shows a message... Update statement executed. 1 rows affected. Is it possible to display this message as a search result?

tachifelix
Path Finder

add select command after update like "select Data1, Data2, Status from test_table1, test_table2 where Status='Closed' and Data2='test2' and Data1='test1' "

Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...