No worries, the other poster was just wasn’t being helpful. And/or doesn’t understand statistics & databases, but I don’t care to speculate on that or to waste more of my time on them.

The setting above maxes out at 24h in stock builds, but can be extended beyond that if you are willing to recompile the FTL database with different parameters to allow for a deeper look back window for your query log. Even at that point, a second database setting farther down that page sets the max age of all query logs to 1y, so at best you’d get a running tally of up to a year. This would probably at the expense of performance for dashboard page loads since the number is probably computed at page load. The live DB call is intended for relatively short windows vs database lifetime.

If you want an all-time count, you’ll have to track it off box because FTL doesn’t provide an all-time metric, or deep enough data persistence. I was just offering up a methodology that could be an interesting and beneficial project for others with similar needs.

Hey, this was fun. See you around.

You know what? I’m gonna disengage here. You’re not hearing what I am saying.

#### MAXLOGAGE=24.0
Up to how many hours of queries should be imported from the database and logs? Values greater than the hard-coded maximum of 24h need a locally compiled `FTL` with a changed compile-time value.

I assume this is the setting you are suggesting can extend the query count period. It still will only give you the last N hours’ worth of queries, which is not what OP asked. I gather OP wants to see the cumulative total of blocked queries over all time, and I doubt the FTL database tracks the data in a usable way to arrive at that number.

Ah, well if you know differently then please do share with the rest of us? I think the phrasing in my post makes it pretty clear I was open to being corrected.

So, like a running sum? No, I don’t think so, not in Pi-hole at least.

Pi-hole does have an API you could scrape, though. A Prometheus stack could track it and present a dashboard that shows the summation you want. There are other stats you could pull as well. This is a quick sample of what my home assistant integration sees

That counter, I believe, for the last 24 hours. It will fluctuate up and down across your active daily periods

Sounds like a sitcom?

Unless I misunderstand your question, draw.io can be downloaded as a standalone Linux application and run locally.

Likewise, the Xfig package should he available in most Linux repos. It’s old, but good enough for a quick sketch.

edit: aha. My mistake. My eyes slid over ‘open source’ in the title*, and even still I hadn’t realized it was an Apache license.

* Whaaat, it was pre-coffee? Let the purest among us cast the first stone.

deleted by creator

Do you mean JD Vance as in, “JD Vance, the fake hillbilly yokel?”

That’s enough Internet for me today, I think.

Gonna be more challenging as populated areas become favorable mosquito breeding ground because someone woke up the global warming Climazilla.

This here is good old elemental irony, not that weird Morissette isotope so popular back in the Aughties. Cook some bacon on this irony, because it’s heirloom.

edit: AND DON’T USE SOAP ON IT!

Most likely a mosquito bite. West Nile Virus isn’t uncommon in the Eastern US. While it’s not epidemic, it’s prevalent enough that you’d want to manage mosquito population and minimize your exposure to bites with long clothes or DEET bug repellent.

Not only does it need blocking on the wheels, but that thing’s also apt to be stolen with the hitch just sitting there like that. They might consider parking a car in front of it too.

Oh, goddammit.

Black eyed peas. I’m not gonna tellya twice.

Vance is truly a gift. If that villain didn’t already exist, the Democrats would have to create him.

(I’m still not convinced Vance isn’t some Manchurian Candidate sleeper agent time traveler sent back to sabotage any future Trump presidency)