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 <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 > > -- 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
