I need to generate a report that must contain the information for all the documents from FileNet ECM repository along with the following details,

1. Folder filed in
2. Complete File Path
3. Content Size

I have MS SQL server as a database and FileNet is on-premises

Need a little help to write a query

------------------------------
Abu Ammar Abbasi
------------------------------

Hi,

What is the purpose of the report please?  Depending upon purpose there might be other ways to achieve the end result.

Regards
Phil.

------------------------------
PHILIP RIMMINGTON
------------------------------

Hello Phillip -

Does purpose really matters? We should treat this question as reporting capabilities within ICP4BA. Seems this lacks here and we always seems to find alternate ways.

No wonder few clients are planning to move away from ICP4BA due to lack of OOTB reporting capabilities.

Nitin

------------------------------
Nitin Upasani
------------------------------

Original Message:
Sent: Fri December 23, 2022 04:27 AM
From: PHILIP RIMMINGTON
Subject: IBM FileNet - Generate a report for Files and Folders along with content size

Hi,

What is the purpose of the report please?  Depending upon purpose there might be other ways to achieve the end result.

Regards
Phil.

------------------------------
PHILIP RIMMINGTON
------------------------------