Thierry Lavallee wrote:
Hi, First post. :)
Is there any way to report on ALL the threshold settings configured
across ALL users on the server?
That depends a lot on how SA is integrated and what you mean by a "user".
For the SA cluster at work, I'd do
SELECT * FROM userpref WHERE preference LIKE 'required_score%';
in the database the userpref table lives in.
On one legacy platform, and my personal server, I'd do:
# grep required_score /home/*/.spamassassin/user_prefs
On several other systems I've worked with the question has no meaning
because there is no use of SA-level preferences; any per-user
customization (if there even is any at all!) is done outside of SA
proper - usually checking the spam score or the number of *'s in the
X-Spam-Level header. Checking that in turn can be in any of several
different places depending on whether you're using procmail, sieve,
maildrop, or some other delivery agent.
PS: We are on WHM / Cpanel
A variation on the SQL select or grep above will probably find what
you're looking for, although you may have to spend some time tracking
down which database and table, or where the user_prefs files are stored.
I don't recall having logged into a WHM-based system, and only rarely on
a cPanel install, but I don't think there's an exposed point to list
this kind of information systemwide. You might do better to save a
configuration backup of some kind to your local PC and search through
the data there.
-kgd
