I see why you are an "Esteemed Legend," Sir! I learned A LOT in this, like, for the first time how using 'stats' can be used to figure things out. For those coming later: index="policyguru_d...
See more...
I see why you are an "Esteemed Legend," Sir! I learned A LOT in this, like, for the first time how using 'stats' can be used to figure things out. For those coming later: index="policyguru_data" resourceId="sip*" ("CONNECTED" OR "ENDED") This gets both sets of data I need in one pass. | eval status=if(searchmatch("CONNECTED"),"CONNECTED","ENDED") Then creates a new column (status) that just has "CONNECTED" or "ENDED" in it | stats dc(status) AS status_count. <-- distinct count, so since by guid, if it has both, it'll be 2. If it only has 1, it'll be 1. values(status) AS status <-- display the values in a field called 'status' (I don't need this but it's nice to see/learn!) values(meta) AS meta <-- same as above last(timestamp) AS timestamp <-- capture the most recent timestamp (since there will be two for the matches) BY guid | where status_count=1 AND status="CONNECTED" Then, use 'where' to keep the ones that only have "CONNECTED" (so they do NOT have an ENDED record, which is exactly what I want). Thank you, Legend!