List of Groups and its Users in Report (column) format

Colleen_Yorke_(infusa01admin_-_(deleted))

In V9.1, I am trying to figure out how to set up a Live Report to just list the Groups and it's Users, in a nice format.First Column=Username Second Column=UserIDThird Column=Groups it belongs to

Find more posts tagged with

Comments

Timo_Schrama_(citeeuser1_-_(deleted))

On SQL we use the following report. It displays per row 'User, ID, Group'.select distinct k1.name "User", k1.id "ID", k2.name "User Group" from kuaf k1, kuaf k2, kuafchildren kc where k1.type=0 and k1.userprivileges<>14 and k2.type=1 and k2.id=kc.id and k1.id=kc.childid order by 1,2Good luckTimo SchramaCiteet.schrama@citee.nl

Colleen_Yorke_(infusa01admin_-_(deleted))

Thanks Timo,I tried this and I'm getting an error 'An Unknown Feature was specified'.Any clue what this might be ?

Bhupinder_Singh

Message from Bhupinder Singh via eLinkTry setting the report format to "AutoLiveReport" instead of the default"LiveReport" format, if not done so already.- Bhupinder-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Tuesday, September 16, 2003 11:26 AMTo: eLink RecipientSubject: Error appearing on my end for this reportError appearing on my end for this reportPosted by Yorke, Colleen on 09/16/2003 11:16 AMThanks Timo,I tried this and I'm getting an error 'An Unknown Feature was specified'.Any clue what this might be ?[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: List of Groups and its Users in Report (column) formathttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3157724&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe