Need a livereport to count the items added to a folder

Paul Langham

We are looking for a live report to count the items added to a particular folder by a user within a certain date range. These items include all emails, attachments, folders. We want to be able to input the DataID of the particular folder and the report will pick up all items added including items added to all subfolders etc within the structure.The output will be the User FirstName, User Surname, Count of items they have added within this folder structure during the given date range.We are running SQL Server database not oracle.If someone could help us with this it would be much appreciated.

Appu_Nair

Take a look at this thread which gives you almost like Oracle's Connect byhttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=4610762&objAction=view&show=2A hierarchcal tree walk simplicity is not coded in SQLserver so you have to create a function,stored proc etc to do similar stuff in SQLserver.Once you create the function the other info can easily be found by pulling kuaf.id as dtree.userid.Also talk to OT people if the Dtreeancestors table is anywhere reliable for doing this kind of analytics.I am not a great fan of that table because I am told you ahve to have several things working correctly.I still think the SQLserver function should give you the most accurate results.