Groups and Owners

Message from Greg Kellogg <gkellogg@opentext.com> via eLink

I have a client that needs a Live Report that lists allGroups and the Group Owner. I was wondering if someone had the SQL on hand forthis report.

Thanks.

Greg Kellogg

Open Text Global Services

Certified Livelink Administrator

(361) 815-8950

Find more posts tagged with

Comments

Tim_Hunter

Greg, in Oracle formatSELECT k.name groupname, o.name ownernameFROM kuaf k, kuaf oWHERE k.leaderid = o.id(+)AND k.type = 1AND k.deleted = 0

komments

Message from Greg Kellogg <gkellogg@opentext.com> via eLink

eLink

Thank you Tim.

Greg Kellogg

(361) 815-8950

From: eLinkDiscussion: Open Text Live Reports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 05, 20091:14 PM
To: eLink Recipient
Subject: RE Groups and Owners

RE Groups and Owners		Posted by timothy.hunter.ctr@wpafb.af.mil (Hunter, Tim ) on 2009/08/05 14:09
In reply to: Groups and Owners		Posted by gkellogg (Kellogg, Gregory) on 2009/08/05 13:57

Greg, in Oracle format

SELECT k.name groupname,
o.name ownername
FROM kuaf k,
kuaf o
WHERE k.leaderid = o.id(+)
AND k.type = 1
AND k.deleted = 0

Bhupinder_Singh

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

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

select a.ID, a.name "Group Name", b.name "Group Owner" from KUAF a, KUAF b where a.Type=1 and a.ownerID=b.ID and a.Deleted=0

(you can add ## and a.ownerID<>1000 ## to the end to exclude groups owned by Admin)

The above query assumes you are looking for who created the group when you refer to "ownership", and are not referring to group leaders.

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 05, 2009 1:58 PM
To: eLink Recipient
Subject: Groups and Owners

Groups and Owners

Posted by gkellogg (Kellogg, Gregory) on 2009/08/05 13:57

Message from Greg Kellogg <gkellogg@opentext.com> via eLink

I have a client that needs a Live Report that lists all Groups and the Group Owner. I was wondering if someone had the SQL on hand for this report. Thanks. -- Greg Kellogg Open Text Global Services Certified Livelink Administrator (361) 815-8950