XF 2.1 Any way to check how many users have enabled push notifications?

[tafreehm]

I wanted to know how many users have this feature enabled. How do I check that?

 

[Mike]

This should do it:

SELECT COUNT(DISTINCT user_id) FROM xf_user_push_subscription;

 

[tafreehm]

This should do it:

SELECT COUNT(DISTINCT user_id) FROM xf_user_push_subscription;

Thanks Mike. Anyway to know that in the admin panel tho?

 

[Mike]

That would require an add-on.