Request Report of Date When User Was Created

William_Bennecke__(ERNYOUAdmin_(Delete)_2276563)

Does anyone know how to create a LiveReport showing the date of when a user was created and their corresponding uid in LiveLink?Any help on this would be appreciated.Thanks!william.bennecke@ey-as.com

eLink User

Message from Marie Lindsay via eLinkThis report gets the date the user was created, the user's id, name, loginname, and department name. The creation date is assumed to be the date thatthe user's personal workspace was created (since KUAF doesn't store the datethe user was created--maybe it should).select dtree.createdate, a.firstname+ ' ' + a.lastname AS user_name, a.nameAS user_login, a.id as user_id, b.name AS group_name from kuaf a, kuaf b,dtree where a.deleted = 0 and a.type=0 and dtree.createdby = a.id anddtree.subtype = 142 and a.groupid = b.id order by dtree.createdate> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Monday, August 27, 2001 12:28 PM> To: eLink Recipient> Subject: Request Report of Date When User Was Created>>> Request Report of Date When User Was Created> Posted by ERNYOUAdmin on 08/27/2001 01:24 PM>> Does anyone know how to create a LiveReport showing the date of> when a user was created and their corresponding uid in LiveLink?>> Any help on this would be appreciated.>> Thanks!>>> william.bennecke@ey-as.com>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe