Communities Reporting

[Dario Marquez]

Hi, I am trying to understand Communities data. I am trying to identify the best table to use to get the count of users in our community instance. So far I see there are 2 possible tables, what is the difference between these?

1. User [sys_user] table, filtering: Roles = sn_communities.community_user and Active = True
2. and Community Profile [sn_communities_profile] table

Both give different numbers, I see the out-of-the-box dashboard uses the #1, but would like to know what is the difference with the data in the Community Profile table. Or is there any documentation or dictionary with the descriptions of these tables? Thank you

[Ralton Stewart]

@Dario Marquez did you get anywhere with this I find myself in a similar position.

[Dario Marquez]

Not much, had to do my own research, and this is what I found:
The Community out-of-the-box Dashboard is filtering:
*Users that have accepted the 'Terms & Conditions' (T & C), (meaning that the user signed up, and went throught the email step
to log in and accepted the T & C, which allows the user to participate in the Forums)
*only Active Users
*and the report uses data from the ‘User' table [sys_user]

While the Community Profile table [sn_communities_profile] is counting all users, including users that started the sign-up process but never accepted T&C, so they can view but not participate in the forums community.