Livereport user list

Eraldo_Rodrilla_(DIVBRA01Admin_(Delete)_2800964)

I'd like to have a report that list all the users in the livelink.

Find more posts tagged with

Comments

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

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

Are you sure? The reason why I ask is that if you have many users, you could put a strain on your web browser if you try to list them all. That's why the Livelink interface added the "More" button a few versions back.

I also wonder why you want a LiveReport, instead of using the Users and Groups page. Is it because you want to see more than a subset of the users at a time?

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, July 25, 2002 4:12 PM
To: eLink Recipient
Subject: Livereport user list

Livereport user list Posted by DIVBRA01Admin (Rodrilla, Eraldo) on 07/25/2002 05:02 PM

I'd like to have a report that list all the users in the livelink.

Eraldo_Rodrilla_(DIVBRA01Admin_(Delete)_2800964)

Maybe, count them will be enough.

Marie_Lindsay_(MLindsay_(Delete)_15608)

That makes it a little easier! This SQL (with the "Auto LiveReport" format) should give you a count of users: select count(*) from kuaf where type = 0If you would like to break it down by department, you could use this SQL: select depts.name, count(users.id) "Count of Users" from kuaf depts, kuaf users where users.groupid = depts.id group by depts.name order by depts.name

eLink User

Message from Sean M Alderman via eLinkOn Fri, 2002-07-26 at 11:21, eLink Discussion: Livelink LiveReportsDiscussion wrote:> Count of users> Posted by MLindsay on 07/26/2002 11:12 AM> > That makes it a little easier! This SQL (with the "Auto LiveReport" format) should give you a count of users:> > select count(*) from kuaf where type = 0You may want to not count your deleted users by adding -and deleted = 0 to the end of the above sql statement.> > If you would like to break it down by department, you could use this SQL:> > select depts.name, count(users.id) "Count of Users"> from kuaf depts, kuaf users> where users.groupid = depts.id> group by depts.name > order by depts.name> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Livereport user list> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2801925&objAction=view> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > -- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795Calling a windowed operating system "Windows" is like naming anautomobile "Wheels."