Generate the Report for the published Items based on Date

Hi,

In our project daily many users are publishing their Content Instances. We want to generate the reports like how many items published today by which user.

If I searched the items based on the modified date using advanced serach in VCM. But the Publishing date/Unpublish date are not returning any values.

I want to generate the report based on datewise. Could you please advise me, where to get the information and how to fetch the data from DB.

Regards,
Jayaram

Find more posts tagged with

Comments

Juan_Carlos_Ruiz_Cubo_(VILT)

Hi Jayram,

I assume that you don't have the license for VCM Audit neither basic or enhanced versions. This product contains those reports.

If you need to filter by username probably you will find difficulties trying to get that info from database since

VCM register the publish as made by system user.

Regards

Juan Carlos Ruiz Cubo

VILT
http://www.vilt-group.com/
Avenida de la Albufera 321, 3º 2ª
28031 Madrid
Tel: +34 913052553
Móvil: +34 696594065
Fax: +34913320833
Email: juancarlos.ruiz@vilt-group.com

From: eLink Entry: Discussion Group - Web Experience Management [mailto:v7webcontentmanagement@elinkkc.opentext.com]
Sent: viernes, 26 de octubre de 2012 13:34
To: eLink Recipient
Subject: Generate the Report for the published Items based on Date

Generate the Report for the published Items based on Date

Posted by jayaram.ponnusamy@aexp.com (Ponnusamy, Jayaram) On 10-26-2012 07:29

Hi,

In our project daily many users are publishing their Content Instances. We want to generate the reports like how many items published today by which user.

If I searched the items based on the modified date using advanced serach in VCM. But the Publishing date/Unpublish date are not returning any values.

I want to generate the report based on datewise. Could you please advise me, where to get the information and how to fetch the data from DB.

Regards,
Jayaram

[To post a comment, use the normal reply function]
Forum:	Discussion Group - Web Experience Management
Content Server:	Knowledge Center

Juan_Carlos_Ruiz_Cubo_(VILT)

Hi Jayram,

I assume that you don't have the license for VCM Audit neither basic or enhanced versions. This product contains those reports.

If you need to filter by username probably you will find difficulties trying to get that info from database since

VCM register the publish as made by system user.

Regards

Juan Carlos Ruiz Cubo

VILT
http://www.vilt-group.com/
Avenida de la Albufera 321, 3º 2ª
28031 Madrid
Tel: +34 913052553
Móvil: +34 696594065
Fax: +34913320833
Email: juancarlos.ruiz@vilt-group.com

Generate the Report for the published Items based on Date

Posted by jayaram.ponnusamy@aexp.com (Ponnusamy, Jayaram) On 10-26-2012 07:29

Hi,

In our project daily many users are publishing their Content Instances. We want to generate the reports like how many items published today by which user.

If I searched the items based on the modified date using advanced serach in VCM. But the Publishing date/Unpublish date are not returning any values.

I want to generate the report based on datewise. Could you please advise me, where to get the information and how to fetch the data from DB.

Regards,
Jayaram

[To post a comment, use the normal reply function]
Forum:	Discussion Group - Web Experience Management
Content Server:	Knowledge Center