Please post any SQL Query examples here so that we can help future Jive users get the most out of their Jive system.  Remember, computers are for input/output and the more information that is available to help with the output side of things the more Jive will be utilized.

 

Here is on example of a query that gets users and total Points:

select p.user_id, u.firstname, u.lastname, u.email, sum(p.points) as points from jivedw_statuslevelpnt p

inner join jivedw_user u on p.user_id = u.user_id

where u.userenabled = 1

group by p.user_id, u.firstname,u.lastname,u.email

order by points desc

 

Can anyone share a SQL query that shows the number of points a user has in any specific space?