Query Pi hole SQLite

General
1

Hi
I’ve been looking at the SQLite database for Pi-hole. How can I tell what sites have been blocked? I assumed it was the null value in the forward column but the numbers don’t match the stats in counters table.

2

See the documentation here:
https://docs.pi-hole.net/ftldns/database/

Especially the query status types:
https://docs.pi-hole.net/ftldns/database/#supported-status-types

1 Like