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

[Michael Hafen]

I added these three to the Wiki.  I noticed that I made a mistake in the
middle one while I was at it: categorycode should be itype.

On Tue, 2009-10-06 at 07:41 -0400, Nicole Engard wrote:
> 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
> >
-- 
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