Skip to content

Instantly share code, notes, and snippets.

@tmohrbach
Last active July 16, 2020 04:27
Embed
What would you like to do?
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