Skip to Content
author's profile photo Former Member
Former Member

Document Metrics in KM

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!


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Feb 10, 2005 at 03:08 PM

    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


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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.