Re: calendar statistics

Quoting Fernando Duarte <[email protected]>:

> hello all,
>
> I want to know if my users are using/sharing calendars. Some basic
> statistics.
>
> How can i find the number of active calendars?

Depends what you mean by "active". For calendars that contain *any*  
events, query the storage backend directly for this information. E.g.,  
For SQL backend, look for unique calendar_id values in  
kronolith_events table. If you are talking about some kind of recent  
usage filter, you would filter on something like event_modified. Note  
that this only takes into account normal "internal" calendars.

> and fraction of shared
> calendars?

For this, you would need to query the share system. You could write a  
script to list all shares, then check each one to see if any  
permissions have been set. If you are only interested in the "active"  
calendars from above, you could just list those shares. This would be  
done via the Horde_Share library code. Depending on how often you need  
to do this, it might be easier to just query the backend directly here  
as well. Look at the kronolith_shares_* or kronolith_sharesng_* tables  
(depending on which share system you are using).



> thanks in advance.
> --
> kronolith mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: [email protected]



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject

-- 
kronolith mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]