I have created a proximity tracing tool using data exported from Prime Infrastructure. The tool is currently located at http://ciscoProximityTracer.com Please check it out and give me feedback.
To use the tool, the user inputs a “client sessions” report from prime infrastructure. The report has to have the fields of AP name, Session Duration, and RSSI added in, using the exact order shown below.
You can generate for any length of time, I’m currently using either 1 or 7 days when I generate reports. Sorting the output data does not matter. When finished, export to .csv and use that file for the input of the tool.
To use the tool input your file and a MAC address of interest (this would be the person with COIVD19 that you want to track who they came next to). The other 3 fields (max RSSI diff, time resolution, and time offset are optional, defaults are given)
Push the Trace contact button, and the script fires away. It comes back with something like the following:
Simple and effective.
For the week of May 16 MAC 84:85:06:BC:F6:C8 was in contact (<3dBm) with 84:85:06:bf:fc:46 for 1 hour 40 minutes at the AP named MEMO-MAIN-129, and so on.
If you want to play with the tool you can use the PI logfile named “agahome_may28.csv”. and search for the spreader MAC of e4:b2:fb:87:8f:62. That’s my iPhone. Try using different RSSI resolutions and time values.
The tool is located at http://ciscoProximityTracer.com