livereport for currently logged in users(for a week) and documents added(per week)

Hi Team,

I am looking for a live report which will provide me volumetrics details for users, documents, business workspaces created per week as per below

1. Number of users accessed content server application in last week

2. Number of documents added into content server last week

3. Number business workspaces created last week

Appreciate your help on this

Best Regds

Farooq

Find more posts tagged with

Comments

Farooq_Mohammed

I am on Content Server 10.5 with SQL Server as database

Greg Griffiths

Farooq,

The provided LiveReports should give you somewhere to start, then I would recommend you get a copy of the schema document, which does require an NDA, and look at DTREE and DAUDITNEW as these two tables should provide most of what you need, link to KUAF for the user info if required. The OT Schema companion is certainly useful as well - https://knowledge.opentext.com/knowledge/cs.dll/13682418/Content_Server_Schema_Companion_Reference_Guide.pdf?func=doc.Fetch&nodeid=13682418&vernum=13.

In addition a good knowledge of SQL, both generic and specific to the DB you are using is helpful, along with a little DBA/Perf knowledge. A good grounding can also be found via the OT course - https://www.opentext.com/training/coursedetails.html?id=2310

Alok_Varma

1. Number of users accessed content server application in last week

Select
Count(Distinct PerformerID) "Count"
From DAuditNew
where AuditID=23 and AuditDate Between %1 and %2

2. Number of documents added into content server last week
3. Number business workspaces created last week

Select
Count(DataID) "Count"
From DAuditNew
where AuditID=1
And SubType=144
And AuditDate Between %1 and %2
And PerformerID=4567926

Note :
AuditID
1 = Create any CS object
23 = Login

SubType
144 = Document

Parameters (Param field):
%1 : Last Week-Start
%2 : Last Week-End