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, an upvote 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, an upvote 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
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>