Project Participants - Livereport needed

We have several hundred projects within a departmental folder. I would like to know if there is a Livereport out there that lists all projects and their particpants (user/group names). Thanks

Find more posts tagged with

Comments

eLink User

Message from Nair, Krishnankutty N. via eLinkNot a livereport but sql to do it.Typical SQL queries choke on livelink projects(if you are after stuff inthem) since they have a negative dataid.Queries in Oracle can bewritten using the ABS of the dataid and there is a bunch of themwrittenin this area.They are very inefficient.Try oscript or PL/SQL For the immediate qn,select * from dtree where subtype=202 \\ will give you all projects inyour livelink instanceTake one of these and look up the relation in KUAF (you will seeMembers,guests,co-ordinatorsFor eg if you get dataid of a project as 45547253 to see who areco-ordinators,guests,membersyou can do TYPE in KUAF is dataid in dtree I believe, select * from kuaf where type=45547253Or even this might work select * from kuaf where type in( select dataid from dtree wheresubtype=202)To get the actual people/groups you might have to do the id of KUAFinto KUAFCHILDRENsomething likeselect * from kuafchildren a where a.ID=51684249 (this is a coordinatorin one of the projects) It is fun try it....-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Thursday, April 27, 2006 11:57 AMTo: eLink RecipientSubject: Project Participants - Livereport neededProject Participants - Livereport neededPosted by Nair, Ajay on 04/27/2006 12:53 PMWe have several hundred projects within a departmental folder. I wouldlike to know if there is a Livereport out there that lists all projectsand their particpants (user/group names). Thanks[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Anil_Nair_(anair_(Delete)_3573143)

Thank you. I will give it a shot.

Steve_McDonough

Hello Ajay,We don't use Livelink projects here (I should say that we haven't implemented the feature yet). At one point I downloaded and saved this Livereport in anticipation of using it once we did implement it. Hopefully, you will be able to use the report as a basis for creating your own Livereport.Hope it helps,Leon

Krishnankutty_Nair

I finally managed to write one.I ask the people to select a project and that forms the input to the query.If co-ordinators are groups it will list them ,no effort is made to go after the real people.the relevant sql is this.Our users are OK with thisselect name,firstname,lastname,id,type from kuaf where id in ( select childid from kuafchildren a where a.ID=(select a.id from kuaf a where a.type=%1 and a.name='Coordinators'))I also show you the settings I gave for the LR in the screen shot

Pfizer_Developers

Here is the SQL you'll need should you decide to expand on the Coordinators, Members and Guests groups for a projec:SELECT k.childid FROM kuafchildren k START WITH k.ID IN (243569+1 /* Coordinators */ , 243569+2 /* Members */, 243569+3 /* Guests */) CONNECT BY k.ID = PRIOR k.childidwhere 243569 is the project id.Now something I need help with:Has anyone written a report to determine which of the projects coordinators, members and/or guests have logged in the past x months or more difficult, who have NOT logged in the past x months.Am I correct? - there is no table that records the last login date except the daudit trail in the dauditnew/daudit tables?ThanksMohsin Jessa

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Mohsin,Yup, just what you can see in DAudit / DAuditNew.As most customers use Directory Services, you will not be able to relyon the Login event.I did a query for something similar on a site recently but unfortunatelydo not have that SQL any more.I guess you could do something with the following snippet.... select userid, max(auditdate) from daudit having max(auditdate)>= sysdate-30 group by useridto find who used the system in the last 30 days and select userid, max(auditdate) from daudit having max(auditdate)< sysdate-30 group by useridfor those who have not used it in the last 30 days.RegardsLindsayUK-support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 05 June 2006 14:25To: eLink RecipientSubject: Expanding the project membershipExpanding the project membershipPosted by Developers, Pfizer on 06/05/2006 09:21 AMHere is the SQL you'll need should you decide to expand on theCoordinators, Members and Guests groups for a projec:SELECT k.childid FROM kuafchildren k START WITH k.ID IN (243569+1 /* Coordinators */ ,243569+2 /* Members */, 243569+3 /* Guests */) CONNECT BY k.ID = PRIOR k.childidwhere 243569 is the project id.Now something I need help with:Has anyone written a report to determine which of the projectscoordinators, members and/or guests have logged in the past x months ormore difficult, who have NOT logged in the past x months.Am I correct? - there is no table that records the last login dateexcept the daudit trail in the dauditnew/daudit tables?ThanksMohsin Jessa[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Project Participants - Livereport neededhttps://knowledge.opentext.com/knowledge/livelink.exe/open/5678381Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Pfizer_Developers

Hi Lindsay,Thanks for your prompt response and the sample sql.I was afraid so w.r.t. the last login date. Regards,Mohsin Jessa