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

Lithium admin statistics

Hi Guys,

 

Second post of me trying to decide whether I should use Lithium as a community support forum.

 

I'm googling it for some time but couldn't find a focused answer...

As an admin, I'd really like to know some general statistics such as:

 

1. Unresolved posts.

2. Correct answers per users (and kodus, comments, etc.)

3. Filtering posts by time (let's say 'all posts since X till Y') 

 

and some more of these.

Are there ways for me to get it?

I's prefer some sort of a dashboard (but even admin console with REST API would be fine).

 

Thanks 🙂

Liran.

2 Replies 2

@kurtzi-

 

Yes, you can achieve this.

Give kudos if you find my posts helpful or mark solution if it answers your query.
Tariq

@kurtzi-

 

1. Unresolved post.

 

SELECT *  FROM messages WHERE is_solution = false

 

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collecti...

 

2. Correct answers per users (and kodus, comments, etc.)

Kudos Count

 

Select  kudos_received.sum(weight)  from users where id = '<user.id>'

Answers Count

 

 

SELECT solutions_authored.count(*) FROM users WHERE id = '31'

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collecti...)

 

 

 

3. Filtering posts by time (let's say 'all posts since X till Y') 

 

SELECT subject, id FROM messages WHERE post_time > 2013-10-07T10:04:30-08:00 AND post_time < 2013-11-07T10:04:30-08:00 

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collecti...

 

 

Give kudos if you find my posts helpful or mark solution if it answers your query.
Tariq

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.