Reports Available in Rosetta
Reports Available in Rosetta
Additional reports available in Rosetta may not be set up in your system. The full list includes the following:
ALTERNATIVES_EVALUATION
Description: The list of Preservation evaluations with plan ID and alternative ID.
APPLIBRARY
Description: Application Library information (prsv00.HPRAPPLIBRARY).
APPLICATION_LIBRARY_EVENTS
Description: All events related to the Application Library.
AUTO_EVALUATION
Description: The results of the automatic evaluations.
AUTO_EVALUATION_PER_REP
Description: The results of the automatic evaluations per representation.
BIRT_GENERAL_PARAMETERS
Description: All BIRT general parameters.
BITSTREAM_VIEW
Description: The BitStream information (rep00.HDEBITSTREAMREF) that allows the viewer to run reports based on this information
CLASSIFICATION_LIBRARY_EVENTS
Description: All the events related to the Classification Library.
CLASSIFICATION_PROPERTY
Description: The classification group’s significant mapping properties (including mapping to F fields) (prsv00.HPRCLASSIFICATIONPROPERTY).
COLLECTIONS_REPORT
Description: The collection structure and associated intellectual entities.
COMMITS_TO_PERMANENT_BY_TYPE
Description: The number of commits to the permanent repository by object type.
DELETED_IEs
Description: Lists all IEs that have been deleted or purged within a given time frame.
DELIVERY_STATISTICS
Description: A list of the most viewed objects.
DEPOSIT_ACTIVITIES_PER_MF
Description: The amount of deposit activities per material flow.
DEPOSIT_ACTIVITIES_PER_MT
Description: The number of deposit activities per material type.
DEPOSIT_ACTIVITY_EVENTS
Description: All the events for each deposit activity.
DEPOSIT_ACTIVITY_HISTORY
Description: All the deposits so far with minimal information.
EVALUATION_RESULTS
Description: The evaluation results.
EVENT_HISTORY
Description: Takes an event ID and date range and returns a list of PIDs, event dates, and event key values.
EVENT_KEYS
Description: The keys for the events stored in the EVENTS view.
EVENT_STATISTICS
Description: The statistical information gathered by the statistical analyzer for the events as listed in the events spreadsheet.
EVENTS
Description: All the events in the system.
EXTRACTOR_LIBRARY_EVENTS
Description: Events related to the Extractor Library.
FILE_TYPE_GROUPS_IN_PERMANENT
Description: The types of the various files with quantities and percentage.
FILES_IGNORED - FILE_EXTENSION_MISMATCH
Description: Number of files per format ID that were ignored by the File Extension Mismatch rule.
FILES_IGNORED - FORMAT_VALIDATION_ERROR
Description: Number of files for which a format validation error has been ignored due to an automatic rule, grouped by file format ID.
FILES_IGNORED - MD_ERROR
Description: Number of files per format ID that were ignored by the MD Error rule, grouped by file format ID.
FORMAT_APPLICATIONS
Description: The Format/Application connection (prsv00.HPRFORMATAPPLICATIONS).
FORMAT_LIBRARY
Description: Format Library information (prsv00.FORMATLIBRARY).
FORMAT_LIBRARY_EVENTS
Description: Events related to Format Library.
FORMAT_RISKS
Description: Risks per format.
FORMATS_AT_RISK
Description: A breakdown of SIPs by module and stage.
FORMATS_BREAKDOWN
Description: List of file formats and their occurrence throughout the repository.
This report is refreshed by the Refresh Materialized Views job. For more information, see the System, Background, and Operational Jobs section of the System Administration Guide.
FORMATS_PER_CLASSIFICATION_GROUP
Description: The association of a format to a classification group
Refreshed every 12 hours.
HOMEPAGE_DASHBOARD
Description: The information presented to the user on the home page:
- SIPs Having Technical Issues
- SIPs Waiting For Approval
- SIPs Waiting For Arrangement
- SIPs Waiting For Assessment
- Deposit Activities
- Files In Permanent
- Active Producers
IES_BY_SIP_ID
Description: The intellectual entities for a given SIP.
IE_EVENTS
Description: Events for an individual intellectual entity. Parameter = IE ID.
IES_PERMANENT_LIST
Description: The list of IEs with their URLs in the permanent repository.
IES_TO_BE__DELETED
Description: All IEs that are about to be deleted in a given time frame due to retention policies.
INTELLECTUAL_ENTITIES_DELIVERED
Description: Lists key details about access to each digital object:
- PID
- Title
- End user ID accessing the object
- Date and time of access
- End user ID accessing the object (guest for users that are not logged in)
There are two versions of this report. One contains user details, but is hidden in Rosetta unless configured in the BIRT report mapping table to appear, and the other is anonymized.
LOCAL_APPLICATION_LIBRARY
Description: A list of applications in the local application library.
LOCKED_IEs
Description: A list of locked IEs.
MANUAL_EVALUATION
Description: The manual evaluation results.
MATERIAL_FLOW_LIST
Description: A list of the material flows currently defined in the system.
METADATA_FORM_LIST
Description: The metadata forms available in the system.
MOST_VIEWED_OBJECTS
Description: A list of viewed objects ordered by the number of views.
NEW_MONOGRAPHS_IN_PERMANENT
Description: Monographs (material type = ‘MON’).
NEW_PERIODICALS_IN_PERMANENT
Description: Periodicals (material type = ‘PRD’).
PERMANENT_INDEX
Description: The permanent index table which lists all objects stored in the permanent repository.
PRESERVATION_EXECUTION_HISTORY
Description: The history of migrated IEs of executed signed off plans.
PROCESS_EXECUTION_HISTORY
Description: The history of all the existing processes in the system with their statuses.
PRODUCER_DEPOSITS
Description: All the deposits performed so far.
PRODUCER_DEPOSITS_EMAIL
Description: A list of deposit activities.
PRODUCER_EMAIL_IE_VIEWS
Description: The number of IE views.
PRODUCER_GROUP_DEPOSITS
Description: All the deposits with a field showing to which Producer group the Depositor belongs.
PRODUCER_PROFILES_LIST
Description: All existing Producer profiles.
PRODUCERS_LIST
Description: All the Producers currently in the system.
PUBLISHING_STATISTIC
Description: The number of published intellectual entities by publishing configuration.
REPOSITORY_STATS_A
Description: The number of files for groups of different sizes.
REPOSITORY_STATS_B
Description: The list of MIME types and the number of files in each type.
REPOSITORY_STATS_D
Description: Shows numbers regarding the permanent preservation.
RISKLIBRARY
Description: The risks library (prsv00.HPRRISKLIBRARY).
SIP_DETAILS
Description: A list of SIP details by SIP ID.
SIP_DETAILS_BY_DEPOSIT_ID
Description: A list of SIP details by SIP ID by Deposit Activity ID.
SIP_PROCESSING_STATS_PIE
Description: The number of SIPs in each SIP processing stage.
SIPS_DASHBOARD
Description: A breakdown of SIPs by module and stage.
SIPS_STATS
Description: All the SIPs currently in the system. This is used for the report SIPs - Status and Events. The report shows the totals and the details for each stage in the system.
STRUCTURAL_IES_REPORT
Description: Structural IE hierarchies and associated structural IEs. Select All to run the report on all IEs or enter the PIDs for the IEs on which you want to run the report.
SUBMISSION_JOB_DETAILS
Description: No OOTB report (view only). Contains submission job details including the load directory, generated SIPs and their respective statuses.
SUB_JOB_DET_BY_JOBNAME_EXECDATE
Description: a list of Submission Job Details by Job Name and Execution Date.
SUB_JOB_DET_BY_SOURCEDIR
Description: Submission Job Details by Source Dir.
TOTAL_PRODUCER_GROUP_DEPOSITS
Description: The counts of deposits for each Producer group.
UPLOADS_REPORT
Description: A list of deposits by date range.
USER_DETAILS
Description: Information about the user, roles, and roles parameters currently in the system.