11-29-2023 07:38 AM
hello,
I am new to Onbase administration. How do get a report on total count of documents in OnBase?
12-13-2023 06:30 AM
Hi
You can run the following query in the database. Keep in mind, depending on the number of documents in the system, this query may take a while to run, but will return an accurate count.
SELECT COUNT(*) FROM hsi.itemdata WITH (NOLOCK)
Alternatively, you could run the following which will be quicker, but might be less accurate depending on when statistics were last updated ...
SELECT CONVERT(bigint, rows) FROM sysindexes WHERE id = OBJECT_ID('hsi.itemdata') AND indid < 2
Take care.
12-14-2023 03:07 PM
the status field on the itemdata table might be important too, unless you want deleted documents. Though, technically a request for a total count would include the deleted documents...
12-18-2023 05:39 AM
To
https://community.hyland.com/gallery/items/53200-database-reporting-guide
12-18-2023 08:40 AM
This script itemizes the number of documents per doc type.
SELECT itg.itemtypegroupname as DocTypeGroup, dt.itemtypename as DocType, count(itemnum) as DocTypeCount
FROM hsi.itemdata id with(nolock)
JOIN hsi.doctype dt with(nolock) ON id.itemtypenum = dt.itemtypenum
JOIN hsi.itemtypegroup itg with(nolock) ON dt.itemtypegroupnum = itg.itemtypegroupnum
GROUP BY itg.itemtypegroupname, dt.itemtypename
order by count(itemnum) desc
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.