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!

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 ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...