Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > news.groups > #15618

Re: List of active (used) groups

From Thomas Hochstein <thh@thh.name>
Newsgroups news.groups
Subject Re: List of active (used) groups
Date 2026-06-20 11:46 +0200
Message-ID <ng.20260620114648.788@scatha.ancalagon.de> (permalink)
References <1115k9u$fnd1$1@solani.org>

Show all headers | View raw


Marco Moock wrote:

> I would like to extend that with a list of active groups, e.g. groups 
> that received new posts in the last year etc.
> 
> Is there an easy way for server operators to create such statistics?

Probably not out of the box. A bit clunky and work in progress [1]:
<https://code.virtcomm.de/thh/newsstats>

The stats in de.admin.lists and <https://de-usenet.de/files/stats/>
are generated this way.

By default, you'll have to capture "live" data, i.e. the database will
be filled starting with installation and configuration. You can add
single posts by Message-ID with the "addpost" tool (designed to re-add
"dropped" postings e.g. when the database goes down before the
newsserver), so you could grab/grep all storage tokens from your INN
history file and feed them in a loop through sm to addpost. Never
tried, no idea of the performance with really large datasets (you
could take a Message-ID from a post a year ago, get the storage token
with grephistory and process the tokens from history starting with
that token, so you get only a year of posts).

If you don't need to filter out crossposts, don't want to save your
raw data to create more stats without parsing everything again and
don't need more elaborate stats, you could simple do the above without
using NewsStats at all: grep all storage tokens from history (perhaps
starting at a known point in time), loop them through sm and grep for
Newsgroups, split the contents of the header by comma, and count each
component.

-thh

[1] It works, but the code is in dire need of refactoring and removing
code reuse. I never had the time to re-do it right after starting it
in 2010 or so.

Back to news.groups | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

List of active (used) groups Marco Moock <mm@dorfdsl.de> - 2026-06-20 10:51 +0200
  Re: List of active (used) groups Thomas Hochstein <thh@thh.name> - 2026-06-20 11:46 +0200
  Re: List of active (used) groups "Adam H. Kerman" <ahk@chinet.com> - 2026-06-20 15:00 +0000
    Re: List of active (used) groups pschleck@panix.com (Paul W. Schleck) - 2026-06-23 12:31 +0000
      Re: List of active (used) groups Steve Bonine <spb@pobox.com> - 2026-06-23 18:28 -0500
        Re: List of active (used) groups pschleck@panix.com (Paul W. Schleck) - 2026-06-24 03:46 +0000
          Re: List of active (used) groups Steve Bonine <spb@pobox.com> - 2026-06-25 17:56 -0500
  Re: List of active (used) groups gmc@metro.cx (Koen Martens) - 2026-06-20 17:22 +0000
    Re: List of active (used) groups gmc@metro.cx (Koen Martens) - 2026-06-20 17:31 +0000
      Re: List of active (used) groups Marco Moock <mm@dorfdsl.de> - 2026-06-20 21:18 +0200
      Re: List of active (used) groups Marco Moock <mm@dorfdsl.de> - 2026-06-20 21:28 +0200
        Re: List of active (used) groups gmc@metro.cx (Koen Martens) - 2026-06-21 06:59 +0000
  Re: List of active (used) groups Steve Bonine <spb@pobox.com> - 2026-06-22 10:16 -0500
    Re: List of active (used) groups gmc@metro.cx (Koen Martens) - 2026-06-22 17:50 +0000
      Re: List of active (used) groups "Adam H. Kerman" <ahk@chinet.com> - 2026-06-22 18:23 +0000
  Re: List of active (used) groups pschleck@panix.com (Paul W. Schleck) - 2026-06-23 13:02 +0000
    Re: List of active (used) groups Marco Moock <mm@dorfdsl.de> - 2026-06-23 15:12 +0200
      Re: List of active (used) groups Thomas Hochstein <thh@thh.name> - 2026-07-05 12:23 +0200

csiph-web