Hi Team,
I require merging three queries originating from the identical index and sourcetypes, yet each query necessitates extraction and manipulation of its output.
Query 1:
A single index is linked to three unique sourcetypes.
index = abc sourcetype= def, sourcetype=ghi & sourcetype=jkl
Query 2 :
Its same like Query 1
index = abc sourcetype= def, sourcetype=ghi & sourcetype=jkl
Query 3:
Its same like Query 1 & 2
index = abc sourcetype= def, sourcetype=ghi & sourcetype=jkl
The index and sourcetype details remain consistent across all three queries, but the keywords differ.
Thus, I aim to merge the three queries, compare them, and extract the desired output.
For instance, in the initial query, the "Step" field is extracted during the search process, containing diverse data such as computer names and OS information.
In the second query, our aim is to ascertain the count of successful occurrences in the "Step" field, specifically the count of computer names indicating success. Likewise, in the third query, we intend to retrieve information regarding failures.
Query1:
index="abc" ("Restart transaction item" NOT "Pending : transaction item:") | rex field=_raw "Restart transaction item: (?<Step>.*?) \(WorkId:"| table Step |stats Count by Step
Query 2:
index="abc" ("Error restart workflow item:") | rex field=_raw "Error restart workflow item: (?<Success>.*?) \(WorkId:"| table Success |stats Count by Success
Query 3:
index="abc" "Restart Pending event from command," | rex field=_raw "Restart Pending event from command, (?<Failure>.*?) \Workid"| table Failure |stats Count by Failure
Thus, in the initial query, the Step field is extracted, and our objective is to extract both success and failure data from this field, presenting it in a tabular format.
Despite attempting to use a join query, it was unsuccessful. Assistance in this matter would be greatly appreciated.
Kindly help on the same.
... View more