topic Re: DB Query in Splunk Search

DB Query

rahul2gupta — Thu, 20 Aug 2020 05:32:54 GMT

Hi All,

Can someone advice what is wrong with this following query.

|dbquery wmsewprd "select * from sys_code_type where rec_type='C'" when I run this ,I get an error.

But when I use wmsew.sys_code_type instead of sys_code_type I get the exact output.Can any help me this.Our requirement is to work |dbquery wmsewprd "select * from sys_code_type where rec_type='C'" .

wmsewprd -- External Database.

Regards,

Rahul

Re: DB Query

richgalloway — Thu, 20 Aug 2020 12:44:44 GMT

I don't understand why, when you know the syntax that works, you insist on using syntax that does not work.
If you need to use a different name later in your query then you use rename wmsew.* as *.

Re: DB Query

rahul2gupta — Fri, 21 Aug 2020 09:47:02 GMT

Hi @richgalloway ,

Could you please elaborate more about this:

If you need to use a different name later in your query then you use rename wmsew.* as *.

Regards,

Rahul

Re: DB Query

richgalloway — Fri, 21 Aug 2020 13:53:06 GMT

You said this query fails

|dbquery wmsewprd "select * from sys_code_type where rec_type='C'

and this one does not

|dbquery wmsewprd "select * from wmsew.sys_code_type where rec_type='C'

So I presume you wish to refer to the sys_code_type field by that name. You can do that, but first you must comply with the database's name rules and include the table name in the query. After that, if necessary, you can use rename to strip out the table name from fields.

|dbquery wmsewprd "select * from wmsew.sys_code_type where rec_type='C' | rename wmsew.* as *