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 metadata_field_id=66 and text_value='phd';
How can I do that?
Thanks,
Tonny
On 2011-01-26 00:01, Peter Dietz wrote:
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 should be able to be customized
to provide interesting views of the repo.
--
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries
We do offer statistics on the content as part of our commercial
Content & Usage Analysis module.
Here's a very short screencast that shows how this works:
http://screencast.com/t/lNN8zLBf
best regards,
Bram Luyten
@mire
Technologielaan 9 - 3001 Heverlee - Belgium
2888 Loker Avenue East, Suite 305 - Carlsbad, CA 92010 - USA
atmire.com <http://atmire.com/> - Institutional Repository Solutions
On Tue, Jan 25, 2011 at 2:06 PM, Tonny Hjelmberg Laursen
<thl....@cbs.dk <mailto:thl....@cbs.dk>> wrote:
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 shooting some reguests to the webservice?
The other way would be to take the data directly from the
Postgres database.
Have anyone done this before and would like to share how.
Thanks
Tonny
Dspace 1.6.1 / XMLUI
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD
value)!
Finally, a world-class log management solution at an even
better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
<mailto:DSpace-tech@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better
price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
<mailto:DSpace-tech@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
--
Venlig hilsen | Kind Regards
Tonny Hjelmberg Laursen
Systemadministrator
CBS Library IT
Copenhagen Business School
Solbjerg Plads 3 (D2.30), DK-2000 Frederiksberg
Tel.: (+45) 3815 3697 | Mob.: (+45) 2427 3242 | thl....@cbs.dk
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech