[Koha-devel] Koha 3.0 total number of books, cds, dvds, journals and others

[Nicole Engard]

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 <mdhafen at 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 at 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 at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>