Re: [Dspace-tech] Yearly DSpace statistics

This is really nice. Would it be possibly to count by dc.type too? This one selects everything for 2010: select count(item_id) from metadatavalue where metadata_field_id=12 and text_value like '2010%' If I want to get the number for each type then there should be added something like: and

[Dspace-tech] Yearly DSpace statistics

Hi, What's the best way to get statistics from our dspace installations? What I need to know is eg. How many new items have been added in 2010? How many new items have been added in each community/collection in 2010? I think i have seen that we can get this kind of information from SOLR, by

Re: [Dspace-tech] Yearly DSpace statistics

Hi Tonny, as far as I know, you can't get this type of information from the SOLR (statistics) because it only stores usage events (pageviews downloads). However, the new Discovery (DSpace 1.7) SOLR facted browse interface indexes all metadata (or all metadata that you want it to index). So,

Re: [Dspace-tech] Yearly DSpace statistics

Hi Tonny, Prior to 1.7, I think you should query the Postgres directly. See this thread for more info: http://www.mail-archive.com/dspace-tech@lists.sourceforge.net/msg12295.html It has helped me make reports, cheers: Claudia Jürgen and George Hamilton Going forward in 1.7, solr/discovery