Not really sure what you are looking forhere, your request is a little ambiguous. However, here is a query that willget all active users, their Department Group, and the date the user was createdand the date the Department Group was created. You should be able to learn enoughfrom this query to put together more complex queries, for instance if you wantedto find all groups a user is a member of (will most likely require a recursivefunction to retrieve):
/* SQL Server */SELECT k1.LastName + ', ' + k1.FirstName + ' (' +name + ')' AS "User Full Name", k2.Name AS"Group Name", d.CreateDateAS "Date User Created", a.AuditDateAS "Date Group Created"FROM KUAF k1 INNER JOINKUAF k2 ON k1.GroupID = k2.ID INNER JOINDTree d ON d.DataID = k1.ID INNER JOINDAuditNew a ON k2.ID = a.UserIDWHERE k1.Type = 0 AND k1.Deleted = 0 AND a.AuditID = 1ORDER BY 2,1/* Oracle */SELECT K1.LASTNAME || ', ' || K1.FIRSTNAME || '(' + NAME + ')' AS FULLNAME, K2.NAME, D.CREATEDATEAS "DATE USER CREATED", A.AUDITDATEAS "DATE GROUP CREATED"FROM KUAF K1 INNER JOINKUAF K2 ON K1.GROUPID = K2.ID INNER JOINDTREE D ON D.DATAID = K1.ID INNER JOINDAUDITNEW ON K2.ID = A.USERIDWHERE K1.TYPE = 0 AND K1.DELETED = 0 AND A.AUDITID = 1ORDER BY 2,1
From: eLinkDiscussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Thursday, March 27, 20088:34 AMTo: eLink RecipientSubject: Need Report Username,Department, Date Created
Need Report Username, Department, Date Created
Posted by pstegl (Stegl, Peter) on 03/27/2008 11:30 AM
Hi, I'm asked to create an report,with all user it's department and the date it was created. system Livelink 9.5.0 Anyone with an idea? Regards Peter
