https://community.splunk.com/t5/Splunk-Search/How-can-I-speed-up-a-search-by-creating-a-data-model-using/m-p/373559#M109856 <P>I want to speed up a search by creating a data model and using tstats.</P> <P>This is the search using the data model so far:</P> <PRE><CODE>| tstats count from datamodel=WinEvents.Summary by _time, host, Summary.EventCode, Summary.SourceName, Summary.Type, Summary.Keywords span=1m | stats earliest(_time) as First latest(_time) as Last count by host, Summary.EventCode, Summary.SourceName, Summary.Type </CODE></PRE> <P>On the original search, I used eval:</P> <PRE><CODE>...| eval Type=if(Keywords=="Audit Success", Keywords, Type) | eval Type=if(Keywords=="Audit Failure", Keywords, Type) </CODE></PRE> <P>Since that is a complex aggregate function (according to the documentation), how do I make that work with tstats?</P> Mon, 12 Feb 2018 15:53:55 GMT pil321 2018-02-12T15:53:55Z https://community.splunk.com/t5/Splunk-Search/How-can-I-speed-up-a-search-by-creating-a-data-model-using/m-p/373559#M109856 <P>I want to speed up a search by creating a data model and using tstats.</P> <P>This is the search using the data model so far:</P> <PRE><CODE>| tstats count from datamodel=WinEvents.Summary by _time, host, Summary.EventCode, Summary.SourceName, Summary.Type, Summary.Keywords span=1m | stats earliest(_time) as First latest(_time) as Last count by host, Summary.EventCode, Summary.SourceName, Summary.Type </CODE></PRE> <P>On the original search, I used eval:</P> <PRE><CODE>...| eval Type=if(Keywords=="Audit Success", Keywords, Type) | eval Type=if(Keywords=="Audit Failure", Keywords, Type) </CODE></PRE> <P>Since that is a complex aggregate function (according to the documentation), how do I make that work with tstats?</P> Mon, 12 Feb 2018 15:53:55 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-speed-up-a-search-by-creating-a-data-model-using/m-p/373559#M109856 pil321 2018-02-12T15:53:55Z