SQL Filter for Service UUID Exposure Notification
SELECT | |
datetime(locations.timestamp, 'unixepoch', 'localtime') AS 'Timestamp', | |
devices.service_data AS 'R. Prox. Identifier', | |
locations.rssi AS 'RSSI', | |
locations.latitude AS 'Latitude', | |
locations.longitude AS 'Longitude' | |
FROM | |
devices | |
INNER JOIN locations ON devices.id = locations.device_id | |
WHERE | |
devices.service_data LIKE 'fd6f:%' | |
ORDER BY | |
locations.timestamp; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment