HI All,
thanks for your promt response. i tried all these possibility and no luck .
i will explain more elaboratively .
I need to know List of "outletID" where two field do NOT have same Value.
The two fields being UserName , Serialnumber from known index and source type .
i tried just like
index=aw_dispenser sourcetype=EnrolledDevices UserName!="SYSTEM" | where NOT UserName=serialNumber| table UserName OutletID
Also when i put |table username,outletid serialnumber it shows only username and outletid(only the 1st two fields).Why is this so?
... View more