Hey everyone, thanks for coming back to Wi Fi fundamentals with location and analytics. This course will help you to muster the air. There are many tools many ways to capture Wi Fi frames in your environment and analyze them. I will use a tool a grid utility with the promising name of air tool that will help me to capture every frame that is around. It allows you to capture frames in the 2.4 gigahertz, five gigahertz or just about everything. If I designed to capture all the frames in my environment, it asks me to disconnect as it goes from a manager mode to a monitor mode.
I will and now it starts capturing and as you can see it captures just about everything raining every channel in the 2.4 gigahertz and in the five gigahertz band I have my P cap my capture and now I can filter for probe requests Why am I doing so? Because only stations in my area are probing. Alright, so I have many probe requests, not so many. The next thing to do is to view time as date and time of the day so I can see time clearly it's 951 here. Now, I will save it as a CSV file I would call it pedestrian's dot CSV. All right, saving it in the desktop.
The next thing to do is to open my CSV file in Google Sheets pedestrian's CSV. All right, so I have a sheet full of information that comes from washer. I can just remove unwanted columns. Time is needed. Sources needed destination. It's not so important but the length is Not before interest our society as important as our society can tell us if the pedestrian This station is close to me, or is it far in my store or out of my store?
That column also No, let's make things look a little bit better. Okay stations problems. Let's filter the endpoints with the same MAC address Using the unique filter and there it is. I have 10 stations currently around my store that probe. The next thing to do is to find out who is inside my store and who is outside my store. I've already done in rssi fingerprint, a radio map that showed me that the edges of my store dumps the signal strength to minus 80 and above.
I could have filtered minimum rssi probe requests in the wire Shark, but I wanted to show you how to do it in Google Sheets. So the first thing to do is to turn the minus values into positive values. Let's add another column. Let's call it proximity. And now I'll use the if statement. To find out which stations are near my store, or outside my store bigger or equal to 80 then They're far else.
They're in close brackets. All right, so we can see that station with a value of minus 76 is inside my store. That we drag it all the way down. And we can see that stations within our society of minus 88 are far and they are not in my store. The last thing to do is to insert our data into a chart. That's bigger, our unique stations, insert a chart, add up their rssi value and add labels who is in Always out.
Coming up Wi Fi RTT round trip time of flight. See you soon