Document Metrics in KM

[Former Member]

Hi -

We would like to be able to generate reports that give us KM metrics such as 1) How many documents exist in KM? 2) When was the last time a document was checked out / modified?

I noticed in another thread that you can check the DB tables wcm_sub_subscriptions and wcm_sub_resources to get some statistics on subscriptions. Are there tables in the databases that we can query to get information on documents?

Thank you for your help!

Jo

[detlev_beutner · Accepted solution]

Hi Jo,

if you don't need this statistics only once (and the first use, throw it away), I would definitely advise you <i>not</i> to use the DB for such things. The DB scheme should be totally transparent and is subject to change without notice (and the scheme <i>is</i> changed regulary).

The things you want to achieve are achievable by implementing via KM API. So you could rush through KM to read this (will take some time; anyhow, you can define which repositories / file types etc. to give respect to.

Or you can implement repository services which always count the actual number of docs under them, the last changed doc etc. (you will need an inital run for the numbers of docs).

Hope it helps

Detlev

PS: Please consider rewarding points if it was helpful. Thanks in advance!

[Former Member · Accepted solution]

Hi Detlev -

Thanks very much for the quick response!

Do you happen to know off hand where I'd find documentation on repository services - or even the KM API's?

I'm new to the portal and KM and where things are are still a little bit of a mystery to me.

Jo

[detlev_beutner · Accepted solution]

Hi Jo,

> where I'd find documentation on repository services

See https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/java development with the kmc platform.pdf and https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/how to develop with the repository framework apis.pdf

The documentation of how to implement a repService is still not the best, anyhow, once you have done it, you will love it, because it has it's own magic.

Also see and and

> the KM API's

https://media.sdn.sap.com/html/submitted_docs/nw_kmc/javadoc/index.html

Ik hoop dat het helpt, doei

Detlev

[Former Member · Accepted solution]

Detlev -

Thanks for the detailed response. This will be a great help!