Showing results for 
Show  only  | Search instead for 
Did you mean: 

LiQL Post Count, Kudo count, an solution count for users in one week.

I'm having some trouble figuring out the best way to get an automated report from Lithium. I only need a few stats, and I have gotten the post count with:

"******/search?q=SELECT+count%28*%29+FROM+messages+WHERE+author...' | jq -r '.data.count"

But I can not figure out how to get the kudos or the solutions by time period.

4 Replies 4


You can use below metrics api to get kudos count in community on date range



Expecting your Kudos and Accepted Solution to my replies.

Thank you for the reply! But I actually need to keep track of things per user.


I'm trying to keep track of employee activity on our community.


Do you have any idea how I could pull this off?


Using V1:

Below API will return you kudos count for the last week.



Below API will return you Total Posts Count for the last week:



 Below API will return you Total Accepted solution Count for the last week of user:




You can get Overall Post count, Kudos count and Solution count of the user using below LiQL API V2


SELECT messages.count(*), kudos_received.sum(weight), solutions_authored.count(*) FROM users WHERE id = '4'

Using this API will return response for one user for





Expecting your Kudos and Accepted Solution to my replies.

Thanks for that! Based on the paths, that looks like it would work!

For whatever reason, I am getting permission denied though.

I have admin access, I wonder if there is another role that I need to have?

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.