Hi Claudia, that really helped a lot.
Thanks again! Stefanie -----Ursprüngliche Nachricht----- Von: Claudia Jürgen [mailto:[email protected]] Gesendet: Dienstag, 11. April 2017 16:34 An: Stefanie Behnke; [email protected] Betreff: Re: [dspace-community] number of bitstreams Hi Stefanie, best ask the admin who is in charge of your DSpace instance. It depends on what DB you use. For postgres, if you got access to the machine it is running with a user who's role allows you access to the db: psql [DB-Name] then run the query You may specify a file to output the result to like psql [DB-Name] -o PATH-TO-FILE There are graphical tools like pgadmin for tasks like this, too. Hope that helps Claudia Jürgen Am 11.04.2017 um 16:02 schrieb Stefanie Behnke: > Thank you Claudia, > > one question, perhaps a silly one: How can I access the database? > > Thank you! > Stefanie > > -----Ursprüngliche Nachricht----- > Von: [email protected] > [mailto:[email protected]] Im Auftrag von Claudia > Jürgen > Gesendet: Dienstag, 11. April 2017 15:03 > An: [email protected] > Betreff: Re: [dspace-community] number of bitstreams > > Hallo Stefanie, > > you may query the database. > Here is a query which will give you all the bitstreams of the items which are > in_archive are not of internal format. Derived bitstreams like extracted > text, thumbnail and licenses are excluded: > select bf.mimetype, count (b.bitstream_format_id) as Anzahl, > bf.bitstream_format_id from bitstreamformatregistry bf , bitstream b > where b.bitstream_format_id=bf.bitstream_format_id and > bf.internal=false and b.bitstream_id in (select bitstream_id from > bundle2bitstream where bundle2bitstream.bundle_id in (select > resource_id from metadatavalue where text_value='ORIGINAL' and > metadata_field_id=64 and > resource_type_id=1 and resource_id in (select bundle_id from > item2bundle where item_id in (select item_id from item where > in_archive=true and owning_collection in (select collection_id from > community2collection where community_id=YOUR_COMMUNITY_ID))))) group > by bf.mimetype, bf.bitstream_format_id order by bf.mimetype; > > Replace the YOUR_COMMUNITY_ID with the real one. > > You'll get something like: > mimetype | anzahl | bitstream_format_id > -------------------------------+--------+--------------------- > application/pdf | 50 | 3 > application/postscript | 2 | 24 > application/vnd.ms-powerpoint | 4 | 8 > video/quicktime | 1 | 25 > (4 rows) > > > > Hoffe das hilft > > Claudia Jürgen > > > > > Am 11.04.2017 um 10:14 schrieb Stefanie Behnke: >> Dear all, >> >> >> >> what is the easiest way to get the number of all bitstreams in a community? >> The number of items in one community is 4460, and I now want to know how >> many bitstreams are there, if possible, ordered by mimetype. >> >> >> >> Thanking you in advance >> >> Stefanie >> > -- > Claudia Juergen > Eldorado > > Technische Universität Dortmund > Universitätsbibliothek > Vogelpothsweg 76 > 44227 Dortmund > > Tel.: +49 231-755 40 43 > Fax: +49 231-755 40 32 > [email protected] > www.ub.tu-dortmund.de > > Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist > ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese > E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und > vernichten Sie diese Mail. Vielen Dank. > Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen > ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform > (mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen > Schriftstücks per Telefax erfolgen. > > Important note: The information included in this e-mail is confidential. It > is solely intended for the recipient. If you are not the intended recipient > of this e-mail please contact the sender and delete this message. Thank you. > Without prejudice of e-mail correspondence, our statements are only legally > binding when they are made in the conventional written form (with personal > signature) or when such documents are sent by fax. > > -- > You received this message because you are subscribed to the Google Groups > "DSpace Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-community. > For more options, visit https://groups.google.com/d/optout. > -- Claudia Juergen Eldorado Technische Universität Dortmund Universitätsbibliothek Vogelpothsweg 76 44227 Dortmund Tel.: +49 231-755 40 43 Fax: +49 231-755 40 32 [email protected] www.ub.tu-dortmund.de Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und vernichten Sie diese Mail. Vielen Dank. Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen Schriftstücks per Telefax erfolgen. Important note: The information included in this e-mail is confidential. It is solely intended for the recipient. If you are not the intended recipient of this e-mail please contact the sender and delete this message. Thank you. Without prejudice of e-mail correspondence, our statements are only legally binding when they are made in the conventional written form (with personal signature) or when such documents are sent by fax. -- You received this message because you are subscribed to the Google Groups "DSpace Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-community. For more options, visit https://groups.google.com/d/optout.
