Splunk Search

Database Records

rahul2gupta
Path Finder

Hi @gcusello ,

Following is the query that used to return database records but now it is not working.

dbquery wmsewprd  "select REC_TYPE, CODE_TYPE, CODE_DESC, SHORT_DESC, USER_ID from SYS_CODE_TYPE"

Regards,

Rahul

0 Karma

DavidHourani
Super Champion

Hi @rahul2gupta 

What's the error you're getting.

dbquery command is very well documented here : 

https://docs.splunk.com/Documentation/DBX/3.3.1/DeployDBX/Commands

Cheers,

David

0 Karma
Get Updates on the Splunk Community!

Splunk Enterprise Security: Your Command Center for PCI DSS Compliance

Every security professional knows the drill. The PCI DSS audit is approaching, and suddenly everyone's asking ...

Developer Spotlight with Guilhem Marchand

From Splunk Engineer to Founder: The Journey Behind TrackMe    After spending over 12 years working full time ...

Cisco Catalyst Center Meets Splunk ITSI: From 'Payments Are Down' to Root Cause in ...

The Problem: When Networks and Services Don't Talk Payment systems fail at a retail location. Customers are ...