topic Search query does not return any values in Getting Data In

Search query does not return any values

pratapa — Mon, 13 Jul 2020 09:46:03 GMT

User complains that the following query is not returning any values in Splunk.

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

0 events

Time range picker : All time

when he runs the same query at database end it is returning results.

Following is the query he is running on database.

select REC_TYPE, CODE_TYPE, CODE_DESC, SHORT_DESC, USER_ID from wmsew.SYS_CODE_TYPE;

Why it is not returning any results when we run in splunk.

anilchaithu — Tue, 14 Jul 2020 04:14:17 GMT

If the users are trying the SPL you shared here, then The syntax is not correct

Please try this

| dbxquery connection="connection_name" query="select REC_TYPE, CODE_TYPE, CODE_DESC, SHORT_DESC, USER_ID from SYS_CODE_TYPE"

Hope this helps

pratapa — Tue, 14 Jul 2020 10:29:29 GMT

This worked.

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

We created database connection under setting->External Databases and after that restarted splunk on the host.

When we tried the below query, it worked.

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

This issue is resolved.