Question How To Allow Moderator To See List of Topic Subscribers?

I would like the moderators to be able to pull up a list of Subscribers to a particular category or topic. I currently don't see a way of doing that. Is there a plugin that I have to install?

I would also like to be able to list users by subscriptions in the back end. Is there a way to do that?

Database collation check: ✔ The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 660 seconds | Max execution memory: 512M | Max file upload: 360M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
1957	Operations	mainmenu	view=home&defaultmenu=1957	discussions/operations	No
2344	General Topics	mainmenu	view=category&layout=list&catid=40	discussions/general-topics	No
1935	Forum	kunenamenu	view=home&defaultmenu=1937	forum	No
1936	Index	kunenamenu	view=category&layout=list&catid=0	forum/index	No
1937	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent	No
1938	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic	No
1939	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies	No
1940	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
1941	My Profile	kunenamenu	view=user	forum/profile	No
1942	Help	kunenamenu	view=misc	forum/help	No
1943	Search	kunenamenu	view=search	forum/search	No

Joomla default template details : ae911truth | author: Kyle Ledbetter | version: 1.0 | creationdate: 4/30/2012

Kunena default template details : Blue Eagle5 | author: Kunena Team | version: 1.5.2 | creationdate: 2018-12-11

Kunena template params:

Warning: Spoiler!

DefaultCategoryicon
profileIconset	default
DefaultIconset	default
editorIconset	default
bootstrap	0
icomoon	1
tooltips	1
borderless	1
SubjectLengthMessage	80
fullactions	1
quick	0
displayMenu	1
displayDropdownMenu	1
displayDropdownContent	1
displayModule	1
displayBreadcrumb	1
displayAnnouncement	1
displayFooter	1
avatarPosition	left
avatarType	img-circle
labels	0
whoisonlineName	default
formRecover	0
topicicontype	image
fontawesome	0
socialshare	0
socialsharetag
socialtheme	classic
optional_username	0
writeaccess	0
localstorage	0
IconColor	inherit
IconColorNew	#48a348
forumHeadercolor
announcementHeadercolor
announcementBoxbgcolor
frontstatsHeadercolor
whoisonlineHeadercolor
inactiveTabcolor	#395673
activeTabcolor
hoverTabcolor
topBordercolor
inactiveFontcolor
activeFontcolor
forumLinkcolor
enableSkinner	0
editor	0
video	1
maps	1
emoticons	1
twitter	1
ebay	1
link	1
picture	1
hide	1
spoiler	1
table	1
code	1
quote	1
divider	1
instagram	1
soundcloud	1
confidential	1
hr	1
listitem	1
supscript	1
subscript	1
numericlist	1
bulletedlist	1
alignright	1
alignleft	1
center	1
underline	1
italic	1
bold	1
strikethrough	1
colors	1
size	1
wysibb	bold,italic,underline,strike,sup,sub,justifyleft,justifycenter,justifyright,|,img,video,link,|,bullist,numlist,|,fontcolor,fontsize,fontfamily,|,quote,code,table,removeFormat
avatarSizeX	40
avatarSizeY	90
avatarSizeXThumb	36
avatarSizeYThumb	36
avatarSizeXWelcome	72
avatarSizeYWelcome	72
avatarSizeXList	36
avatarSizeYList	36
avatarSizeXPost	144
avatarSizeYPost	144
avatarSizeXProfile	200
avatarSizeYProfile	200
templatebyText
templatebyName
templatebyLink

Kunena version detailed: Kunena 5.1.8 | 2018-12-30 [ Janus ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	1
template	blue_eagle5
showannouncement	1
avataroncat	1
catimagepath	category_images
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	0
reportmsg	1
username	0
askemail	1
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	43200
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	64
maxsig	300
regonly	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	0
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	512
imageheight	1024
imagewidth	1024
imagesize	4500
filetypes	txt,rtf,pdf,7z,zip,zipx,rar,tar.gz,tgz,tar.bz2,doc,docx,xls,xlsx,ppt,mp3
filesize	20000
showranking	1
rankimages	0
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	0
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	15
trimlongurlsback	40
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	1800
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
allow_user_edit_poll	0
maxpersotext	64
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
imagetypes	jpg,jpeg,gif,png,tif,tiff
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png,application/msword,application/excel,application/pdf,image/tiff,application/x-tar,application/x-compressed,application/x-zip-compressed,application/zip,multipart/x-zip,application/gnutar,application/mspowerpoint,application/powerpoint,audio/mpeg3
imagequality	50
thumbheight	80
thumbwidth	80
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	2
show_session_starttime	1800
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	50
email_recipient_privacy	bcc
captcha_post_limit	0
image_upload	registered
file_upload	everybody
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	15
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	0
cache_time	600
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	1
legacy_urls	0
attachment_protection	1
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	365
teaser	1
ebay_language	0
allow_change_subject	1
max_links	25
read_only	0
ratingenabled	0
url_subject_topic	1
log_moderation	1
attach_start	0
attach_end	14
attachment_utf8	1
autoembedsoundcloud	1
emailheader	media/kunena/email/911tap-kunena-email-banner.png
user_status	1
signature	1
personal	1
social	1
plain_email	0
moderator_permdelete	0
avatartypes	gif, jpeg, jpg, png
smartlinking	0
defaultavatar	nophoto.png
defaultavatarsmall	s_nophoto.png
quickreply	1
avataredit	0
activemenuitem
mainmenu_id
home_id
index_id
moderators_id
topiclist_id
misc_id
profile_id
search_id
avatar_type	1
sef_redirect	1
allow_edit_poll	1
use_system_emails	0
autoembedinstagram	1
recaptcha_publickey	6LdIKv8SAAAAAFL7Y30UtiKkrZMBDGgU51Wy5ChT
recaptcha_privatekey	6LdIKv8SAAAAANknKI6m4V-wqeG76wujfml4m4C2
recaptcha_theme	clean
keywords	0
userkeywords	0

| Kunena integration settings:

Warning: Spoiler!

Kunena - Finder Enabled
Kunena - AltaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Easyblog Disabled
Kunena - Easyprofile Enabled: avatar=1 guestavatar=easyprofile profile=1 userlist=1
Kunena - Easysocial Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-US	English (USA)
en-CA	English (Canada)
en-GB	English (en-GB)
uk-UA	Українська (Україна)
en-AU	English (Australia)

Third-party components: None

Third-party SEF components: None

Plugins: Search - Kunena Search 5.1.1

Modules: Kunena Latest 5.1.1 | Kunena Stats 5.1.1 | Kunena Search 5.1.1

Hello Webdevtim,
I have the same question : how to list the subscribers on a category or topic.
Did you find a way to do so ?
Thanks

If you use phpmyadmin and search in the kunena_user_topics for the topic_id you will get subscribers as user_id i.e as a number but not username.

Thank you for your answer. I have just been in this kunena_user_topics table, and can see the subscribed column, which is always set at 1, for any topic. Then, the column with user_ids is le last_post_id column, identifying the users who have posted on a topic.
But I cannot see the subscribed users ids .
Any suggestion ?

The second is topic_id that identifies the topic. Thats what you have to serach for to get info which user_id have subscribed on this topic.

Is there any way to do show this on the frontend for site moderators (without the need to give them PHPMyAdmin access...?