Splunk Search
Highlighted

Is there a way to call 2 different data models in a search and join them with stats?

Communicator

Is there a way to call 2 different data models in SPL to join them with stats? I have tried multisearch, but didn't work. like this :

| multisearch [ | pivot. DM1.... ] [ | pivot ..DM2.... ] | stats xx by yy

0 Karma
Highlighted

Re: Is there a way to call 2 different data models in a search and join them with stats?

Contributor

clyde772, try
|pivot DM1..... join [|pivot DM2...]|stats xx by yy

0 Karma
Highlighted

Re: Is there a way to call 2 different data models in a search and join them with stats?

Communicator

Thanks! That's right, I always try to avoid join... I guess I have no more options..

0 Karma