Skip to main content
ExLibris

Knowledge Assistant

BETA
 
Back
Rosetta
Ex Libris Knowledge Center
  1. Search site
    Go back to previous article
    1. Sign in
      • Sign in
      • Forgot password
  1. Home
  2. Rosetta
  3. Product Documentation
  4. Rosetta Staff Users Guide
  5. Introduction
  6. Searching and Reporting For All Staff
  7. Reports Available in Rosetta

Reports Available in Rosetta

  1. Last updated
  2. Save as PDF
  3. Share
    1. Share
    2. Tweet
    3. Share

 

  1. Reports Available in Rosetta
    1. ALTERNATIVES_EVALUATION
    2. APPLIBRARY
    3. APPLICATION_LIBRARY_EVENTS
    4. AUTO_EVALUATION
    5. AUTO_EVALUATION_PER_REP
    6. BITSTREAM_VIEW
    7. CLASSIFICATION_LIBRARY_EVENTS
    8. CLASSIFICATION_PROPERTY
    9. COLLECTIONS_REPORT
    10. COMMITS_TO_PERMANENT_BY_TYPE
    11. DELETED_IEs
    12. DELIVERY_STATISTICS
    13. DEPOSIT_ACTIVITIES_PER_MF
    14. DEPOSIT_ACTIVITIES_PER_MT
    15. DEPOSIT_ACTIVITY_EVENTS
    16. DEPOSIT_ACTIVITY_HISTORY
    17. EVALUATION_RESULTS
    18. EVENT_HISTORY
    19. EVENT_KEYS
    20. EVENT_STATISTICS
    21. EVENTS
    22. EXTRACTOR_LIBRARY_EVENTS
    23. FILE_TYPE_GROUPS_IN_PERMANENT
    24. FILES_IGNORED - FILE_EXTENSION_MISMATCH
    25. FILES_IGNORED - FORMAT_VALIDATION_ERROR
    26. FILES_IGNORED - MD_ERROR
    27. FORMAT_APPLICATIONS
    28. FORMAT_LIBRARY
    29. FORMAT_LIBRARY_EVENTS
    30. FORMAT_RISKS
    31. FORMATS_AT_RISK
    32. FORMATS_BREAKDOWN
    33. FORMATS_PER_CLASSIFICATION_GROUP
    34. HOMEPAGE_DASHBOARD
    35. IES_BY_SIP_ID
    36. IE_EVENTS
    37. IES_PERMANENT_LIST
    38. IES_TO_BE__DELETED
    39. INTELLECTUAL_ENTITIES_DELIVERED
    40. LOCAL_APPLICATION_LIBRARY
    41. LOCKED_IEs
    42. MANUAL_EVALUATION
    43. MATERIAL_FLOW_LIST
    44. METADATA_FORM_LIST
    45. MOST_VIEWED_OBJECTS
    46. NEW_MONOGRAPHS_IN_PERMANENT
    47. NEW_PERIODICALS_IN_PERMANENT
    48. PERMANENT_INDEX
    49. PRESERVATION_EXECUTION_HISTORY
    50. PROCESS_EXECUTION_HISTORY
    51. PRODUCER_DEPOSITS
    52. PRODUCER_DEPOSITS_EMAIL
    53. PRODUCER_EMAIL_IE_VIEWS
    54. PRODUCER_GROUP_DEPOSITS
    55. PRODUCER_PROFILES_LIST
    56. PRODUCERS_LIST
    57. PUBLISHING_STATISTIC
    58. REPOSITORY_STATS_A
    59. REPOSITORY_STATS_B
    60. REPOSITORY_STATS_D
    61. RISKLIBRARY
    62. SIP_DETAILS
    63. SIP_DETAILS_BY_DEPOSIT_ID
    64. SIP_PROCESSING_STATS_PIE
    65. SIPS_DASHBOARD
    66. SIPS_STATS
    67. STRUCTURAL_IES_REPORT
    68. SUBMISSION_JOB_DETAILS
    69. SUB_JOB_DET_BY_JOBNAME_EXECDATE
    70. SUB_JOB_DET_BY_SOURCEDIR
    71. TOTAL_PRODUCER_GROUP_DEPOSITS
    72. UPLOADS_REPORT
    73. USER_DETAILS

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.

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)

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.
View article in the Exlibris Knowledge Center
  1. Back to top
    • Running and Viewing Reports
    • Submission Information Package (SIP) Overview
  • Was this article helpful?

Recommended articles

  1. Article type
    Reference
    Product
    Rosetta
  2. Tags
    This page has no tags.
  1. © Copyright 2026 Ex Libris Knowledge Center
  2. Powered by NiCE Knowledge Management ®
  • Term of Use
  • Privacy Policy
  • Contact Us
2025 Ex Libris. All rights reserved