Hi I have two searches
search a :
index=*tech* sourcetype=technical_rproxy_access OR sourcetype=technical_mule_api NOT statusCode="0" | rex field=source "/appvol/(?[\w\/]+)/logs.*" | stats count as GWcount values(apiName) as APIatGW ,values(statusCode) as StatusatGW by MULE
search b:
index=* sourcetype=technical_rproxy_access | rex field=api_name "api\/(?[\w\-]+)*" |rename api_name as apiName|stats count as RPCount values(apiName) as APIatRproxy , values(status) as StatusatRproxy
I have combined two as below :
index=*tech* sourcetype=technical_rproxy_access OR sourcetype=technical_mule_api NOT statusCode="0" | rex field=source "/appvol/(?[\w\/]+)/logs.*" | stats count as GWcount values(apiName) as APIatGW ,values(statusCode) as StatusatGW by MULE | join type=left max=0 apiName [ search index=* sourcetype=technical_rproxy_access | rex field=api_name "api\/(?[\w\-]+)*" |rename api_name as apiName|stats count as RPCount values(apiName) as APIatRproxy , values(status) as StatusatRproxy]
I want to join two results such that apiName will be common in both, but my result is not working.
... View more