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.
