Which forum software are you using?

As I don't have a forum installed anywhere I cannot say if it is possible by the UI, but it should be possible with an SQL statement, either using SSMS or the SQL Console in DNN (as a host user).

If you need that more than once it could be a good idea to use SQL Server Reporting Services.

Happy DNNing!
Michael

Hi Rich. Are you using the Community Forums module? If so, I understand what you're looking for, and we do (kinda) have it on the roadmap. We added subscriber counts for forums and topics in 7.0.10 (https://github.com/DNNCom...yForums/issues/185), and part of that feature request is to allow a moderator to view (and potentially update) the subscriber list. I added a new issue for that (https://github.com/DNNCom...tyForums/issues/597)

Yeah, once we know which forum(s) and version, we can maybe provide a more helpful answer. 😊

Though, it's most likely going to be a SQL statement you'd need to run.

Thanks for your response, Gents. however I can't see which forum we have on our site. It seems pretty standard, however.

A bit of background - we're a UK nationwide single species angling club. the chap who developed the site has recently left the club (sadly) and I've picked up the maintenance.

I think it's the same forum software as the one I'm currently typing into. Where below there a tick box to check, and subscribe.

In the longer term we want to hire a developer to enhance the site - a gallery and a read-only document archive.

I'm a sql dev by trade but don't have the time to delve into DNN as a development tool.

In terms of querying the site directly (logged in as host) I have no idea which tables hold the data I need. Is there a schema available?

Is there a URL we can look at?

[...]
I think it's the same forum software as the one I'm currently typing into. Where below there a tick box to check, and subscribe.
[...]

Then it is propably Active Forums. A look in the Extensions list could make you sure.

[...] I'm a sql dev by trade [...]

There are some tables in the database named activeforums_*. The users are in a table called Users, mind the UserPortals table as well, when you have more than one portal installed using the same database. As an SQL dev it should be easy for you to check the tables and create a query for your purpose.

If you change (insert/update/delete) data in the database be sure to make a backup before, or to setup a testing environment to be sure that everything will work fine after your changes. To take the changes into effect on the website restart the application pool or clear the cache.

Happy DNNing!
Michael

There is, however, forum access is only for users.  Sorry

Thanks Michael - that's very helpful

Some suggestions:

Do you have a Host or Admin login?

In that case you can see in the settings of the module what Forums module is used.
If not, inspect the Forum page's HTML and look for the "DnnModule-ActiveForums" class

In that case the module project page can be found here: https://github.com/DNNCom.../Dnn.CommunityForums

And there's a database model in the Wiki

https://github.com/DNNCom.../wiki/Database-model

You might be running an older verison of the module but at least it's a pointer to the tables :-)