...
ODBC-based reporting tools work by running one or more SQL query against the underlying DSpace database. You can find some examples in
| Jira |
|---|
| server | DuraSpace JIRA |
|---|
| key | DS-1645 |
|---|
|
which illustrate the kinds of SQL joins that you'll be looking at using. Note the use of item.in_archive = 't' and item.withdrawn = 'f' to check whether the item has been deleted or withdrawn respectively.
A diagram of the DSpace database schema is included in the Storage Layer section of the DSpace documentation.Note that some data (such as access stats) aren't held in the SQL database but in solr. Access details for these can be found at Solr#AccessingSolr.
...