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?