Hi Team, As per business requirement, need to get below details from same autosys batch and corresponding outputs to be displayed on the single row in a table: 1. Last execution time 2. Execution time of specific search keyword i.e., Completed invokexPressionJob and obtained queue id :: 3. Number of times "ERROR" keyword present
index="<indexid>" Appid="<appid>" host IN (<host01>) source="<log_path01>"
| stats latest(_time) as latest_time
| convert ctime(latest_time)
| append [search index="<indexid>" Appid="<appid>" host IN (<host01>) source="<log_path01>"
| search "Completed invokexPressionJob and obtained queue id ::"
| stats latest(_time) as last_success_time
| convert ctime(last_success_time)]
| append [search index="<indexid>" Appid="<appid>" host IN (<host01>) source="<log_path01>"
| rex field=_raw "\s(?P<level>[^\/]+)\s\[main\]"
| stats count(level) by level
| WHERE level IN ("ERROR")] | append [| makeresults | eval job_name="Print Job"]
| table latest_time last_success_time count(level) job_name
| stats list(*) as *
Above query works fine. From query performance prospective, am I achieving the output right way? Is there any other better to achieve it? Because, similar set to query I need to apply to 10 other batch jobs inside the Splunk dashboard. Kindly suggest!!
... View more