All Apps and Add-ons

Error on passing value to dbxquery procedure parameter using map command

mouradbouzaffar
Loves-to-Learn Lots

Hi,

I need to run a search ,take the output, and pass it to a dbxquery search via map search.

So when i do this as below without the search and th map, every thing work :

| dbxquery query="EXEC [CTS2_Repository].[dbo].[C_sp_CallTransac] 'DE1', '2021-03-02 00:00:00', '2021-03-02 23:59:59'" connection=10VM_CI_BI_UAT

But when i transform that as below, i get the error "Search Factory: Unknown search command 'cts2'."

| eval cust_id="DE1"
| map search=\" | dbxquery procedure=\\\"{{call [CTS2_Repository].[dbo].[C_sp_CallTransac](?,?,?)}}\\\" connection=\"10VM_CI_BI_UAT\" params=\\\"\\\"$cust_id$\\\", 2021-03-03 00:00:00, 2021-03-03 23:59:59\\\"\"

Any help is appreciated.

 

 

Labels (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Don't escape the quotation marks that enclose map's search argument.  They're part of the syntax.  You don't need triple escapes for embedded quotes - that's just for the rex command.

---
If this reply helps you, Karma would be appreciated.
0 Karma

mouradbouzaffar
Loves-to-Learn Lots

Hi,

I tried like this

| eval cust_id="DE1"
| map search="|dbxquery procedure=\"{call [CTS2_Repository].[dbo].[C_sp_CallTransac](?,?,?)}\" connection=\"10VM_CI_BI_UAT\" params=\"\"$cust_id$\", 2021-03-03 00:00:00, 2021-03-03 23:59:59\""

But i get this message :

Error in 'map': Did not find value for required attribute 'cust_id'.

 

0 Karma

richgalloway
SplunkTrust
SplunkTrust

If this query is part of a dashboard then you must use $$cust_id$$ within the map command.

If it's not in a dashboard then I don't know what the problem is.

---
If this reply helps you, Karma would be appreciated.
0 Karma

mouradbouzaffar
Loves-to-Learn Lots

The query is not a part of dashboard.

It's a schedule search.

Thanks for your help

0 Karma
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...