topic Re: How to create a report on error codes and how many times each occurred over a period of time using regex and timechart? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-create-a-report-on-error-codes-and-how-many-times-each/m-p/272328#M81956 <P>Can you provide some lines of log just to ensure the rex match?</P> Tue, 15 Dec 2015 16:14:30 GMT jmallorquin 2015-12-15T16:14:30Z How to create a report on error codes and how many times each occurred over a period of time using regex and timechart? https://community.splunk.com/t5/Splunk-Search/How-to-create-a-report-on-error-codes-and-how-many-times-each/m-p/272327#M81955 <P>In my application, it will print some error codes like OPT-00A001, OPT-00A002, OPT-00A003, upto OPT-00A010. I need to prepare a report to know each error code and how many times occurred over a period of time.</P> <P>No idea how to use regex and timechart to get this kind of report. Please suggest.</P> Tue, 15 Dec 2015 12:14:35 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-report-on-error-codes-and-how-many-times-each/m-p/272327#M81955 parameshjava 2015-12-15T12:14:35Z Re: How to create a report on error codes and how many times each occurred over a period of time using regex and timechart? https://community.splunk.com/t5/Splunk-Search/How-to-create-a-report-on-error-codes-and-how-many-times-each/m-p/272328#M81956 <P>Can you provide some lines of log just to ensure the rex match?</P> Tue, 15 Dec 2015 16:14:30 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-report-on-error-codes-and-how-many-times-each/m-p/272328#M81956 jmallorquin 2015-12-15T16:14:30Z Re: How to create a report on error codes and how many times each occurred over a period of time using regex and timechart? https://community.splunk.com/t5/Splunk-Search/How-to-create-a-report-on-error-codes-and-how-many-times-each/m-p/272329#M81957 <P>Without actual logs, it is very difficult to isolate the pattern for your errorcode to write the correct regex. Having said that, if you error codes are always the same patter "OPT-" followed by 6 characters, then you can use this. This also assumes the error code appears only once an event. This also assumes, this pattern of OPT- followed by 6 chars doesn't occur anywhere else in the event. If it does, this regex will only get the first occurrence</P> <PRE><CODE>| rex "(?&lt;ec&gt;OPT-\w{6})" | timechart count by ec </CODE></PRE> Tue, 15 Dec 2015 16:53:22 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-report-on-error-codes-and-how-many-times-each/m-p/272329#M81957 sundareshr 2015-12-15T16:53:22Z