Make sure you add these reports to the SQL Reports page on the wiki - and always check there for reports that others have written: http://wiki.koha.org/doku.php?id=sql_library
Nicole On Mon, Oct 5, 2009 at 5:19 PM, Michael Hafen <mdha...@tech.washk12.org> wrote: > I don't mess with the reports, so I can't help with them. For this I > would run a few SQL commands. I'll write some here for you. > > SELECT COUNT(barcode) FROM items WHERE barcode <> '' AND barcode IS NOT > NULL > > SELECT categorycode,COUNT(barcode) FROM items WHERE barcode<> '' AND > barcode IS NOT NULL GROUP BY categorycode; > > SELECT COUNT(biblionumber) FROM biblio > > These will give you the total number of barcodes, the number of barcodes > per item category, and the total number of titles in the database. > > Good luck. > > On Tue, 2009-10-06 at 00:59 +0600, Zico wrote: >> Hi, If i want to see total number of inserted books,cds,dvds, journals >> and others which are inserted into my Koha 3.0 server, what i need to >> do? I went to: >> >> Reports --> Statistics Wizards --> Catalog >> >> But, nothing is showing but only 0. But, my inserted items are 5,000 >> approximately. i want to know the exact figure. >> >> -- >> Best, >> Zico >> _______________________________________________ >> Koha-devel mailing list >> Koha-devel@lists.koha.org >> http://lists.koha.org/mailman/listinfo/koha-devel > -- > Michael Hafen > Systems Analyst and Programmer > Washington County School District > Utah, USA > > for Koha checkout > http://development.washk12.org/gitweb/ > or > git://development.washk12.org/koha > > > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel > _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
