Count of all scanned and all imported docs in a year?

[Rhianon_Price2]

One of my departments just asked for counts of all the documents they have 1) scanned and 2) imported in calendars years a) 2019 and b) 2020; they want this for a report they need to provide next week. I've looked at the Scan Reports and they don't meet this need. Can anyone suggest another tool that would do this, or some SQL that would return the desired info? Thank you!

Rhianon Price

Texas Woman's University

[Rhianon_Price2 · Accepted solution]

I found this in another post, which has helped point me to one of the tables I need to query this data. Can anyone point me to where Import Type is stored? Thanks!

SELECT itg.itemtypegroupname AS 'Document Type Group',
dt.itemtypename AS 'Document Type',
COUNT(id.itemnum) AS 'Document Count'
FROM hsi.itemdata id
JOIN hsi.doctype dt
ON dt.itemtypenum = id.itemtypenum
JOIN hsi.itemtypegroup itg
ON itg.itemtypegroupnum = dt.itemtypegroupnum
GROUP BY itg.itemtypegroupname, dt.itemtypename
ORDER BY itg.itemtypegroupname, dt.itemtypename

[Roger_Linhart]

@Rhianon Price the following forum post asks a similar question. I think you'll find the information you need here: https://community.hyland.com/forum/threads/79906-onbase-database-query

[Rhianon_Price2]

Thanks, Roger! I was able to work out a query to meet my users' needs. I hadn't hit upon the article you referenced in my searches, but you're right, that's a good one.

Cheers!