Splunk Search

Error when using a Datamodel in a Macro

ebs
Communicator

Hi,

I'm using the following datamodel search:

| datamodel Test_Ping_Access summariesonly=true search | search "Ping_Access__TEST.date"=$date$ | stats count(exchangeId)

And I've confirmed its working, but when I use it in a macro I get this error:

Error in 'SearchParser': The datamodel command can only be used as the first command on a search

How can I resolve this?

Labels (1)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

When creating a macro that uses a generating command, such as datamodel or inputlookup, you need to leave the | symbol out of the macro definition, so your macro will just be

datamodel Test_Ping_Access summariesonly=true search | search "Ping_Access__TEST.date"=$date$ | stats count(exchangeId)

and then you use it like this

| `my_datamodel_macro(date)`

View solution in original post

bowesmana
SplunkTrust
SplunkTrust

When creating a macro that uses a generating command, such as datamodel or inputlookup, you need to leave the | symbol out of the macro definition, so your macro will just be

datamodel Test_Ping_Access summariesonly=true search | search "Ping_Access__TEST.date"=$date$ | stats count(exchangeId)

and then you use it like this

| `my_datamodel_macro(date)`

ebs
Communicator

Thanks!

0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...