We use SQL Server and I saw a stored proc on the forum post from awhile ago. We are using CS16. I was wondering if anyone has created a report using SQL Server to audit a folder for # or Records and Size of folder?
While I’ve written little in MS/SQL Server, I do know there are some differences in the way data types are handled than in ORACLE.
You can use “dtreeancestors” to follow on all sub-items from a Folder.
You can use “dtree.childcount” to determine the number of Sub-items (documents or folder) under a folder.
You can use “dversdata.datasize” to count up the bytes of the top version or even accumulate the bytes for all versions of each document.
Oracle has a way to traverse down a path in sequence. You’d have to search the internet for the SQL Server equivalent (if any). “CONNECT_BY” combined with “SYS_CONNECT_BY_PATH”. SQL Server won’t use these commands, but a search will show you what to do.
Colin J. Schmidt
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, August 23, 2017 3:59 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Report - Folder Audit
Report - Folder Audit
Posted by Boudreau, David On 08/23/2017 03:53 PM
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center CS16
The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.
Thanks your response. We found an OOB report that was in our Reports that did what we were asking. I just thought that it wouldn't be an OOB report. unless someone wrote it long time ago.
it is called Folder & Document Listing. If someone does not have it. It looks like it is calling a function. folderlisting. let me know and I can ask our DBA for the script.
