Im using the below search and wish to create a notable event from the search. (filtered to not show company info)
sourcetype=DhcpSrvLog description=assign dest!=prefix1* prefix2* destip!=x.x.x.x/20 destip!=x.x.x.x/21 | rex mode=sed field=dest "s/.companydomain.com//g" | where dest!=destmac | table dest,destip,dest_mac,time,date | sort date
When I search manually over last 24 hours I get results, however no notable events are created. Does the correlation search syntax need to be in a certain format to generate the notable event?
The correlation search does need to be in a particular format (needs to make an event in the notable index and have particular fields). I suggest using the Correlation Search Editor to make it (Configuration » Custom Searches) since it will handle the particulars for you. Make sure to enable the "Create notable event" action so that the search creates a notable event for you.
I am also trying to create some custom correlation searches and notables from my daily reports.
Steps I followed to make this:
1. In ES ==> ES ==> Configure ==> Content Mgmt ==> Create New Content ==> Correlation Searches
2. While creating the correlation searches, I added the name of the new notable (assuming that this would create new notable) and scheduled and saved it.
The query runs fine and gives the output in tabular format. Its creating the notables but I am not able to see the contributing events/error event.
As you mentioned above, could you advise on the format needed to make an event in the notable index and have particular fields.
Also, I am unable to find Correlation Search Editor to make it (Configuration » Custom Searches)
I created the notable events in the Configure==> Incident events as well. Still unable to see the contributing events in incidents.
I hadn't named the Drill-down search while creating the notable. Once it was updated, the contributing events started showing up as expected.