How to get the total number of docs in a MAXDB database SAP repository ?

[former_member348281]

Hello

I'm making a report and need to know how many documents are inside of a 1 TB MAXDB datase.

This database is the one used by the Content Server of a SAP ECC system.

Is there any dbmcli command or SAP transaction that indicates the number of different documents if possible by type of document ?

Thanks in advanced

Kind Regards

Sílvia Cardoso

[former_member348281]

Hi Deepak

Thanks for your contribuition.

I have just done what you indicated using dbmcli but those tables are unknown in the MAXDB Database.

Next the output of the commands.

---

dbmcli on SDB>sql_execute select count(*) from DMS_DOC_FILES;

ERR

-24988,ERR_SQL: SQL error

-3008,Invalid keyword or missing delimiter

---

dbmcli on SDB>sql_execute select count(*) from DMS_DOC_FILES

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name:DMS_DOC_FILES

---

dbmcli on SDB>sql_execute select count(*) from Draw

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name:DRAW

Kind Regards

Sílvia Cardoso

[former_member188883]

Hi Silvia,

In SAP ECC there is a report DMS_KPRO_CHECK1 with the help of which you can get a list of documents in your Content server repository with its count.

Use Tcode Se38

Type the Program name DMS_KPRO_CHECK1 .

Fill in the following input parameters

Content Repository = <Name of your content repository>

RFC Destination = SAPHTTPA

Select checkbox Checking KPRO - DMS

Then execute.

Regards,

Deepak Kori

[former_member348281]

Hi Deepak,

Thanks for your reply.

This report only give a list of inconsistencies between the Content Server and the DMS repository (LOIOS List of documents).

It doesn't give the total number of documents, better say attached files in different formats (ZIP, WORD,XLSX,BMP,etc.) to each DMS sheet doc created in the SAP ECC system.

Kind Regards

Sílvia Cardoso

[former_member188883]

Hi,

You can try a sql count statement on table DMS_DOC_FILES and DRAW to find the number of documents.

Regards,

Deepak Kori