Need Number of Items added by User

Hi,I need an Report which returns the number of Items added to Livelink by an specific User.We Run Oracle 9.2.This is to find out users that just log on to Livelink, because they have to and doesn't use it.Someone with an idea?peter

Find more posts tagged with

Comments

Peter Stegl

Our LL Version is 9.5.0

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

How about something like this:

Inputs:

Type: User

Prompt: Select a user

SQL:

select count(*) from DTREE where CreatedBy=%1

Param %1: User Input 1

Report Format: Auto LiveReport

This will allow you to pick a user and should give back the number of items he/she created in the system. You should confirm validity of the output yourself for a couple of users (or a test user), prior to using it for all users.

Hope that helps...

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, November 01, 2006 4:15 AM
To: eLink Recipient
Subject: Need Number of Items added by User

Need Number of Items added by User

Posted by pstegl (Stegl, Peter) on 11/01/2006 04:10 AM

Hi,

I need an Report which returns the number of Items added to Livelink by an specific User.

We Run Oracle 9.2.

This is to find out users that just log on to Livelink, because they have to and doesn't use it.

Someone with an idea?

peter

Peter Stegl

Hello Bhupinder,it works! Many thanks!regardsPeter