I have 4 strings which are inside these tags OrderMessage
1) "Missed Delivery cut-off, Redated to <>"
2) "Existing account, Changed phone from <> to <>"
3) "Flagged as HLD"
4) "Flagged as FRD"
The date and phone number will be different but the string will be fixed each time. So I need a search which brings back a timechart count of how many times this string is logged.
My current search brings back 3 of these strings but does not include the last one. I need the last "Flagged as FRD" string to be counted.
index="uvtrans" "<a:OrderMessage>*</a:OrderMessage>"
NOT "<a:OrderMessage>OK</a:OrderMessage>"
| rex "\<a:OrderMessage\>(?P<Phrase>.*?)\<V\a:OrderMessage\>"
| eval Phrase=case(
match(Phrase,"Missed Delivery cut-off, Redated to"),
"Missed Delivery cut-off, Redated to <<Date>>",
match(Phrase,"Existing account, Changed phone from "),
"Existing account, Changed phone from <<PhoneNumber>> to <<PhoneNumber>>",
match(Phrase, "Customer Master flagged as HLD."),
"Flagged as HLD",
match(Phrase,"Customer Master flagged as FRD."),
"Flagged as FRD")
| timechart span=1week count by Phrase
... View more