Total number of documents/content in your WebCenter Content/UCM
Often business would like to know the total number of documents in Oracle WebCenter Content (UCM). The following SQL queries against the OCS database can be used to determine this. Including revisions: SELECT COUNT(*) FROM DOCMETA; Only documents: SELECT COUNT(*) FROM REVISIONS WHERE DREVRANK = 0; –DREVRANK=0 indicates latest revision Both DOCMETA and REVISIONS are […]
Total number of documents/content in your WebCenter Content/UCM Read More »